1. ホーム
  2. mysql

[解決済み] mysql サーバーがクラッシュした -mysqld got signal 6

2022-02-11 09:29:25

質問

mysql 5.7.23を使用していますが、mysqlサーバーを起動することができません。

[ERROR] InnoDB: Space id and page no stored in the page, read in are [page id: space=3376699519, page number=1484718080], should be [page id: space=1463, page number=1] 2018-10-04T04:29:19.269829Z 0 [ERROR] InnoDB: Page [page id: space=3376699519, page number=1484718080] log sequence number 17294104044079415296 is in the future! Current system log sequence number 189601148. 2018-10-04T04:29:19.269834Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2018-10-04T04:29:19.269872Z 0 [ERROR] InnoDB: Database page corruption on disk or a failed file read of page [page id: space=1463, page number=1]. You may have to recover from a backup.

解決方法は?

innodb_force_recoveryを確認し、1に設定して、mysqlを起動してください。 詳しくは、以下をご覧ください。 これ