[Bacula-users] BigInt hit max value in mysql... what now?

2010-08-30 Thread Uwe Schuerkamp
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

Re: [Bacula-users] BigInt hit max value in mysql... what now?

2010-08-30 Thread Uwe Schuerkamp
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

Re: [Bacula-users] BigInt hit max value in mysql... what now?

2010-08-30 Thread Uwe Schuerkamp
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,