问题描述
最近本地开发用的mysql docker容器挂了,原因是windows系统死机了(mmp),我强制关机了下,导致mysql实例拉不起来了,异常的原因大概是下面这样的:
2017-11-15T11:44:46.562061+08:00 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 63593957 and the end 63593472.
2017-11-15T11:44:46.562090+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-11-15T11:44:47.062885+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-11-15T11:44:47.062936+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-11-15T11:44:47.062945+08:00 0 [ERROR] Failed to initialize plugins.
2017-11-15T11:44:47.062951+08:00 0 [ERROR] Aborting
2017-11-15T11:44:47.062962+08:00 0 [Note] Binlog end
使用docker start -i xxx
拉起来都是上面的错误。
这个问题如果不是用docker还是很容易处理的,一般的解决方式有两个:
- 设置innodb_force_recovery=6