Error unlocking tables at end of backup.

12-09-2011, 09:48 AM

On a slave server, I'm having a problem with this persistent error condition following a backup. The backup has finished with the InnoDB tables, has locked and flushed the MyISAM tables successfully, and has even completed backing up the MyISAM tables. Following this, the statement to unlock tables is sent and an error is produced. I'm hoping someone may have some advice how to get around this problem.

The server is still running fine, except that innobackupex exits and leaves the Slave SQL thread down. So, I've had to go in and restart it manually. The time between locking the tables and unlocking them is approximately 12 minutes. Could this be a timeout issue of some kind?