Hello,
Bacula can handle 64 bit FileId fields, but unfortunately, I forget exactly
the version where all the work was done. However, I am sure that version
2.4.x does contain all the necessary modifications so that it will work.
We are sure it is working because Eric has been running with 64 bit
(bigserial) PostgreSQL FileIds for quite some time. Eric can fill you in on
the steps that are necessary to make it work. Currently, upgrading from 32
bit FileIds to 64 bit is a manual exercise, but with the next major release
(around the end of the year) we are planning to make it the default.
Best regards,
Kern
PS: I would be interested to hear about your setup since you seem to have
quite big backup needs.
On Friday 07 November 2008 15:23:01 Dan Langille wrote:
> Sorry, I meant this for devel@
>
> Begin forwarded message:
> > From: Dan Langille <dan AT langille DOT org>
> > Date: November 7, 2008 8:02:13 AM EST
> > To: bacula-users <bacula-users AT lists.sourceforge DOT net>
> > 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 <james.cort AT u4eatech DOT com>
> >> Date: November 7, 2008 4:50:59 AM EST
> >> To: bacula-users <bacula-users AT lists.sourceforge DOT net>
> >> 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
> >> Bacula-users AT lists.sourceforge DOT net
> >> 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
> > Bacula-users AT lists.sourceforge DOT net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
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
|
