LOCK TABLES FOR BACKUP should be incompatible with LOCK TABLES, FLUSH TABLES ... WITH READ LOCK, FLUSH TABLES ... FOR EXPORT in the same connection
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Alexey Kopytov | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Low
|
Alexey Kopytov |
Bug Description
=======
mysqld: /mnt/workspace/
lease(THD*): Assertion `m_lock != __null && thd->mdl_
13:16:55 UTC - mysqld got signal 6 ;
---
--
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f55d9cd6010): UNLOCK TABLES
Connection ID (thread ID): 19
Status: NOT_KILLED
=======
Thread 1 (LWP 14549):
+bt
#0 0x00007f56441b9771 in pthread_kill () from /lib64/
#1 0x0000000000aaa60e in my_write_core (sig=6) at /mnt/workspace/
#2 0x0000000000727d92 in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f5642dbd989 in raise () from /lib64/libc.so.6
#5 0x00007f5642dbf098 in abort () from /lib64/libc.so.6
#6 0x00007f5642db68f6 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f5642db69a2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000094e244 in Global_
#9 0x00000000007dde4f in mysql_execute_
#10 0x00000000007e4c87 in mysql_parse (thd=0x7f560dbe
#11 0x00000000007d7222 in dispatch_command (command=COM_QUERY, thd=0x7f560dbef000, packet=
#12 0x00000000007d614e in do_command (thd=0x7f560dbe
#13 0x00000000008b9ca7 in threadpool_
#14 0x00000000008bc589 in handle_event (connection=
#15 0x00000000008bc7b9 in worker_main (param=0x1880c00 <all_groups+2048>) at /mnt/workspace/
#16 0x0000000000db42e0 in pfs_spawn_thread (arg=0x7f56263b
#17 0x00007f56441b4df3 in start_thread () from /lib64/
#18 0x00007f5642e7e3dd in clone () from /lib64/libc.so.6
(gdb) +set logging off
=======
PS startup cmd:
/ssd/ramesh/
SQL_out
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(
c1 CHAR(1),
key(c1)) ENGINE=innodb ROW_FORMAT=dynamic;
LOCK TABLES FOR BACKUP;
LOCK TABLE t1 READ LOCAL;
UNLOCK TABLES;
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 196 lines (+124/-1)3 files modifiedmysql-test/r/backup_locks.result (+35/-0)
mysql-test/t/backup_locks.test (+53/-0)
sql/sql_parse.cc (+36/-1)
tags: | added: qa |
summary: |
- /sql/lock.cc:1140: void Global_backup_lock::release(THD*): Assertion - `m_lock != __null && thd->mdl_context.is_lock_owner(m_namespace, "", "", - MDL_SHARED)' failed + LOCK TABLES FOR BACKUP should be incompatible with LOCK TABLES, FLUSH + TABLES ... WITH READ LOCK, FLUSH TABLES ... FOR EXPORT in the same + connection |
Alexey, would you mind taking a look?