Comment 14 for bug 1401133

Revision history for this message
Thomas Roog (thomas.roog) wrote :

It has also affected us this weekend. It happens every time there is a higher load on the cluster.
There are 2 reporting slaves attached to that node. Backup with correct binary logs positions is required to restore reporting slaves. Can we please fix it?

150226 22:17:18 innobackupex: Finished backing up non-InnoDB tables and files

150226 22:17:18 innobackupex: Executing LOCK BINLOG FOR BACKUP...
150226 22:17:18 innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/bin/innobackupex line 3036.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3039.
 main::mysql_query('HASH(0x26ff468)', 'FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS') called at /usr/bin/innobackupex line 2024
 main::backup() called at /usr/bin/innobackupex line 1592
innobackupex: Error:
Error executing 'FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS': DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/bin/innobackupex line 3036.
150226 22:17:18 innobackupex: Waiting for ibbackup (pid=4367) to finish