Re: [Bacula-users] Integer out of range error on file table

2007-07-18 Thread Alan Brown
On Wed, 18 Jul 2007, Gavin Carr wrote: > Arno Lehmann wrote: >>> Investigating, it looks like the issue is hitting the integer limit on >>> the fileid: >>> >>> bacula=> select max(fileid) from file; >>> max >>> >>> 2147483647 For the record: This site is up to 1/3 of that. I'd

Re: [Bacula-users] Integer out of range error on file table

2007-07-17 Thread Arno Lehmann
Hi, 18.07.2007 01:14,, Gavin Carr wrote:: > Hi Arno, > > Arno Lehmann wrote: >>> Investigating, it looks like the issue is hitting the integer limit on >>> the fileid: >>> >>> bacula=> select max(fileid) from file; >>> max >>> >>> 2147483647 >>> (1 row) >> Looks like that. >>

Re: [Bacula-users] Integer out of range error on file table

2007-07-17 Thread Gavin Carr
Hi Arno, Arno Lehmann wrote: >> Investigating, it looks like the issue is hitting the integer limit on >> the fileid: >> >> bacula=> select max(fileid) from file; >> max >> >> 2147483647 >> (1 row) > > Looks like that. > >> Have other people encountered this? We've been happ

Re: [Bacula-users] Integer out of range error on file table

2007-07-17 Thread Alan Brown
On Mon, 16 Jul 2007, Gavin Carr wrote: > Hi all, > > I've just started getting 'integer out of range' errors on my file table: Are you using MyISAM or InnoDB? - This SF.net email is sponsored by DB2 Express Download DB2 Exp

Re: [Bacula-users] Integer out of range error on file table

2007-07-16 Thread Arno Lehmann
Hi, 16.07.2007 09:43,, Gavin Carr wrote:: > 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,FilenameI

[Bacula-users] Integer out of range error on file table

2007-07-16 Thread Gavin Carr
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