登峰造极境

  • WIN
    • CSharp
    • JAVA
    • OAM
    • DirectX
    • Emgucv
  • UNIX
    • FFmpeg
    • QT
    • Python
    • Opencv
    • Openwrt
    • Twisted
    • Design Patterns
    • Mysql
    • Mycat
    • MariaDB
    • Make
    • OAM
    • Supervisor
    • Nginx
    • KVM
    • Docker
    • OpenStack
  • WEB
    • ASP
    • Node.js
    • PHP
    • Directadmin
    • Openssl
    • Regex
  • APP
    • Android
  • AI
    • Algorithm
    • Deep Learning
    • Machine Learning
  • IOT
    • Device
    • MSP430
  • DIY
    • Algorithm
    • Design Patterns
    • MATH
    • X98 AIR 3G
    • Tucao
    • fun
  • LIFE
    • 美食
    • 关于我
  • LINKS
  • ME
Claves
长风破浪会有时,直挂云帆济沧海
  1. 首页
  2. Platforms
  3. LINUX
  4. Mysql
  5. 正文

Mysql Corruption of an index tree: table 错误

2022-09-25

服务器断电重启后,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此表后解决。

标签: 暂无
最后更新:2022-09-25

代号山岳

知之为知之 不知为不知

点赞
< 上一篇

COPYRIGHT © 2099 登峰造极境. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang

蜀ICP备14031139号-5

川公网安备51012202000587号