mysqldump: Error 1030: Got error 127 from storage engine when dumping table

I am having trouble working out what is causing this issue.

We have a slave server that runs a backup each night. The backup dumps two data bases.

A few minutes into the backup we get an error as below:

mysqldump: Error 1030: Got error 127 from storage engine when dumping table

Then after looking at the slave status we see the below:


   Slave_IO_Running: Yes
          Slave_SQL_Running: No


I then manage to get the Slave_SQL_Running to a YES status and re run the backup, this then errors again and the Slave_SQL_Running goes back to a status of NO.

Any help on getting this working again would be great.

Thanks

Phil
LVL 1
PhilMacavityAsked:
Who is Participating?
 
PhilMacavityAuthor Commented:
The backup now works after the suspect table has been repaired.
0
 
johanntagleCommented:
Can you check the .err log file for any messages?  You may have a similar case as http://bugs.mysql.com/bug.php?id=10424, where the machine was low in memory.
0
 
PhilMacavityAuthor Commented:
Thanks for the link. On further investigation it appears that one of the tables in the database is marked as "Crashed" /I have repaired the table, started up the slave sql and am now re-running the backup.

I will post the results shortly.

Phil
0
 
johanntagleCommented:
Good to know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.