On Sat, 2013-11-23 at 15:18 -0700, Greg Woods wrote: > I > played games trying to give Mysql more resources in my.cnf, but I don't > think that's really where the problem is.
It turns out that *is* where a problem is, but there were absolutely no error messages anywhere to indicate this, other than the generic "cannot connect to MySQL server" error. I did check the bacula logs, the system log files and the mysqld log file. I think the problem was that I was using the "Selection Type = PoolUncopiedJobs", and the number of jobs to be copied had gotten larger than previously and caused some limit to be exceeded. I increased a number of resource limits in my.cnf, but it still doesn't work. I don't see any smoking gun in the bacula or system logs to tell me what the problem is. The only error message I see anywhere is "Cannot connect to database, either the server is not running or your authorization is incorrect". However, I know the authorization is correct and the server is running, so it's got to be some kind of resource exhaustion. I did try running a copy for a single client. That also works, also pointing to resource exhaustion. The problem with that is that it also copies jobs that have already been copied. What I'd really like is to be able to copy all jobs for a single client that have not already been copied, so I can do all of them a few jobs at a time, but there doesn't seem to be any way to do that. Maybe with some kind of SQL query? I could maybe develop one, but it would take a lot of time to learn enough about how the database is structured to be able to do that, so I want to have someone who knows say that this is possible before I invest all that time. Another approach is to accelerate my move of Bacula and MythTV to a new machine with more RAM, which I was going to do anyway. Then I can allocate more memory to the database. But of course I don't know for sure that that will fix the issue either. --Greg ------------------------------------------------------------------------------ Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
