InnoDB: Missing MLOG_CHECKPOINT at XXXXX between the checkpoint XXXXX and the end XXXXX.

标题中的 XXXXX 代表数字

问题发生时间

2022/10/13

问题描述

Xampp mysql 又启动不了了，原因未知，报错如下：

[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
[Note] InnoDB: Completed initialization of buffer pool
[ERROR] InnoDB: Missing MLOG_CHECKPOINT at 5963236 between the checkpoint 5963236 and the end 5962752.
[ERROR] InnoDB: Plugin initialization aborted with error Generic error
[Note] InnoDB: Starting shutdown...
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[Note] Plugin 'FEEDBACK' is disabled.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

环境

OS: Win11
XAMPP: 3.2.4

解决方案

1. 删除 /mysql/data/ib_logfile（代表数字）
2. 重启 mysql
3. 问题解决

注意：
ib_logfile*是 redo log，所以删除虽然可以解决问题，但可能带来风险。不过目前我没有更好的解决方案。
该数据库是我个人使用且业务量不大，从目前的结果看没有丢失数据。

参考

1. XAMPP Error: InnoDB/MySQL shutdown unexpectedly won’t start again ↩︎
2. InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT ↩︎
3. MySQL or MariaDB is faulted due a startup error ↩︎