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)
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?
More immediately: is altering fileid to a bigint to workaround this a
sane thing to do? Do I have any other options?
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
