Assertion `duration != MDL_EXPLICIT || !thd->mdl_context.is_lock_owner(m_namespace, "", "", MDL_INTENTION_EXCLUSIVE)' failed in sql/lock.cc:1198

[Ramesh Sivaraman]

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@autocommit=FALSE;
SET @@global.master_info_repository="TABLE";
CHANGE MASTER TO MASTER_CONNECT_RETRY=0,MASTER_HEARTBEAT_PERIOD=0.0;

The attached tarball gives the testcase as an exact match of our system, including some handy utilities

$ vi {epoch}_mybase # Update base path in this file (the only change
required!). For non-binary distribution please update SOURCE_DIR location also.
$ ./{epoch}_init # Initializes the data dir
$ ./{epoch}_start # Starts mysqld
$ ./{epoch}_cl # To check mysqld is up
$ ./{epoch}_run # Run the testcase with pquery binary(produces
output)
$ vi /dev/shm/{epoch}/error.log.out # Verify the error log
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb;
standard and full var gdb stack traces
etc.

** GDB info

#0 0x00007f80f964b771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ac1d62 in my_write_core (sig=6) at /home/ramesh/ps/percona-server-5.6/mysys/stacktrace.c:422
#2 0x000000000073270f in handle_fatal_signal (sig=6) at /home/ramesh/ps/percona-server-5.6/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f80f824f5c9 in raise () from /lib64/libc.so.6
#5 0x00007f80f8250cd8 in abort () from /lib64/libc.so.6
#6 0x00007f80f8248536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f80f82485e2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000095dd3b in Global_backup_lock::acquire_protection (this=0x7f80e77abaf0, thd=0x7f80e77aa000, duration=MDL_EXPLICIT, lock_wait_timeout=31536000) at /home/ramesh/ps/percona-server-5.6/sql/lock.cc:1196
#9 0x0000000000a6e127 in global_init_info (mi=0x7f80e77ae000, ignore_if_no_info=false, thread_mask=3) at /home/ramesh/ps/percona-server-5.6/sql/rpl_slave.cc:730
#10 0x0000000000a8496e in change_master (thd=0x7f80e77aa000, mi=0x7f80e77ae000) at /home/ramesh/ps/percona-server-5.6/sql/rpl_slave.cc:8650
#11 0x00000000007e7ae1 in mysql_execute_command (thd=0x7f80e77aa000) at /home/ramesh/ps/percona-server-5.6/sql/sql_parse.cc:3213
#12 0x00000000007f19df in mysql_parse (thd=0x7f80e77aa000, rawbuf=0x7f80d7420010 "CHANGE MASTER TO MASTER_CONNECT_RETRY=0,MASTER_HEARTBEAT_PERIOD=0.0", length=67, parser_state=0x7f80f9c01df0) at /home/ramesh/ps/percona-server-5.6/sql/sql_parse.cc:6922
#13 0x00000000007e381c in dispatch_command (command=COM_QUERY, thd=0x7f80e77aa000, packet=0x7f80e0abb001 "CHANGE MASTER TO MASTER_CONNECT_RETRY=0,MASTER_HEARTBEAT_PERIOD=0.0", packet_length=67) at /home/ramesh/ps/percona-server-5.6/sql/sql_parse.cc:1434
#14 0x00000000007e272e in do_command (thd=0x7f80e77aa000) at /home/ramesh/ps/percona-server-5.6/sql/sql_parse.cc:1051
#15 0x00000000007aa262 in do_handle_one_connection (thd_arg=0x7f80e77aa000) at /home/ramesh/ps/percona-server-5.6/sql/sql_connect.cc:1532
#16 0x00000000007a9d6a in handle_one_connection (arg=0x7f80e77aa000) at /home/ramesh/ps/percona-server-5.6/sql/sql_connect.cc:1443
#17 0x0000000000b8b4e8 in pfs_spawn_thread (arg=0x7f80f2b40a20) at /home/ramesh/ps/percona-server-5.6/storage/perfschema/pfs.cc:1860
#18 0x00007f80f9646df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f80f83101ad in clone () from /lib64/libc.so.6

[Alexey Kopytov (akopytov)]

https://github.com/percona/percona-server/pull/87

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1613