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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users