> one o clock in the evening. backup is starting. Actually this is 1:00AM, but I understand your confusion.
> > 2007-11-11 01:00:01 secnet-def JobId 4836: Created new Volume > > "sv253429" in catalog. > > 2007-11-11 01:00:01 secnet-def JobId 4836: Using Device "sv25d1" > > 2007-11-11 00:36:48 sv25: DIR and FD clocks differ by -1397 > > seconds, FD automatically adjusting. I have had problems with the adjusting clocks before, perhaps this is another bug? > > 2007-11-11 01:00:09 secnet-def JobId 4836: Volume used once. > > Marking Volume "sv253429" as Used. > > the volume is not appendable any more. According the output from the backup, it wrote 3.5GB to the new volume afterwards so I doubt that this is the problem. > > 2007-11-11 16:51:38 secnet-def JobId 4836: Fatal error: > > sql_create.c:732 sql_create.c:732 insert INSERT INTO batch VALUES > > (3818,4836,'c:/Program Files/Exchsrvr/MDBDATA/','priv1.edb','A A IH/ B A > > A A Da4iAA A A BHMFM+ BHMFM+ BGYZ2N A A M','dmdiS+Gv+tlT5V20b2njuw') > > failed: > > Table 'bacula.batch' doesn't exist > > uh, 16:51 and half a day passed without an appendable volume. your > database dropped the connection and the temporary batch table is not > available any more (well, it was a temporary one ;-). note that i am > assuming that you are using mysql. You assume correctly. > setting wait_timeout to a higher level is the workaround i know for the > connection drop problem. see also > > http://wiki.bacula.org/doku.php?id=faq I will try this workaround but I doubt this is a mysql problem, my backups have been working perfectly until my recent upgrade from 2.0.3->2.2.5. Surely bacula doesn't keep a mysql thread open for the entire duration of the backup, that seems very inefficient. > but why was an appendable volume not available ? probably this is your > real problem and not the the mysql timeout thing. I am very perplexed with this issue and my client is becoming more impatient with each passing day (and failed job). I noticed a message in the mailing list from someone in 2.2.4 with the same problem. However, there didn't seem to be an answer to his question. Please help Sincerely, -Michael ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
