I appear to have run out of fileids in my bacula database.
I'm using bacula 2.2.8-8~bpo40+1 (the Debian Etch backported package)
and my backups have failed with the error:
Fatal error: Can't fill File table Query failed: INSERT INTO File
(FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
batch.FileIndex, batch.JobId, Path.PathId,
Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
(batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
ERR=ERROR: integer out of range
I'm using Postgres as the backend and I note from the script which
bacula uses to setup the table "file" that fileid is of type serial.
bacula=> select max(fileid) from file;
max
------------
2147272756
(1 row)
2^31=2147483648
Postgresql's documentation states:
"The type names serial and serial4 are equivalent: both create integer
columns. The type names bigserial and serial8 work just the same way,
except that they create a bigint column. bigserial should be used if you
anticipate the use of more than 2^31 identifiers over the lifetime of
the table."
... but I'm not too keen on doing this unless I can be sure it won't
have a knock-on effect on Bacula.
What can I do to fix this?
James
--
U4EA Technologies
http://www.u4eatech.com
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|