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
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... innobackupex line 3036. innobackupex line 3039. mysql_query( 'HASH(0x26ff468 )', 'FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS') called at /usr/bin/ innobackupex line 2024 innobackupex line 1592 innobackupex line 3036.
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: got a fatal error with the following stacktrace: at /usr/bin/
main::
main::backup() called at /usr/bin/
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/
150226 22:17:18 innobackupex: Waiting for ibbackup (pid=4367) to finish