项目报错 java.sql.SQLException: Failed to read auto-increment value from storage engine

偶然打开几个月没动的项目,准备加点新东西进去,项目运行增加一点数据进去就报错了

日志如下

项目报错  java.sql.SQLException: Failed to read auto-increment value from storage engine

未能从存储引擎读取自动递增的值

mysql数据库表的主键的确实自增的

解决方案

项目报错  java.sql.SQLException: Failed to read auto-increment value from storage engine

1)将自增主键的自增选项去掉 保存

2)再把自增选项加上去 就ok了

项目报错 java.sql.SQLException: Failed to read auto-increment value from storage engine

上一篇:yii框架:CDbConnection failed to open the DB connection: could not find driver的解决办法


下一篇:【MySQL】03-事务隔离