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

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.

问题解决

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

调整innodb_force_recovery=0参数后，重启数据库相关表insert成功，错误日志报错消失。