MySQL says: "ERROR 1030 (HY000): Got error -1 from storage engine"

In my case, this meant it was not allowed to write data (an INSERT) to a InnoDB table because innodb_force_recovery was set too high. Took me a while to figure out, so I hope this helps someone.

Solution is to simply disable the innodb_force_recovery. You should use that setting only for making an emergency dump anyway.

More about my wanderings through MySQL+InnoDB+NFS land soon.


Comments powered by Disqus