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

Bug #1382749 reported by Ramesh Sivaraman on 2014-10-18
6
This bug affects 1 person
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/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

Upstream?

Ramesh Sivaraman (rameshvs02) wrote :

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

tags: added: upstream
Ramesh Sivaraman (rameshvs02) wrote :

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.