Failed To Read Auto-Increment Value From Storage Engine Error in MySQL.

This is a very strange MySQL error. The error happens when trying to insert a new row in to a table. Basically this is a bug in MySQL that causes the problem but a work around is simple. The problem happens when the Auto-Increment value of a table grows beyond the limit.

Just run this SQL query in MySQL to fix the bug.

ALTER TABLE `table_name`  AUTO_INCREMENT =1

Table_name is the name of the table where you found the error while inserting data into. Don’t bother about the Auto_Increment value even if you have records in your table.

ASK a Question!