Failed to read auto-increment value from storage engine error handling method

When inserting data, the system prompts "failed to read auto-increment value from storage engine" (failed to read auto-increment fields from storage engine). After reading the information, the solution is as follows:

1) Remove the auto-increment option for the auto-increment fields involved in the data table and save the settings.

2) set this field as an auto-increment field again.

Solve the problem.

 

Reference: http://liguoliang.com/2010/mysql1467-failed-to-read-auto-increment-value-from-storage-engine/