禅道服务器异常断电后，访问页面空白。数据库表可能因为断电原因损坏，需要检查修复！！
禅道服务器异常断电后，访问页面空白。数据库表可能因为断电原因损坏，需要检查修复！！“mysql关闭表只读”，“mysql取消表只读”
·
禅道18.2，安装位置：/opt/zbox
当初安装的文档
禅道官网问答：
一、禅道服务器异常断电后，访问页面空白
1.1、禅道linux一键安装包的停止、启动
/opt/zbox/zbox stop
/opt/zbox/zbox start1.2、查看日志
tail -f mysql_error.log数据库没有正常启动
数据库报错，数据损坏（corrupted）
2024-09-19 1:57:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2024-09-19 1:57:16 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-19 1:57:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-19 1:57:16 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2024-09-19 1:57:16 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-19 1:57:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4368908,4368908
2024-09-19 1:57:21 0 [Note] InnoDB: Starting final batch to recover 743 pages from redo log.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18712868 is not equal to page LSN 19073487
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18422162 is not equal to page LSN 19064603
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18422162 is not equal to page LSN 19064603
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 13038071 is not equal to page LSN 19666698
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 5861483 is not equal to page LSN 19666713
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19656544 is not equal to page LSN 19666679
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 16749201 is not equal to page LSN 19666760
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=8]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=8]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 8 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 9156789 is not equal to page LSN 19666742
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=7]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=7]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 7 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 16731797 is not equal to page LSN 19666727
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=6, page number=6]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=6, page number=6]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 6 from file './zentao/zt_action.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 13278125 is not equal to page LSN 14208813
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 13278125 is not equal to page LSN 14208813
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655758 is not equal to page LSN 19665873
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655773 is not equal to page LSN 19665888
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655788 is not equal to page LSN 19665903
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655803 is not equal to page LSN 19665934
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=6]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=6]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 6 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655818 is not equal to page LSN 19665949
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=7]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=7]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 7 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655833 is not equal to page LSN 19665964
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=8]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=8]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 8 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655848 is not equal to page LSN 19665979
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=9]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=9]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 9 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655863 is not equal to page LSN 19665994
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=10]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=10]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 10 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655878 is not equal to page LSN 19666009
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=11]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=11]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 11 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19655894 is not equal to page LSN 19666025
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=21, page number=12]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=21, page number=12]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 12 from file './zentao/zt_bug.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 12118952 is not equal to page LSN 12946459
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 12118952 is not equal to page LSN 12946459
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18846920 is not equal to page LSN 19713842
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=31, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=31, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_config.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18846832 is not equal to page LSN 19713818
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=31, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=31, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_config.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19756469 is not equal to page LSN 19756475
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19756267 is not equal to page LSN 19756460
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=32, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=32, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_cron.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 16308078 is not equal to page LSN 17080534
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 12371161 is not equal to page LSN 15232957
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19643228 is not equal to page LSN 19664175
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=46, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=46, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_file.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19659636 is not equal to page LSN 19672675
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19659627 is not equal to page LSN 19672666
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=46, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=46, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_file.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18577598 is not equal to page LSN 18818885
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19642085 is not equal to page LSN 19653827
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=50, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=46, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18577598 is not equal to page LSN 18818885
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=50, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_history.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 14540529 is not equal to page LSN 19653841
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=50, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=46, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_file.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=50, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_history.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19658880 is not equal to page LSN 19668958
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=65, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=65, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_notify.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19658865 is not equal to page LSN 19672751
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=65, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=65, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_notify.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 17519970 is not equal to page LSN 17807134
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 17519970 is not equal to page LSN 17807134
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19640226 is not equal to page LSN 19652821
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=85, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=85, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_searchindex.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19659354 is not equal to page LSN 19672541
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=85, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=85, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_searchindex.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18622167 is not equal to page LSN 19075019
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19659373 is not equal to page LSN 19672561
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=85, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=85, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_searchindex.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19659392 is not equal to page LSN 19672597
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=85, page number=6]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=85, page number=6]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 6 from file './zentao/zt_searchindex.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2024-09-19 1:57:21 0 [Note] InnoDB: Starting shutdown...
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 17521401 is not equal to page LSN 19672916
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_DYNAMIC due to corruption on [page id: space=85, page number=13]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=85, page number=13]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 13 from file './zentao/zt_searchindex.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19642426 is not equal to page LSN 19654907
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=89, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=89, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/FTS_0000000000000062_DELETED.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18896447 is not equal to page LSN 19655005
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=99, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=99, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_story.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18701961 is not equal to page LSN 19039873
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18896432 is not equal to page LSN 19654475
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=99, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=99, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=99, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_story.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=99, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_story.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18896462 is not equal to page LSN 19094904
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_REUSE_DYNAMIC due to corruption on [page id: space=100, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18369187 is not equal to page LSN 19081807
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=102, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=100, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_storyreview.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=102, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_storyspec.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19475249 is not equal to page LSN 19507576
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18622167 is not equal to page LSN 18833200
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18622167 is not equal to page LSN 18833200
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19658268 is not equal to page LSN 19668354
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=127, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18622167 is not equal to page LSN 19668411
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=127, page number=4]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=127, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_im_message.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 12843267 is not equal to page LSN 19668426
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=127, page number=5]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=127, page number=5]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 5 from file './zentao/zt_im_message.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19658357 is not equal to page LSN 19668441
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=127, page number=6]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=127, page number=6]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 6 from file './zentao/zt_im_message.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 19658371 is not equal to page LSN 19668455
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=127, page number=7]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=127, page number=4]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 4 from file './zentao/zt_im_message.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 15168609 is not equal to page LSN 19672736
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=131, page number=3]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=131, page number=3]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 3 from file './zentao/zt_im_messagestatus.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [Warning] InnoDB: The last skipped log record LSN 18701991 is not equal to page LSN 19654990
2024-09-19 1:57:21 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=99, page number=6]
2024-09-19 1:57:21 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=127, page number=7]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 7 from file './zentao/zt_im_message.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:21 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=99, page number=6]; set innodb_force_recovery to ignore
2024-09-19 1:57:21 0 [ERROR] InnoDB: Failed to read page 6 from file './zentao/zt_story.ibd': Page read from tablespace is corrupted.
2024-09-19 1:57:23 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-09-19 1:57:23 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-09-19 1:57:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-19 1:57:23 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-09-19 1:57:23 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-09-19 1:57:23 0 [ERROR] Aborting
首先，应该想办法把数据库启动起来
日志里提示了一句：Set innodb_force_recovery=1 to ignore corruption.
这样操作可能有部分数据丢失
1.3、操作前先备份
/opt/zbox/zbox stop
cd /opt
tar –czf zbox.tar.gz zbox
#解压 tar -xzvf zbox.tar.gz1.4、数据库设置，启动数据库
/opt/zbox/etc/mysql/my.cnf，添加
1.4.1 设置innodb_force_recovery
[mysqld]
innodb_force_recovery = 1/opt/zbox/zbox start
tail -f mysql_error.log这时数据库就能启动了。
2024-09-20 11:16:45 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2024-09-20 11:16:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2024-09-20 11:16:45 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-20 11:16:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-20 11:16:45 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2024-09-20 11:16:45 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-20 11:16:46 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-20 11:16:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-20 11:16:46 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-20 11:16:46 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-09-20 11:16:46 0 [Note] InnoDB: 10.7.6 started; log sequence number 73733823; transaction id 248939
2024-09-20 11:16:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-20 11:16:46 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2024-09-20 11:16:46 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-09-20 11:16:46 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-09-20 11:16:46 0 [Note] /opt/zbox/run/mysql/mariadbd: ready for connections.
Version: '10.7.6-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3306 Source distribution
2024-09-20 11:16:47 0 [Note] InnoDB: Buffer pool(s) load completed at 240920 11:16:47
2024-09-20 11:17:12 4 [ERROR] Got error 126 when reading table './zentao/zt_cron'
2024-09-20 11:17:12 4 [ERROR] mariadbd: Index for table 'zt_cron' is corrupt; try to repair it
2024-09-20 11:17:17 6 [ERROR] Got error 126 when reading table './zentao/zt_cron'
2024-09-20 11:17:17 6 [ERROR] mariadbd: Index for table 'zt_cron' is corrupt; try to repair it
2024-09-20 11:19:09 9 [ERROR] Got error 126 when reading table './zentao/zt_cron'
2024-09-20 11:19:09 9 [ERROR] mariadbd: Index for table 'zt_cron' is corrupt; try to repair it
2024-09-20 11:19:26 0 [Note] /opt/zbox/run/mysql/mariadbd (initiated by: unknown): Normal shutdown
2024-09-20 11:19:26 0 [Note] InnoDB: FTS optimize thread exiting.
2024-09-20 11:19:26 0 [Note] InnoDB: Starting shutdown...
2024-09-20 11:19:26 0 [Note] InnoDB: Dumping buffer pool(s) to /opt/zbox/data/mysql/ib_buffer_pool
2024-09-20 11:19:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 240920 11:19:26
2024-09-20 11:19:26 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-09-20 11:19:26 0 [Note] InnoDB: Shutdown completed; log sequence number 73733835; transaction id 248951
2024-09-20 11:19:27 0 [Note] /opt/zbox/run/mysql/mariadbd: Shutdown complete
1.4.2 注释innodb_force_recovery
[mysqld]
#innodb_force_recovery = 1 #或者设为0/opt/zbox/zbox stop
/opt/zbox/zbox start
tail -f mysql_error.log再次启动，数据库还有一些报错，主要是索引报错。
这时禅道可以访问出页面了。
2024-09-20 11:21:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2024-09-20 11:21:00 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-20 11:21:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-09-20 11:21:00 0 [Note] InnoDB: Initializing buffer pool, total size = 536870912, chunk size = 134217728
2024-09-20 11:21:00 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-20 11:21:02 0 [Note] InnoDB: 128 rollback segments are active.
2024-09-20 11:21:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-20 11:21:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-20 11:21:02 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-09-20 11:21:02 0 [Note] InnoDB: 10.7.6 started; log sequence number 73733835; transaction id 248939
2024-09-20 11:21:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-20 11:21:02 0 [Note] InnoDB: Loading buffer pool(s) from /opt/zbox/data/mysql/ib_buffer_pool
2024-09-20 11:21:02 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2024-09-20 11:21:02 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-09-20 11:21:02 0 [Note] /opt/zbox/run/mysql/mariadbd: ready for connections.
Version: '10.7.6-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3306 Source distribution
2024-09-20 11:21:02 0 [Note] InnoDB: Buffer pool(s) load completed at 240920 11:21:02
2024-09-20 11:21:21 4 [ERROR] Got error 126 when reading table './zentao/zt_cron'
2024-09-20 11:21:21 4 [ERROR] mariadbd: Index for table 'zt_cron' is corrupt; try to repair it
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 12; hex 6c696e6c69616e6a69616e67; asc linlianjiang;;
1: len 4; hex 000006ed; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 5; hex 61646d696e; asc admin;;
1: len 4; hex 00000002; asc ;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 14759, returned by func 14763
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 6 page 5 of index `actor` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 5 of index `actor` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 000002; asc ;;
1: len 4; hex 0000001a; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 000000; asc ;;
1: len 4; hex 00000002; asc ;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 8940, returned by func 8948
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 6 page 6 of index `project` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 6 of index `project` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 5; hex 6c6f67696e; asc login;;
1: len 4; hex 00000001; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 9; hex 636f6d6d656e746564; asc commented;;
1: len 4; hex 000000d7; asc ;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 12425, returned by func 12429
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 6 page 7 of index `action` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 7 of index `action` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 5, 4, rec 797
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 6 page 8 of index `objectID` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 8 of index `objectID` of table `zentao`.`zt_action`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 9; hex 79696e79757169616f; asc yinyuqiao;;
1: len 3; hex 8000af; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 9; hex 79696e79757169616f; asc yinyuqiao;;
1: len 3; hex 800092; asc ;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 9; hex 79696e79757169616f; asc yinyuqiao;;
1: len 3; hex 800097; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 9; hex 79696e79757169616f; asc yinyuqiao;;
1: len 3; hex 800037; asc 7;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 1109, returned by func 1107
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 21 page 12 of index `assignedTo` of table `zentao`.`zt_bug`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 12 of index `assignedTo` of table `zentao`.`zt_bug`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 30; hex 7a68616f79616e71696e6720202020202020202020202020202020202020; asc zhaoyanqing ; (total 32 bytes);
1: len 30; hex 6f6475637462726f77736520202020202020202020202020202020202020; asc oductbrowse ;;
2: len 7; hex 2020202020756e; asc un;;
3: len 0; hex ; asc ;;
4: len 0; hex ; asc ;;
5: len 3; hex 666f6c; asc fol;;
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 0; hex ; asc ;;
1: len 30; hex 7a68616f79616e71696e6720202020202020202020202020202020202020; asc zhaoyanqing ;;
2: len 7; hex 70726f6a656374; asc project;;
3: len 30; hex 626c6f636b20202020202020202020202020202020202020202020202020; asc block ;;
4: len 30; hex 696e697456657273696f6e20202020202020202020202020202020202020; asc initVersion ;;
5: len 3; hex 00005e; asc ^;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 3; hex 726e64; asc rnd;;
1: len 30; hex 79696e79757169616f202020202020202020202020202020202020202020; asc yinyuqiao ;;
2: len 7; hex 70726f64756374; asc product;;
3: len 30; hex 636f6d6d6f6e202020202020202020202020202020202020202020202020; asc common ;;
4: len 30; hex 626c6f636b496e6974656420202020202020202020202020202020202020; asc blockInited ;;
5: len 3; hex 000052; asc R;;
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 0; hex ; asc ;;
1: len 0; hex ; asc ;;
2: len 0; hex ; asc ;;
3: len 0; hex ; asc ;;
4: len 0; hex ; asc ;;
5: len 3; hex 726e64; asc rnd;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 7105, returned by func 7280
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 31 page 4 of index `unique` of table `zentao`.`zt_config`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 4 of index `unique` of table `zentao`.`zt_config`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 7, 4, rec 541
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 32 page 4 of index `lastTime` of table `zentao`.`zt_cron`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 4 of index `lastTime` of table `zentao`.`zt_cron`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 12, 4, rec 161
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 50 page 4 of index `action` of table `zentao`.`zt_history`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 4 of index `action` of table `zentao`.`zt_history`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Records in wrong order
InnoDB: previous record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 63633663616338392d646663382d336264382d666137382d623730643130; asc cc6cac89-dfc8-3bd8-fa78-b70d10; (total 40 bytes);
1: len 4; hex 00000001; asc ;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 30; hex 31656139363264362d633136642d646564622d383334302d666139613832; asc 1ea962d6-c16d-dedb-8340-fa9a82; (total 40 bytes);
1: len 4; hex 000003cf; asc ;;
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 15400, returned by func 15404
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 127 page 4 of index `mgid` of table `zentao`.`zt_im_message`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 4 of index `mgid` of table `zentao`.`zt_im_message`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 12, 8, rec 177
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 131 page 3 of index `user` of table `zentao`.`zt_im_messagestatus`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 3 of index `user` of table `zentao`.`zt_im_messagestatus`
2024-09-20 11:21:55 5 [ERROR] InnoDB: n recs wrong 138 279
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 65 page 4 of index `objectType_toList_status` of table `zentao`.`zt_notify`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 4 of index `objectType_toList_status` of table `zentao`.`zt_notify`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Table zentao/zt_searchindex contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 4, 5, rec 195
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 85 page 6 of index `addedDate` of table `zentao`.`zt_searchindex`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 6 of index `addedDate` of table `zentao`.`zt_searchindex`
2024-09-20 11:21:55 5 [ERROR] InnoDB: Wrong owned count 6, 4, rec 192
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 99 page 6 of index `assignedTo` of table `zentao`.`zt_story`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 6 of index `assignedTo` of table `zentao`.`zt_story`
2024-09-20 11:21:55 5 [Warning] InnoDB: Heap no of rec 235 too big 484 9
2024-09-20 11:21:55 5 [ERROR] InnoDB: Summed data size 1815, returned by func 2146
2024-09-20 11:21:55 5 [ERROR] InnoDB: Apparent corruption in space 102 page 3 of index `story` of table `zentao`.`zt_storyspec`
2024-09-20 11:21:55 5 [ERROR] InnoDB: In page 3 of index `story` of table `zentao`.`zt_storyspec`
2024-09-20 11:22:06 6 [ERROR] InnoDB: Table zentao/zt_searchindex contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2024-09-20 11:22:57 7 [ERROR] InnoDB: Table zentao/zt_searchindex contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2024-09-20 11:25:14 7 [Warning] InnoDB: A transaction id in a record of table `zentao`.`zt_im_messagestatus` is newer than the system-wide maximum.
2024-09-20 11:25:14 7 [Warning] InnoDB: A transaction id in a record of table `zentao`.`zt_im_messagestatus` is newer than the system-wide maximum.
2024-09-20 11:25:14 7 [ERROR] InnoDB: Trying to read 16384 bytes at 61568356712448 outside the bounds of the file: ./ibdata1
2024-09-20 11:25:14 7 [ERROR] InnoDB: File './ibdata1' is corrupted
2024-09-20 11:25:14 7 [Warning] InnoDB: A transaction id in a record of table `zentao`.`zt_im_messagestatus` is newer than the system-wide maximum.
2024-09-20 11:25:14 7 [Warning] InnoDB: A transaction id in a record of table `zentao`.`zt_im_messagestatus` is newer than the system-wide maximum.
2024-09-20 11:25:14 7 [ERROR] InnoDB: Trying to read 16384 bytes at 70352101179392 outside the bounds of the file: ./ibdata1
2024-09-20 11:25:50 7 [ERROR] InnoDB: Table zentao/zt_searchindex contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
2024-09-20 11:25:50 7 [ERROR] InnoDB: Table zentao/zt_searchindex contains 5 indexes inside InnoDB, which is different from the number of indexes 4 defined in the .frm file. See https://mariadb.com/kb/en/innodb-troubleshooting/
二、数据库表可能因为断电原因损坏，需要检查修复！！
2.1、访问禅道，跳转到检查表页面
按照提示，创建文件/opt/zbox/app/zentao/www/repair_66ebc5b9e1787.txt，
他不会往文件里写东西，应该是验证你的操作权限。
2.2、查看表状态，尝试修复
都是表索引有问题，在页面最下面有修复表按钮
zt_action，innodb: the b-tree of index actor is corrupted.
2.3、修复表，修复失败
zt_account，the storage engine for the table doesn't support repair
修复失败，请到该数据库的数据目录下，尝试执行myisamchk -r -f zt_account.MYI进行修复。
没有.MYI文件，有.frm和.ibd文件。MYI文件是MyISAM存储引擎的索引文件。
2.4、使用数据库命令，重建索引
ALTER TABLE table_name ENGINE=InnoDB;
（这个命令应该是新建表，把数据复制过去，重建索引。可能会导致数据丢失）
也可以尝试，删除表的索引，然后手动重建。
cd /opt/zbox/run/mysql
./mysql -u root
./mysql -u root -p #禅道数据库默认密码是123456MariaDB [mysql]> use zentao
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
MariaDB [zentao]> ALTER TABLE zentao.zt_action ENGINE=InnoDB;
Query OK, 0 rows affected (10.538 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_bug ENGINE=InnoDB;
Query OK, 0 rows affected (0.306 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_config ENGINE=InnoDB;
Query OK, 0 rows affected (0.086 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_cron ENGINE=InnoDB;
Query OK, 0 rows affected (0.045 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_file ENGINE=InnoDB;
Query OK, 0 rows affected (0.168 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_history ENGINE=InnoDB;
Query OK, 0 rows affected (0.216 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_im_message ENGINE=InnoDB;
Query OK, 0 rows affected (0.146 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_im_messagestatus ENGINE=InnoDB;
ERROR 1642 (01000): InnoDB: Transaction id in a record of table `zentao`.`zt_im_messagestatus` is newer than system-wide maximum.
MariaDB [zentao]> ALTER TABLE zentao.zt_im_messagestatus ENGINE=InnoDB;
Query OK, 0 rows affected (0.076 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_notify ENGINE=InnoDB;
Query OK, 0 rows affected (0.028 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_searchindex ENGINE=InnoDB;
Query OK, 68 rows affected, 2 warnings (0.475 sec)
Records: 68 Duplicates: 0 Warnings: 2
MariaDB [zentao]> ALTER TABLE zentao.zt_story ENGINE=InnoDB;
Query OK, 0 rows affected (0.160 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [zentao]> ALTER TABLE zentao.zt_storyspec ENGINE=InnoDB;
Query OK, 0 rows affected (0.352 sec)
Records: 0 Duplicates: 0 Warnings: 02.4、再次访问禅道首页，就可以正常访问了。
但是。。有些数据丢失了。
2.5 可以看下禅道是否自动做了数据库备份
我的是空的
三、mysql相关数据库命令参考
# 显示建表语句
SHOW CREATE TABLE table_name;
# 导出数据库表结构
mysqldump -u username -p --no-data database_name > database_structure.sql
# 检查表
CHECK TABLE table_name;
# 查询表记录数
select count(*) from table_name;
# 查询表的索引
SHOW INDEXES FROM table_name;
# “重建索引”
ALTER TABLE table_name ENGINE=InnoDB;
# 删除表的索引
#ALTER TABLE table_name DROP INDEX index_name;
3.1 禅道数据库允许远程连接
3.2 禅道数据库备份
禅道使用手册
https://www.zentao.net/book/zentaopmshelp/42.html
四、报错处理
MariaDB [zentao]> ALTER TABLE zentao.zt_action ENGINE=InnoDB;
ERROR 1036 (HY000): Table 'zt_action' is read only“mysql关闭表只读”，“mysql取消表只读”
把my.cnf中的innodb_force_recovery行注释掉，或设置innodb_force_recovery = 0，重启。
一站式 AI 云服务平台
更多推荐
10
0- 0
已为社区贡献7条内容
所有评论(0)