On Thursday 06 April 2006 21:45, Erik P. Olsen wrote: > Kern Sibbald wrote: > > On Thursday 06 April 2006 16:41, Erik P. Olsen wrote: > >> I experienced last night this error and it is not very pleasant to have > >> to run the nightly back-up manually in daytime. So I would like to > >> prevent it from happening. If I increase the wait timeout for the mysql > >> server to more than the longest interval between back-ups I think it > >> will accomplish just that, but where do I set this timeout value and > >> how? > > > > In addition to the other comments, if I am not mistaken, there is a > > Problems section in the MySQL chapter of the manual that points you off > > to the MySQL documentation on this. > > Thanks, I'll take a look at that. > > > This has nothing to do with you, Eric, but since we are on the subject of > > MySQL timeouts: one user troubled by this problem was aserting that > > Bacula remains connected at all times to the MySQL database. Nothing > > could be farther from the truth (or at least the intention), unless it is > > a new bug, which is unlikely because I am not experiencing this problem > > on my 4.1 MySQL database. > > I am now running FC5 with bacula 1.38.5 and and mysql 5.0 which came with > FC5. Previously I ran FC3 with bacula 1.38.5 and mysql 4.1 and have not > experienced this problem at all.
If you don't find a solution in reading the MySQL page about this problem, you might try backing up to MySQL 4.1 (even if you must build it from source). In any case, I think everyone would like to hear any solution you find ... -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users