Search code examples
mysqldatabaseauto-increment

mysql Failed to read auto-increment value from storage engine

I am having mysql table with one id field as auto-increment .

When I insert values to the table am getting error as

1467 - Failed to read auto-increment value from storage engine

Also the show table status shows me that the field with auto increment has

18446744073709551615 as Auto_increment value.

What would be the issue can any one help me ....?

Solution

  • Problem could absolutely be that: convert 18446744073709551615 to hex and you'll find
    $FFFF-FFFF-FFFF-FFFF.
    If your field is an unsigned 64bit you reach its limit.