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:
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.