On Mon, 12 Nov 2007 16:24:34 -0600, Michael Short wrote: On Mon, 12 Nov 2007 16:24:34 -0600, Michael Short wrote:
> I'm getting something really strange when backing up a few of my > clients, can anyone explain why the batch insert is causing my jobs to > fail? well, actually i encountered a similiar problem last week. > 2007-11-11 01:00:00 secnet-def JobId 4836: Start Backup JobId > 4836, Job=sv25.2007-11-11_01.00.07 one o clock in the evening. backup is starting. > 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. > 2007-11-11 01:00:09 secnet-def JobId 4836: Labeled new Volume > "sv253429" on device "sv25d1" (/home/bacula/storage/d1). > 2007-11-11 01:00:09 secnet-def JobId 4836: Wrote label to > prelabeled Volume "sv253429" on device "sv25d1" > (/home/bacula/storage/d1) > 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. > 2007-11-11 00:36:54 sv25: Generate VSS snapshots. Driver="VSS Win > 2003", Drive(s)="C" > 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. 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 but why was an appendable volume not available ? probably this is your real problem and not the the mysql timeout thing. best regards, markus ------------------------------------------------------------------------- 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
