[Bacula-users] BigInt hit max value in mysql... what now?
Hi folks, over the weekend, our mysql bacula db seems to have hit the maximum possible auto_increment counter for an unsigned int(10) as I'm getting duplicate key errors on insert's into the File table. Is there a way to increase the maximum value or do I need to rebuild the bacula db from the last working dump?`The file table is around 15G at the moment, we have 67657255 files with a total db size around 23G. will alter table File change FileId FileId unsigned int(20) do anything useful? Thanks in advance for your comments, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] BigInt hit max value in mysql... what now?
On Mon, Aug 30, 2010 at 08:45:50AM +0200, Uwe Schuerkamp wrote: Hi folks, over the weekend, our mysql bacula db seems to have hit the maximum possible auto_increment counter for an unsigned int(10) as I'm getting duplicate key errors on insert's into the File table. Is there a way to increase the maximum value or do I need to rebuild the bacula db from the last working dump?`The file table is around 15G at the moment, we have 67657255 files with a total db size around 23G. will alter table File change FileId FileId unsigned int(20) Hi folks, I was able to extend the value range by issuing ALTER TABLE File CHANGE COLUMN FileId FileId bigint unsigned; I should have mentioned I'm running bacula 3.x on that server, bacula 5.x seems to use a bigint type value by default. All the best, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] BigInt hit max value in mysql... what now?
Hi folks, looks like extending the value range did not fix the error entirely. When running an incr. backup, I receive the following error message: 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=Duplicate entry '0' for key 1 I've tried deleting those rows with 0 from File (1 Row), but apparently that did not fix the problem. Will I need to upgrade to bacula 5.0 in order to resolve the issue? Is 3.x limited to 32bit auto_inc counters or something? All the best, Uwe -- NIONEX ist ein Unternehmen der DirectGroup Germany www.directgroupgermany.de -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users