51工具盒子

依楼听风雨
笑看云卷云舒,淡观潮起潮落

MySQL 容器报错 Ignoring the redo log due to missing MLOG_CHECKPOINT between xxxx and xxx

MySQL 容器报错 Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint xxxxxxxxx and the end xxxxxxxxx.\n

问题描述,当有一些用户的机器突然断电关机或者不正常关机之后,DataEase 服务中的 MySQL 容器无法启动,报如下错误时,可以参考此方法



详细报错信息如下

 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 1333062514 and the end 1333062168.\n","stream":"stderr","time":"2023-07-24T02:41:15.58560711Z"}
 [ERROR] InnoDB: Plugin initialization aborted with error Generic error\n","stream":"stderr","time":"2023-07-24T02:41:15.585609332Z"}
 [ERROR] Plugin 'InnoDB' init function returned error.\n","stream":"stderr","time":"2023-07-24T02:41:16.204164083Z"}
 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.\n","stream":"stderr","time":"2023-07-24T02:41:16.20418651Z"}
 [ERROR] Failed to initialize builtin plugins.\n","stream":"stderr","time":"2023-07-24T02:41:16.204188764Z"}
 [ERROR] Aborting\n","stream":"stderr","time":"2023-07-24T02:41:16.204190498Z"}

报错原因,一般是服务器断电或者 MySQL 服务不正常结束导致的,和 MySQL redo log 有关。


解决方法,进入 /opt/dataease/data/mysql 目录,将图示两个文件修改,然后执行 dectl reload 命令。

#修改两个文件,这里不建议删除,建议重命名
mv ib_logfile0 ib_logfile0.bak
mv ib_logfile1 ib_logfile1.bak
`dectl reload`

赞(0)
未经允许不得转载:工具盒子 » MySQL 容器报错 Ignoring the redo log due to missing MLOG_CHECKPOINT between xxxx and xxx