Weird Auto_increment Issue

Asked Mar 04 '15 at 00:51

Active Mar 04 '15 at 00:51

Viewed 54 times

For some reason my AUTO_INCREMENT for my Primary Key column is set to 260 rather than 261. There is already a row with 260 so obviously each query fails to insert.

I tried doing ALTER TABLE table_name AUTO_INCREMENT = 261 but that gave me another error:

Error: Failed to read auto-increment value from storage engine

I have tried to drop and re-assign the auto_increment but without success. Only when I reset it back to 260 does it give the duplicate Primary Key error again.

How can I reset this?

asked Mar 04 '15 at 00:51

Chris

57,622
19
111
137

I suppose you already tried http://stackoverflow.com/questions/17690926/failed-to-read-auto-increment-value-from-storage-engine-error-number-1467 – Iłya Bursov Mar 04 '15 at 00:52
1

What type is this column? Could you show the `CREATE TABLE` statement? – Darren Mar 04 '15 at 00:53
@Lashane setting it back to 1? – Chris Mar 04 '15 at 00:53
@Chris setting to 1, droppping and recreating, there are several such questions – Iłya Bursov Mar 04 '15 at 00:54
1

I suspect the easiest way would be to `CHECK TABLE`, then delete the row with 260, `CHECK TABLE` again, insert row again. – Eugen Rieck Mar 04 '15 at 00:56

Weird Auto_increment Issue

0 Answers0