Bacula-users
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[Bacula-users] Fatal error inserting into "batch" table.

2008-04-17 05:29:22
Subject: [Bacula-users] Fatal error inserting into "batch" table.
From: "Toby McLaughlin" <toby AT jarpy DOT net>
To: bacula-users AT lists.sourceforge DOT net
Date: Thu, 17 Apr 2008 19:13:07 +1000 
Hello,

I'm new to Bacula and struggling with a crash when backing up my
largest server. The crash is thankfully repeatable. I hope that you
can help and that I am not simply reporting my own failings.

I'm running the current Debian/testing binaries (2.2.8-8) on x86
against Debian's MySQL 5.0.51a-3

When running the first full backup of my largest host "pris", the
backup failed with this output:

17-Apr 16:26 gaff-dir JobId 1: Fatal error: sql_create.c:732
sql_create.c:732 insert INSERT INTO batch VALUES
(2094743,1,'/home/gary/devel/LMS7.0.0/src/lib/.svn/prop-base/','WebImportCycleRatings.pm.svn-base','P4A
EMXG IEk B Pt Pt A i BAA I BIBr+D BHITLl BHITLm A A
E','JebC91WLdIQADU0JDepbkg') failed:
Incorrect key file for table '/tmp/#sql136f_26_0.MYI'; try to repair it
17-Apr 16:26 gaff-dir JobId 1: Fatal error: catreq.c:482 Attribute
create error. sql_get.c:1005 Media record for Volume "full-0001" not
found.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.

Earlier backups of other hosts have succeeded.

After reading a few posts suggesting database corruption, I:

 * Dropped and created the Bacula database from MySQL
 * Deleted all disk media files
 * Ran "make_mysql_tables" from the 2.2.8 source distribution
 * Restarted DIR and SD
 * Manually started a full backup of "pris"

Unfortunately, the same error occurred.

If you can help at all, thank you very much.

Toby McLaughlin.

-Full backup log-
17-Apr 14:00 gaff-dir JobId 1: No prior Full backup Job record found.
17-Apr 14:00 gaff-dir JobId 1: No prior or suitable Full backup found
in catalog. Doing FULL backup.
17-Apr 14:00 gaff-dir JobId 1: Start Backup JobId 1,
Job=pris-fd.2008-04-17_14.00.03
17-Apr 14:00 gaff-dir JobId 1: Created new Volume "full-0001" in catalog.
17-Apr 14:00 gaff-dir JobId 1: Using Device "FileStorage"
17-Apr 14:00 gaff-sd JobId 1: Labeled new Volume "full-0001" on device
"FileStorage" (/srv/backup/bacula).
17-Apr 14:00 gaff-sd JobId 1: Wrote label to prelabeled Volume
"full-0001" on device "FileStorage" (/srv/backup/bacula)
pris-fd JobId 1:      Disallowed filesystem. Will not descend from / into /sys
pris-fd JobId 1:      Disallowed filesystem. Will not descend from / into /proc
pris-fd JobId 1:      Disallowed filesystem. Will not descend from / into /dev
pris-fd JobId 1:      Disallowed filesystem. Will not descend from /
into /lib/init/rw
17-Apr 16:26 gaff-dir JobId 1: Fatal error: sql_create.c:732
sql_create.c:732 insert INSERT INTO batch VALUES
(2094743,1,'/home/gary/devel/LMS7.0.0/src/lib/.svn/prop-base/','WebImportCycleRatings.pm.svn-base','P4A
EMXG IEk B Pt Pt A i BAA I BIBr+D BHITLl BHITLm A A
E','JebC91WLdIQADU0JDepbkg') failed:
Incorrect key file for table '/tmp/#sql136f_26_0.MYI'; try to repair it
17-Apr 16:26 gaff-dir JobId 1: Fatal error: catreq.c:482 Attribute
create error. sql_get.c:1005 Media record for Volume "full-0001" not
found.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job write elapsed time = 02:25:46,
Transfer rate = 7.000 M bytes/second
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 gaff-sd JobId 1: Job pris-fd.2008-04-17_14.00.03 marked
to be canceled.
17-Apr 16:26 pris-fd JobId 1: Fatal error: backup.c:892 Network send
error to SD. ERR=Connection reset by peer
17-Apr 16:26 pris-fd JobId 1: Error: bsock.c:306 Write error sending
42 bytes to Storage daemon:gaff.n6.corp:9103: ERR=Connection reset by
peer
17-Apr 16:26 gaff-dir JobId 1: Error: Bacula gaff-dir 2.2.8 (26Jan08):
17-Apr-2008 16:26:28
 Build OS:               i486-pc-linux-gnu debian lenny/sid
 JobId:                  1
 Job:                    pris-fd.2008-04-17_14.00.03
 Backup Level:           Full (upgraded from Incremental)
 Client:                 "pris-fd" 2.2.8 (26Jan08)
x86_64-unknown-linux-gnu,redhat,3.0
 FileSet:                "pris-files" 2008-04-17 14:00:28
 Pool:                   "FullPool" (From Job FullPool override)
 Storage:                "File" (From command line)
 Scheduled time:         17-Apr-2008 14:00:26
 Start time:             17-Apr-2008 14:00:30
 End time:               17-Apr-2008 16:26:28
 Elapsed time:           2 hours 25 mins 58 secs
 Priority:               10
 FD Files Written:       2,094,870
 SD Files Written:       2,094,758
 FD Bytes Written:       60,877,670,948 (60.87 GB)
 SD Bytes Written:       61,223,493,493 (61.22 GB)
 Rate:                   6951.1 KB/s
 Software Compression:   29.3 %
 VSS:                    no
 Storage Encryption:     no
 Volume name(s):         full-0001
 Volume Session Id:      1
 Volume Session Time:    1208404810
 Last Volume Bytes:      61,336,220,635 (61.33 GB)
- Hide quoted text -
 Non-fatal FD errors:    1
 SD Errors:              0
 FD termination status:  Error
 SD termination status:  Canceled
 Termination:            *** Backup Error ***

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [Bacula-users] autoprune and recylce on hard disk volume, hozone
Next by Date:  [Bacula-users] Bacula Releases + Status, Kern Sibbald
Previous by Thread:  Re: [Bacula-users] autoprune and recylce on hard disk volume, hozone
Next by Thread:  Re: [Bacula-users] Fatal error inserting into "batch" table., Frank Sweetser
Indexes:  [Date] [Thread] [Top] [All Lists]