Sorry, I meant this for devel@ Begin forwarded message:
> From: Dan Langille <[EMAIL PROTECTED]> > Date: November 7, 2008 8:02:13 AM EST > To: bacula-users <[EMAIL PROTECTED]> > Subject: [Bacula-users] 64bit for File.FileId > > I know I've seen something about moving to BIGSERIAL but don't know > where. Does someone have a patch. > > Please CC the original poster who would like to fix this before the > weekend backups. > > Begin forwarded message: > >> From: James Cort <[EMAIL PROTECTED]> >> Date: November 7, 2008 4:50:59 AM EST >> To: bacula-users <[EMAIL PROTECTED]> >> Subject: [Bacula-users] Ran out of fileid's in postgres-backed >> database >> >> 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 >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- > Dan Langille > http://langille.org/ > > > > > > ------------------------------------------------------------------------- > 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 > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Dan Langille http://langille.org/ ------------------------------------------------------------------------- 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-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
