MySQL Forums
Forum List  »  InnoDB

Auto increment value get set to ' 18446744073709551615 ' with multiple load data infile
Posted by: Nithin Surendran
Date: August 13, 2013 12:41AM

Hi,

I am facing one problem with one of my project.I have a inventory upload which import data from csv to a innodb table. What happened here is with a multiple load data command (i suppose) the auto increment value get sets to 18446744073709551615 and not letting other insert to work. It was working fine before. I am not sure if the large amount of data in the table creates this issue or not.

Details of the table is as follows

Software version: 5.5.31-0ubuntu0.12.04.1-log - (Ubuntu)

largest insert id used : 17455787099

number of rows in the table : 23887371


some variables realted to this are as follows

auto increment increment 1
auto increment offset 1
autocommit ON
automatic sp privileges ON
innodb autoextend increment 8
innodb autoinc lock mode 1
sql auto is null OFF Documentation

i have removed the delete queries from the table. But still the autoincriment is out of sync

any help is much appreciated

thanks

Nithin

Options: ReplyQuote


Subject
Views
Written By
Posted
Auto increment value get set to ' 18446744073709551615 ' with multiple load data infile
2309
August 13, 2013 12:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.