Assertion `m_lock_type == 2' failed in sql/handler.cc:2753 | abort (sig=6) in handler::ha_close
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
***************** Text case
CREATE TEMPORARY TABLE t1(c1 BIT);
ALTER TABLE t1 ENGINE=BLACKHOLE;
LOCK TABLES t1 WRITE;
TRUNCATE TABLE t1;
***************** GDB
+bt
#0 0x00007f2b82c74771 in pthread_kill () from /lib64/
#1 0x0000000000ab75b6 in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072fa2f in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f2b818785c9 in raise () from /lib64/libc.so.6
#5 0x00007f2b81879cd8 in abort () from /lib64/libc.so.6
#6 0x00007f2b81871536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f2b818715e2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000064225c in handler::ha_close (this=0x7f2a88c
#9 0x00000000008ab948 in closefrm (table=
#10 0x000000000076f55f in close_temporary (table=
#11 0x000000000076f43a in close_temporary
#12 0x00000000009f8df3 in recreate_
#13 0x00000000009f9302 in Sql_cmd_
#14 0x00000000009f95cb in Sql_cmd_
#15 0x00000000007e9dd3 in mysql_execute_
#16 0x00000000007ed1c3 in mysql_parse (thd=0x7f2ad3ea
#17 0x00000000007df62c in dispatch_command (command=COM_QUERY, thd=0x7f2ad3ea3000, packet=
#18 0x00000000007de558 in do_command (thd=0x7f2ad3ea
#19 0x00000000007a6515 in do_handle_
#20 0x00000000007a601d in handle_
#21 0x0000000000dc5bdc in pfs_spawn_thread (arg=0x7f2b66bb
#22 0x00007f2b82c6fdf3 in start_thread () from /lib64/
#23 0x00007f2b8193901d in clone () from /lib64/libc.so.6
(gdb) +set logging off
Upstream?