Re: [Bacula-users] [Bacula-devel] Fwd: 64bit for File.FileId

[Kern S. <ke...@si...>]

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 <da...@la...>
> > Date: November 7, 2008 8:02:13 AM EST
> > To: bacula-users <bac...@li...>
> > 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 <jam...@u4...>
> >> Date: November 7, 2008 4:50:59 AM EST
> >> To: bacula-users <bac...@li...>
> >> 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
> >> Bac...@li...
> >> 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
> > Bac...@li...
> > https://lists.sourceforge.net/lists/listinfo/bacula-users