8 Dec 2008, 2:04
Tags: , , ,
1 comment

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.

Tags: , , ,

 
  • Search


  • Calender

    December 2008
    M T W T F S S
    « Nov   Jan »
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
  • Twitter

    Powered by Twitter Tools

  • RSS Delicious feed

  • Archives