mysql掉电后重启失败问题
报错
2022-12-07T01:41:02.844533Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 265368743141 and the end 265368742912.
2022-12-07T01:41:02.844551Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-12-07T01:41:03.445579Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-12-07T01:41:03.445613Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-12-07T01:41:03.445624Z 0 [ERROR] Failed to initialize builtin plugins.
2022-12-07T01:41:03.445640Z 0 [ERROR] Aborting
2022-12-07T01:41:03.445723Z 0 [Note] Binlog end
2022-12-07T01:41:03.445810Z 0 [Note] Shutting down plugin 'CSV'
2022-12-07T01:41:03.446170Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
解决方法
- Set
innodb_log_checksums = ONon master and slave. - Remove
rm /var/lib/mysql/ib_logfile*. - Restart.
remove innodb_log_checksums = ONfrom my.conf- Restart
posted on 2022-12-07 10:38 cococooder 阅读(177) 评论(0) 编辑 收藏 举报
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· 葡萄城 AI 搜索升级：DeepSeek 加持，客户体验更智能
· 什么是nginx的强缓存和协商缓存
· 一文读懂知识蒸馏