Assertion `duration != MDL_EXPLICIT || !thd->mdl_context.is_lock_owner(m_namespace, "", "", MDL_INTENTION_EXCLUSIVE)' failed in sql/lock.cc:1198
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@autocommit=FALSE;
SET @@global.
CHANGE MASTER TO MASTER_
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}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}
standard and full var gdb stack traces
etc.
** GDB info
#0 0x00007f80f964b771 in pthread_kill () from /lib64/
#1 0x0000000000ac1d62 in my_write_core (sig=6) at /home/ramesh/
#2 0x000000000073270f in handle_fatal_signal (sig=6) at /home/ramesh/
#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_
#9 0x0000000000a6e127 in global_init_info (mi=0x7f80e77ae000, ignore_
#10 0x0000000000a8496e in change_master (thd=0x7f80e77a
#11 0x00000000007e7ae1 in mysql_execute_
#12 0x00000000007f19df in mysql_parse (thd=0x7f80e77a
#13 0x00000000007e381c in dispatch_command (command=COM_QUERY, thd=0x7f80e77aa000, packet=
#14 0x00000000007e272e in do_command (thd=0x7f80e77a
#15 0x00000000007aa262 in do_handle_
#16 0x00000000007a9d6a in handle_
#17 0x0000000000b8b4e8 in pfs_spawn_thread (arg=0x7f80f2b4
#18 0x00007f80f9646df3 in start_thread () from /lib64/
#19 0x00007f80f83101ad in clone () from /lib64/libc.so.6
tags: | added: backup-locks |
https:/ /github. com/percona/ percona- server/ pull/87