Hello, I was hoping someone could help me identify what is going wrong with my backup job?
I recently updated from 2.0.3 to 2.2.5 so that building of directory trees for restores were faster (and I am quite pleased). After I updated, everything seemed fine, I was able to run several incremental backups of the same identical job except on a different / identical tapeset that is now offsite. I am trying to create a new backup on the secondary set of tapes and I keep running into this error after a day and a half. Table 'batch' is full. I'm using a large my.cnf config Another error is: Attribute create error. sql_find.c:333 Request for Volume item 1 greater than max 0 or less than 1 I may have read somewhere that this is caused by a disk space issue so I suspect I'm running out of space. The fileset is roughly 27,000,000 (million) files consuming 2.5 TB of space. I have 16GB free on the root partition where mysql lives, however the bacula sql tables and working directory are symbolically linked to a RAID with 80GB of free space. I had hoped this would be enough. Is it not? Thanks for any hints on identifying the problem. Nick ---------- Forwarded message ---------- From: Bacula <[EMAIL PROTECTED]> Date: Nov 15, 2007 5:05 PM Subject: Bacula: Backup Fatal Error of lcn-fd Full To: [EMAIL PROTECTED] 14-Nov 09:29 lcn-dir JobId 375: No prior Full backup Job record found. 14-Nov 09:29 lcn-dir JobId 375: No prior or suitable Full backup found in catalog. Doing FULL backup. 14-Nov 09:29 lcn-dir JobId 375: Start Backup JobId 375, Job=Job1.2007-11-14_09.29.05 14-Nov 09:29 lcn-dir JobId 375: Recycled current volume "tape1" 14-Nov 09:29 lcn-dir JobId 375: Using Device "Ultrium" 14-Nov 09:29 lcn-sd JobId 375: 3301 Issuing autochanger "loaded? drive 0" command. 14-Nov 09:29 lcn-sd JobId 375: 3302 Autochanger "loaded? drive 0", result is Slot 1. 14-Nov 09:29 lcn-sd JobId 375: Recycled volume "tape1" on device "Ultrium" (/dev/tape), all previous data lost. 14-Nov 23:46 lcn-sd JobId 375: End of Volume "tape1" at 742:11802 on device "Ultrium" (/dev/tape). Write of 64512 bytes got -1. 14-Nov 23:46 lcn-sd JobId 375: Re-read of last block succeeded. 14-Nov 23:46 lcn-sd JobId 375: End of medium on Volume "tape1" Bytes=742,713,882,624 Blocks=11,512,801 at 14-Nov-2007 23:46. 14-Nov 23:46 lcn-dir JobId 375: Recycled volume "tape4" 14-Nov 23:46 lcn-sd JobId 375: 3307 Issuing autochanger "unload slot 1, drive 0" command. 14-Nov 23:47 lcn-sd JobId 375: 3304 Issuing autochanger "load slot 4, drive 0" command. 14-Nov 23:47 lcn-sd JobId 375: 3305 Autochanger "load slot 4, drive 0", status is OK. 14-Nov 23:47 lcn-sd JobId 375: 3301 Issuing autochanger "loaded? drive 0" command. 14-Nov 23:47 lcn-sd JobId 375: 3302 Autochanger "loaded? drive 0", result is Slot 4. 14-Nov 23:47 lcn-sd JobId 375: Recycled volume "tape4" on device "Ultrium" (/dev/tape), all previous data lost. 14-Nov 23:47 lcn-sd JobId 375: New volume "tape4" mounted on device "Ultrium" (/dev/tape) at 14-Nov-2007 23:47. 15-Nov 15:53 lcn-sd JobId 375: End of Volume "tape4" at 808:12641 on device "Ultrium" (/dev/tape). Write of 64512 bytes got -1. 15-Nov 15:53 lcn-sd JobId 375: Re-read of last block succeeded. 15-Nov 15:53 lcn-sd JobId 375: End of medium on Volume "tape4" Bytes=808,763,784,192 Blocks=12,536,640 at 15-Nov-2007 15:53. 15-Nov 15:53 lcn-dir JobId 375: Recycled volume "tape3" 15-Nov 15:53 lcn-sd JobId 375: 3307 Issuing autochanger "unload slot 4, drive 0" command. 15-Nov 15:54 lcn-sd JobId 375: 3304 Issuing autochanger "load slot 3, drive 0" command. 15-Nov 15:54 lcn-sd JobId 375: 3305 Autochanger "load slot 3, drive 0", status is OK. 15-Nov 15:54 lcn-sd JobId 375: 3301 Issuing autochanger "loaded? drive 0" command. 15-Nov 15:54 lcn-sd JobId 375: 3302 Autochanger "loaded? drive 0", result is Slot 3. 15-Nov 15:54 lcn-sd JobId 375: Recycled volume "tape3" on device "Ultrium" (/dev/tape), all previous data lost. 15-Nov 15:54 lcn-sd JobId 375: New volume "tape3" mounted on device "Ultrium" (/dev/tape) at 15-Nov-2007 15:54. 15-Nov 17:04 lcn-dir JobId 375: Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO batch VALUES (20976597,375,'/mnt/right/ppg/dropbox/for_jessica.dir/lesion_vol.dir/2117/','2117_lesionnot_fruit_004.flt.gz','gg Bgn/f IGw B Ru U A FO BAA I BHOj5q BE7Ot4 BG2Gxr A A C','xWoEMzfHWuvIxoZu2vxP0A') failed: The table 'batch' is full 15-Nov 17:04 lcn-dir JobId 375: sql_create.c:732 INSERT INTO batch VALUES (20976597,375,'/mnt/right/ppg/dropbox/for_jessica.dir/lesion_vol.dir/2117/','2117_lesionnot_fruit_004.flt.gz','gg Bgn/f IGw B Ru U A FO BAA I BHOj5q BE7Ot4 BG2Gxr A A C','xWoEMzfHWuvIxoZu2vxP0A') 15-Nov 17:04 lcn-dir JobId 375: Fatal error: catreq.c:478 Attribute create error. sql_find.c:333 Request for Volume item 1 greater than max 0 or less than 1 15-Nov 17:04 lcn-sd JobId 375: Job Job1.2007-11-14_09.29.05 marked to be canceled. 15-Nov 17:04 lcn-sd JobId 375: Job write elapsed time = 31:31:59, Transfer rate = 14.30 M bytes/second 15-Nov 17:04 lcn-sd JobId 375: Job Job1.2007-11-14_09.29.05 marked to be canceled. 15-Nov 17:04 lcn-sd JobId 375: Job Job1.2007-11-14_09.29.05 marked to be canceled. 15-Nov 17:05 lcn-sd JobId 375: Job Job1.2007-11-14_09.29.05 marked to be canceled. 15-Nov 17:05 lcn-sd JobId 375: Job Job1.2007-11-14_09.29.05 marked to be canceled. 15-Nov 17:05 lcn-fd JobId 375: Fatal error: backup.c:892 Network send error to SD. ERR=Connection reset by peer 15-Nov 17:05 lcn-dir JobId 375: Error: Bacula lcn-dir 2.2.5 (09Oct07): 15-Nov-2007 17:05:48 Build OS: powerpc64-unknown-linux-gnu unknown unknown JobId: 375 Job: Job1.2007-11-14_09.29.05 Backup Level: Full (upgraded from Incremental) Client: "lcn-fd" 2.2.5 (09Oct07) powerpc64-unknown-linux-gnu,unknown,unknown FileSet: "Full Set" 2007-06-21 23:05:00 Pool: "Default" (From Job resource) Storage: "Autochanger" (From Job resource) Scheduled time: 14-Nov-2007 09:29:31 Start time: 14-Nov-2007 09:29:34 End time: 15-Nov-2007 17:05:48 Elapsed time: 1 day 7 hours 36 mins 14 secs Priority: 10 FD Files Written: 20,977,144 SD Files Written: 20,976,813 FD Bytes Written: 1,620,257,253,981 (1.620 TB) SD Bytes Written: 1,624,302,289,647 (1.624 TB) Rate: 14241.0 KB/s Software Compression: None VSS: no Encryption: no Volume name(s): tape1|tape4|tape3 Volume Session Id: 1 Volume Session Time: 1195051576 Last Volume Bytes: 74,740,313,088 (74.74 GB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: Error SD termination status: Canceled Termination: *** Backup Error *** ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
