Assertion `m_lock_type == 2' failed in sql/handler.cc:2753 | abort (sig=6) in handler::ha_close

[Ramesh Sivaraman]

***************** 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/libpthread.so.0
#1 0x0000000000ab75b6 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072fa2f in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#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=0x7f2a88caaf10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2753
#9 0x00000000008ab948 in closefrm (table=0x7f2a88d5fa00, free_share=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/table.cc:2468
#10 0x000000000076f55f in close_temporary (table=0x7f2a88d5fa00, free_share=false, delete_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:2248
#11 0x000000000076f43a in close_temporary_table (thd=0x7f2ad3ea3000, table=0x7f2a88d5fa00, free_share=false, delete_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:2218
#12 0x00000000009f8df3 in recreate_temporary_table (thd=0x7f2ad3ea3000, table=0x7f2a88d5fa00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:287
#13 0x00000000009f9302 in Sql_cmd_truncate_table::truncate_table (this=0x7f2a88c1f650, thd=0x7f2ad3ea3000, table_ref=0x7f2a88c1f0e8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:437
#14 0x00000000009f95cb in Sql_cmd_truncate_table::execute (this=0x7f2a88c1f650, thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:543
#15 0x00000000007e9dd3 in mysql_execute_command (thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5411
#16 0x00000000007ed1c3 in mysql_parse (thd=0x7f2ad3ea3000, rawbuf=0x7f2a88c1f010 "TRUNCATE TABLE t1", length=17, parser_state=0x7f2b83265df0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#17 0x00000000007df62c in dispatch_command (command=COM_QUERY, thd=0x7f2ad3ea3000, packet=0x7f2ac3b06001 "TRUNCATE TABLE t1", packet_length=17) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#18 0x00000000007de558 in do_command (thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#19 0x00000000007a6515 in do_handle_one_connection (thd_arg=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#20 0x00000000007a601d in handle_one_connection (arg=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#21 0x0000000000dc5bdc in pfs_spawn_thread (arg=0x7f2b66bbab00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#22 0x00007f2b82c6fdf3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f2b8193901d in clone () from /lib64/libc.so.6
(gdb) +set logging off

[Laurynas Biveinis (laurynas-biveinis)]

Upstream?

[Ramesh Sivaraman (rameshvs02)]

Fulll bundle with all files (core, gdb stacks, error log, datadir and more)

[Ramesh Sivaraman (rameshvs02)]

This is upstream bug : http://bugs.mysql.com/bug.php?id=74436

[Shahriyar Rzayev (rzayev-sehriyar)]

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