Hi, 16.07.2007 09:43,, Gavin Carr wrote:: > Hi all, > > I've just started getting 'integer out of range' errors on my file table: > > 16-Jul 17:08 dubnium-dir: Dubnium.2007-07-16_17.04.20 Fatal error: > sql_create.c:753 Create db File record INSERT INTO File > (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES > (32220,1418,254,4539,'P0A 8Mc IGk B A A A Drl BAA o BGkkGv BGORys BGX6t+ > A A C','/AsBTJAhWCDrhK83B1Knww') failed. ERR=ERROR: integer out of range > 16-Jul 17:08 dubnium-dir: Dubnium.2007-07-16_17.04.20 Fatal error: > catreq.c:476 Attribute create error. sql_create.c:753 Create db File > record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) > VALUES (32220,1418,254,4539,'P0A 8Mc IGk B A A A Drl BAA o BGkkGv BGORys > BGX6t+ A A C','/AsBTJAhWCDrhK83B1Knww') failed. ERR=ERROR: integer out > of range > 16-Jul 17:08 dubnium-dir: Dubnium.2007-07-16_17.04.20 Fatal error: > sql_create.c:751 sql_create.c:751 insert INSERT INTO File > (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES > (32221,1418,254,4540,'P0A 8wI IGk B A A A aD BAA Q BGkkGv BGORys BGX6uA > A A C','/JZtnNX43g6wIDRLMMMVbQ') failed: > ERROR: integer out of range > > Investigating, it looks like the issue is hitting the integer limit on > the fileid: > > bacula=> select max(fileid) from file; > max > ------------ > 2147483647 > (1 row)
Looks like that. > Have other people encountered this? We've been happy little bacula users > for about a year now, and we are backing up a bit of data each night > (~300GB), but I can't believe we're that big a site in the scheme of things? Which catalog database do you run? > More immediately: is altering fileid to a bigint to workaround this a > sane thing to do? Do I have any other options? I don't know, I don't have any system with such a high number of File-table entries at hand :-) But, as far as I know, Bacula itself can handle 64-bit integers, so the change should be ok. Just make sure you have a valid catalog dump before you try it :-) The other option - pruning file entries earlier - would probably need a reorganization of the catalog which might be a really difficult task... Arno > > Thanks, > Gavin > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
