1030 – Got error -1 from storage engine

I am using on one project InnoDB type of tables. There is very important have actual data. So I am actively using foreign keys for tables linking. And once I came across problem when tried to delete from table (`group`) which linked by foreign key with another table (`subgroup`) which linked by foreign key with another table (`item`).
This is error shown by phpmyadmin:
Error
SQL query:
DELETE FROM `fancypets`.`groups` WHERE `groups`.`group_id` =1
MySQL said: Documentation
#1030 - Got error -1 from storage engine

this error a got through mysql command line:

mysql> delete from groups where `group_id`=4;
ERROR 1030 (HY000): Got error -1 from storage engine

It is mysql’s error log:

Cannot delete/update rows with cascading foreign key constraints that exceed max depth of 250
If you use 5.1.51- Just update your mysql-server version.
This is bug of mysql-server-5.1.51 – after:
#portupgrade mysql-server

problem disappeared.

Posted on November 14th, 2011 by admin
Filed under: Development