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

科学上网 | 国外VPS推荐 | 机场推荐

错误信息:

winbert@winbert-debian:~$ 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.

评论 抢沙发

登录

找回密码

注册