Yups. You could switch to postgres ? Michael On Nov 16, 2007 1:49 AM, Jason Martin <[EMAIL PROTECTED]> wrote: > 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. > > ------------------------------------------------------------------------- > 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 > >
-- Michael Lewinger MBR Computers http://mbrcomp.co.il ------------------------------------------------------------------------- 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