服务器断电重启后,Mysql实例始终无法启动,错误信息如下:
2022-09-25T08:43:21.246182Z 1691 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table `iios_cloud_monitor`.`monitor_oee_result_5m` index `PRIMARY`, father ptr page no 157251, child page no 157252,
2022-09-25T08:43:21.247251Z 1691 [ERROR] [MY-011854] [InnoDB] [FATAL] You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html for information about forcing recovery. Then dump + drop + reimport.,
2022-09-25T08:43:21.247275Z 1691 [ERROR] [MY-013183] [InnoDB] Assertion failure: ut0ut.cc:557 thread 140514224047872,
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.,
2022-09-25T08:43:32.515800Z 28 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table `iios_cloud_monitor`.`monitor_oee_result_5m` index `PRIMARY`, father ptr page no 157251, child page no 157252,
2022-09-25T08:43:32.517091Z 28 [ERROR] [MY-011854] [InnoDB] [FATAL] You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html for information about forcing recovery. Then dump + drop + reimport.,
2022-09-25T08:43:32.517117Z 28 [ERROR] [MY-013183] [InnoDB] Assertion failure: ut0ut.cc:557 thread 140600321070848,
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
按照以上提示,先到http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html修改my.cnf配置成功启动mysql后,备份此表、drop此表、reimport此表后解决。