MySQL Error Code: 1030Got error -1 from storage en

Question

I have a database including some tables, when I want to delete data from tables which includes an "Auto Increment" field, using this query:

delete from test.table1 ;

I got this error:

 Error Code: 1030Got error -1 from storage engine

Why this happens? What should I do?

Answer 1

I also met this error while deleting 2 rows from an Innodb table, only 2 particular rows can't be deleted. I Google the error, but can't find better solutions.

So i tried this:

1. Create a backup for my db (exporting db).

2. Re-Installing MySQL Server

3. Restoring my db (importing db).

4. Then there is no -1 engine error on deletion/update.

Success...

I think the error may occur due to invalid configuration of MySQL server with respect to storage engines.

Thank You....

Answer 2

I see no answer has been selected as the right answer.

I found that in our database config we had the innodb_force_recovery configured. Once we disabled / commented it out, the queries ran as expected.

Answer 3

For me the problem was solved by restarting my database (in my case Mariadb).

systemctl restart mariadb

Answer 4

Go to /etc/my.cnf or /etc/mysql/my.cnf

Comment line innodb_force_recovery=1

Save the file and restart mysql

Answer 5

Try to change innodb_force_recovery value (in your /etc/my.cnf).

Error -1 says NOTHING. Without your tables creation code (SHOW CREATE TABLE table_name) can not say where exactly problem is.

Answer 6

Here's how I solved it, I just had the same error:

1. Open Control Panel
2. Select Unistall Programs
3. Right click and select"Uninstall" on Microsoft Visual Basic Tools
4. Restart your PC