Today I got an error while updating my mysql record . I got “Mysql ‘Got error -1 from storage engine’ error” every time I try to update.
Below are the logs I found from my mysql error logs:
MySQL Error log path: /var/log/mysql/error.log
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.
Finally I got solution for that. To solve this issue follow below steps.
1. Stop your mysql server
sudo service mysql stop
2. Set innodb_force_recovery to 0 or remove this line from /etc/mysql/my.cnf
innodb_force_recovery = 0
3. Start your mysql server
sudo service mysql start
This will solve your problem.
Happy Coding 🙂