Brian Hanna wrote:
> Frank Sweetser wrote:
>>
>> For the duplicate key portion, you'll want to modify the column type 
>> to contain more potential values.
>>
> I tried some more tests on a sample table, and it does appear with a 
> bigint I can get auto_increment to go beyond 4294967295.
>
> max_rows isn't my problem, I guess.
>
> Thanks,
>
> Brian
>
I backed up my database and did an "alter table modify FileId bigint(12) 
unsigned not null auto_increment", which took an hour or so.

I also saw a "FileId" field in BaseFiles, so I did a similar alter table 
there, just in case that would have to hold a FileId value. I didn't see 
any other FileId key fields in other tables.

I checked my FileName and Path auto increment values, but they were ok, 
nothing close to the 4.2 billion limit.

Afterwards I restarted bacula and ran a backup. The file attributes were 
added, and my auto_increment is now at 4295088050!

I guess this isn't a max_rows problem after all.

Thanks very much for your help,

Brian



-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users