MySQL Error number: MY-013047; Symbol: ER_IB_MSG_1222; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-013047; Symbol: ER_IB_MSG_1222; SQLSTATE: HY000

Message: %s

MySQL Error number MY-013047, Symbol ER_IB_MSG_1222, and SQLSTATE HY000 indicates an Internal Error. The error is an internal to InnoDB, and the given SQLSTATE code is only used when InnoDB returns the error code to the server.

MySQL Error MY-013047, symbol ER_IB_MSG_1222, and SQLSTATE HY000 is usually caused by the server’s InnoDB file having corrupted. InnoDB is the default storage engine for MySQL, and when a server cannot properly read or write to the InnoDB files, this can cause MySQL to crash and error out with this message.

The best way to troubleshoot this problem is to check the MySQL server’s error log. This log will show the exact cause of the error and can help to pinpoint any corrupted InnoDB files that may be causing the problem. After determining the cause of the error, it is important to take immediate action.

If the InnoDB files have become corrupted, it is important to immediately restore them from a clean backup copy to restore MySQL server’s data integrity. If a strict backup policy is not in place, it may be necessary to repair the corrupted files with mysqldump. If all else fails, it may be necessary to reinstall the MySQL server from scratch.

It is also important to keep the MySQL server’s software up-to-date to prevent any further issues, such as corruption and other types of errors. This should be done on a regular basis, especially before making any major configuration changes or upgrades.

Overall, MySQL Error MY-013047, symbol ER_IB_MSG_1222, and SQLSTATE HY000 are usually caused by corrupted InnoDB files. The best way to troubleshoot this issue is to check the MySQL server’s error log. Once the cause is identified, it is important to immediately take action, such as restoring from a clean backup, repairing with mysqldump, or reinstalling the MySQL server. In addition, it is important to regularly keep the MySQL server software up-to-date in order to prevent any further issues.