Hi, On 9/19/2006 7:44 PM, Jeff Tucker wrote: > Hi, > > I had a job fill a tape and it took me a day to get the tape changed. > During that time, the MySQL connection apparently timed out. It appears > that whatever I do from the console just gets me the "MySQL server has > gone away" error. > > I've read in the archives why this is happening and I know how to turn > up the wait_timeout to avoid this in the future. I'm mostly wondering > about this job I have running right now. > > I'm in the middle of a backup to tape. I'm ready to label the next tape > and allow the backup to continue. Is there a way to force the director > to try to reconnect to MySQL?
I'm not absolutely sure here, but doing a 'status dir' command should set up a new database connection. In fact, any operation requiring catalog access should, but a status command shouldn't have any side-effects. > If I restart just the director process, > will it be able to continue the tape backup job that is half done? No. > What's the safest way to proceed from here? I'd prefer not to lose this > backup if I don't have to. I really don't want to get my catalog > corrupted or something. I'm not sure that the job can be continued now, but re-initiating the database connection and then swapping tapes might work. You'll know soon :-) Arno > > Thanks for the help. BTW, this is Bacula 1.36.3 and MySQL 5.0.22. > > Jeff > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
