150325 03:02:51 innobackupex: Executing LOCK BINLOG FOR BACKUP...
150325 03:02:51 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(0x18ad1a0)', '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.
150325 03:02:51 innobackupex: Waiting for ibbackup (pid=33362) to finish
We are seeing this problem on 5.6.22- 25.8-978. wheezy in combination with xtrabackup 2.2.6-5042- 1.wheezy:
*** glibc detected *** /usr/sbin/mysqld: malloc(): smallbin double linked list corrupted: 0x00007f5b5ac445d0 *** 64-linux- gnu/libc. so.6(+0x76a16) [0x7f5e7abdea16 ] 64-linux- gnu/libc. so.6(+0x7a2f8) [0x7f5e7abe22f8 ] 64-linux- gnu/libc. so.6(__ libc_malloc+ 0x70)[0x7f5e7ab e38a0] x86_64- linux-gnu/ libstdc+ +.so.6( _ZnwmRKSt9nothr ow_t+0x1d) [0x7f5e7b3fc10d ] mysqld( _ZN10MDL_ ticket6createEP 11MDL_context13 enum_mdl_ type+0x25) [0x674085] mysqld( _ZN11MDL_ context21try_ acquire_ lock_implEP11MD L_requestPP10MD L_ticket+ 0xb0)[0x675490] mysqld( _ZN11MDL_ context12acquir e_lockEP11MDL_ requestm+ 0xa5)[0x675b45] mysqld( my_print_ stacktrace+ 0x2e)[0x8ccd9e] mysqld( handle_ fatal_signal+ 0x36c)[ 0x6828dc] 64-linux- gnu/libpthread. so.0(+0xf0a0) [0x7f5e7c97f0a0 ] mysqld( _ZN18Global_ backup_ lock18acquire_ protectionEP3TH D17enum_ mdl_durationm+ 0x58)[0x66c678]
======= Backtrace: =========
/lib/x86_
/lib/x86_
/lib/x86_
/usr/lib/
stack_bottom = 7f5ba035de50 thread_stack 0x30000
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib/x86_
/usr/sbin/
[0x7f5dcc0000a8]
xtrabackup reports:
150325 03:02:51 innobackupex: Executing LOCK BINLOG FOR BACKUP... innobackupex line 3036. innobackupex line 3039
main:: mysql_query( 'HASH(0x18ad1a0 )', 'FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS') called at /usr/bin/ innobackupex line 2024
main:: backup( ) called at /usr/bin/ innobackupex line 1592 innobackupex line 3036.
150325 03:02:51 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/
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/
150325 03:02:51 innobackupex: Waiting for ibbackup (pid=33362) to finish
We will upgrade xtrabackup to 2.2.9 and test.