Sorry my mistake: You are using a MyISAM table and the space required for the table exceeds what is allowed by the internal pointer size. MyISAM creates tables to allow up to 4GB by default (256TB as of MySQL 5.0.6), but this limit can be changed up to the maximum allowable size of 65,536TB (2567 – 1 bytes).
If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE statement supports AVG_ROW_LENGTH and MAX_ROWS options. See Section 12.1.5, "CREATE TABLE Syntax". The server uses these options to determine how large a table to allow. Michael On Nov 16, 2007 8:38 AM, Michael Lewinger <[EMAIL PROTECTED]> wrote: > 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 > -- 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
