【问题描述】

生产环境mysql数据库，架构是一主一从，可以双机切换，mysql版本是5.7.24-enterprise-commercial-advanced-log。当时是存储mysql的机房突然断电。主从机器重启后，mysql都无法启动。两台机器都是同样错误，错误日志显示： 2020-10-27T00:58:41.032944Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 20171067203814 2020-10-27T00:58:41.136783Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171072446464 2020-10-27T00:58:41.222121Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171077689344 2020-10-27T00:58:41.312905Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171082932224 2020-10-27T00:58:41.401125Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171088175104 2020-10-27T00:58:41.493480Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171093417984 2020-10-27T00:58:41.579078Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171098660864 2020-10-27T00:58:41.608482Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20171100172800 2020-10-27T00:58:41.608573Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 20171067203814 and the end 20171100172800. 2020-10-27T00:58:41.608587Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2020-10-27T00:58:41.808775Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2020-10-27T00:58:41.808802Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2020-10-27T00:58:41.808817Z 0 [ERROR] Failed to initialize builtin plugins. 2020-10-27T00:58:41.808823Z 0 [ERROR] Aborting