I have a MySQL Innodb table with 'id' as auto increment primary key column.
My Scripts are doing following operations:
- insert ignore into tablename set x='a', y='b'
- update ignore tablename set x='a', y='b' where id = 'smthing'
- delete from tablename where id = 'smthing'
Now after running the script when I insert something manually (insert into tablename set x='ax', y='bx') I get the following error:
Duplicate Entry for Auto Increment Value.
On check I see that Auto Increment is trying to put the highest possible value of int that MySql will support as new value even and it already exist in db.
The table has two index: id+x, id+y though idk if this is related to this issue.