MySQL 报 Table is read only，Failed to find tablespace for table

数据运维 2024-07-04 穿过生命散发芬芳 手机阅读

insert 业务表报Table xxx is read only，error log 大量报错 [ERROR] InnoDB: Failed to find tablespace for table '"xxx.xx"' in the cache. Attempting to load the tablespace with space id x.

MySQL 报 Table is read only，Failed to find tablespace for table-每日运维
MySQL 报 Table is read only，Failed to find tablespace for table-每日运维

问题解决

查看my.cnf配置文件，发现数据库运行在innodb_force_recovery=4模式。

MySQL 报 Table is read only，Failed to find tablespace for table-每日运维

调整innodb_force_recovery=0参数后，重启数据库相关表insert成功，错误日志报错消失。
MySQL 报 Table is read only，Failed to find tablespace for table-每日运维