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 = ON
on master and slave. - Remove
rm /var/lib/mysql/ib_logfile*
. - Restart.
remove innodb_log_checksums = ON
from my.conf- Restart
最新文章
- Log4J日志管理类使用详解 (转)
- Hanoi问题
- 【BZOJ】2795: [Poi2012]A Horrible Poem
- php安装memcache注意事项
- Oracle GoldenGate 12c实时捕获SQL Server数据
- SQL JOB
- angularjs + springmvc 上传和下载
- paip.Adblock屏蔽规则保存位置以及修理恢复
- Thymeleaf 笔记
- WebApi实现通讯加密
- 笔记3 linux 多线程 条件变量+互斥锁
- bzoj:1703: [Usaco2007 Mar]Ranking the Cows 奶牛排名
- bzoj 3576[Hnoi2014]江南乐 sg函数+分块预处理
- 马昕璐 201771010118《面向对象程序设计(java)》第十六周学习总结
- 五、xadmin自定义插件2
- 【转帖】Linux的历史----Linux内核剖析(一)
- SharePoint 2013 APP 开发示例 系列
- Dynamics CRM2016 导入数据格式之xlsx的应用
- 记一次Android studio升级之后的坑
- 关于Unity 获得和使用GetComponent<;MeshFilter>;().mesh时的心得