欢迎光临
感受代码之美

MySQL启动报错:Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

错误信息:

[email protected]:~$ sudo journalctl -xe
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] InnoDB: Using Linux native AIO
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] InnoDB: Completed initialization of buffer pool
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42197,42197
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42197 between the checkpoint 42197 and the end 42209.
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] InnoDB: Starting shutdown...
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] Plugin 'InnoDB' init function returned error.
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [Note] Plugin 'FEEDBACK' is disabled.
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Nov 05 13:49:51 winbert-debian mariadbd[1641]: 2021-11-05 13:49:51 0 [ERROR] Aborting
Nov 05 13:49:51 winbert-debian systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

解决办法:

删除/var/lib/mysql/ib_logfile*文件。

参考:

  1. MySQL Server shuts down frequently and won’t start again now
=============公众号推荐,欢迎关注============= 公众号分享
赞(0)
未经允许禁止转载:四个空格 » MySQL启动报错:Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址