网站登录 MySQL 错误

Question

我在尝试登录 WordPress、登录 Django 或尝试重新导入表(尝试调试错误)时收到此一般错误:

1030 - 来自存储引擎的错误-1

MySQL.com 对此是这样说的:

Error: 1030 SQLSTATE: HY000 (ER_GET_ERRNO)

Message: Got error %d from storage engine

Check the %d value to see what the OS error means. For example, 28indicates that you have run out of disk space.

但这对我来说仍然模棱两可。如何找到操作系统错误？我没有通过 Google 搜索、mysqltuner、重新启动服务或通过 PHPMyAdmin 修复找到任何帮助。

Answer 1

问题是 my.cnf 将 innodb_force_recovery 设置为 1。我不明白的是它几个月来都工作得很好。

此外，我在其中一个错误日志中发现了这一点(不知何故有两个):

InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.

找到了删除该值或将该值设置为 0 的解决方案，此处:

Mysql 'Got error -1 from storage engine' error