大叔经验分享(104)mysql启动失败
mysql启动报错:
2020-04-07T11:32:03.523605Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 238665084 and the end 238664704. 2020-04-07T11:32:03.523756Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2020-04-07T11:32:04.129533Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2020-04-07T11:32:04.129618Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2020-04-07T11:32:04.129644Z 0 [ERROR] Failed to initialize builtin plugins. 2020-04-07T11:32:04.129652Z 0 [ERROR] Aborting
解决方法:
删除以下文件后重启
/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
参考:https://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/
---------------------------------------------------------------- 结束啦,我是大魔王先生的分割线 :) ----------------------------------------------------------------
- 由于大魔王先生能力有限,文中可能存在错误,欢迎指正、补充!
- 感谢您的阅读,如果文章对您有用,那么请为大魔王先生轻轻点个赞,ありがとう