MySQL has its own size limits on files. See: http://wiki.bacula.org/doku.php?id=faq#why_does_mysql_say_my_file_table_is_full
-Jason Martin On Thu, Nov 15, 2007 at 05:44:44PM -0600, Nick Jones wrote: > 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 -- .ASM programmers drive stick shifts. This message is PGP/MIME signed.
pgpJm6BYejAOU.pgp
Description: PGP signature
------------------------------------------------------------------------- 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
