Percona Server moved to https://jira.percona.com/projects/PS

handle_fatal_signal (sig=11) MDL_ticket::has_stronger_or_equal_type | sql/mdl.cc:1976

Series 5.7
Bug #1444706

Bug #1444706 reported by Ramesh Sivaraman on 2015-04-15

This bug affects 1 person

	Status	Importance	Assigned to
Percona Server moved to https://jira.percona.com/projects/PS	Status tracked in 5.7
5.1	Invalid	Undecided	Unassigned
5.5	Invalid	Undecided	Unassigned
5.6	Triaged	High	Unassigned
5.7	Triaged	High	Unassigned

Bug Description

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
create table user_stopword_session(value varchar(1)) engine=innodb;
XA START'';
set session innodb_ft_user_stopword_table="test/user_stopword_session";
create temporary TABLE t1(a INT key);
SET STATEMENT sort_buffer_size=150000,binlog_format=row FOR SELECT * FROM t1;
CREATE TEMPORARY TABLE t1 LIKE t2;
SET LOCAL log_slow_verbosity='profiling';
SET SESSION innodb_ft_user_stopword_table=default;
SELECT f1,f2,f3 FROM t1,t2

** GDB info

#0 0x00007ffe775e1771 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000abb47a in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/mysys/stacktrace.c:422
#2 0x00000000007312c3 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000071dcd0 in MDL_ticket::has_stronger_or_equal_type (this=0x7ffe56c6b040, type=MDL_SHARED_READ) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mdl.cc:1976
#5 0x000000000071de4e in MDL_context::find_ticket (this=0x7ffe65771138, mdl_request=0x7ffe56c1fda8, result_duration=0x7ffe77b97114) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mdl.cc:2025
#6 0x000000000071e01d in MDL_context::try_acquire_lock_impl (this=0x7ffe65771138, mdl_request=0x7ffe56c1fda8, out_ticket=0x7ffe77b97188) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mdl.cc:2124
#7 0x000000000071e659 in MDL_context::acquire_lock (this=0x7ffe65771138, mdl_request=0x7ffe56c1fda8, lock_wait_timeout=31536000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/mdl.cc:2325
#8 0x00000000007715b2 in open_table_get_mdl_lock (thd=0x7ffe65771000, ot_ctx=0x7ffe77b97a50, mdl_request=0x7ffe56c1fda8, flags=0, mdl_ticket=0x7ffe77b97888) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:2611
#9 0x0000000000771eb8 in open_table (thd=0x7ffe65771000, table_list=0x7ffe56c1fa08, ot_ctx=0x7ffe77b97a50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:2905
#10 0x00000000007750c0 in open_and_process_table (thd=0x7ffe65771000, lex=0x7ffe65773548, tables=0x7ffe56c1fa08, counter=0x7ffe65773608, flags=0, prelocking_strategy=0x7ffe77b97b50, has_prelocking_list=false, ot_ctx=0x7ffe77b97a50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:4719
#11 0x0000000000775f54 in open_tables (thd=0x7ffe65771000, start=0x7ffe77b97b10, counter=0x7ffe65773608, flags=0, prelocking_strategy=0x7ffe77b97b50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:5226
#12 0x000000000077713e in open_normal_and_derived_tables (thd=0x7ffe65771000, tables=0x7ffe56c1f458, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_base.cc:5935
#13 0x00000000007ec1a1 in execute_sqlcom_select (thd=0x7ffe65771000, all_tables=0x7ffe56c1f458) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:5607
#14 0x00000000007e480e in mysql_execute_command (thd=0x7ffe65771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:2989
#15 0x00000000007ef059 in mysql_parse (thd=0x7ffe65771000, rawbuf=0x7ffe56c1f010 "SELECT f1,f2,f3 FROM t1,t2", length=26, parser_state=0x7ffe77b98df0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:6922
#16 0x00000000007e0ecf in dispatch_command (command=COM_QUERY, thd=0x7ffe65771000, packet=0x7ffe5ea91001 "SELECT f1,f2,f3 FROM t1,t2", packet_length=26) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1434
#17 0x00000000007dfded in do_command (thd=0x7ffe65771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_parse.cc:1051
#18 0x00000000007a7d0d in do_handle_one_connection (thd_arg=0x7ffe65771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1532
#19 0x00000000007a7815 in handle_one_connection (arg=0x7ffe65771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/sql/sql_connect.cc:1443
#20 0x0000000000dcc8ac in pfs_spawn_thread (arg=0x7ffe70b41240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.23-72.1/storage/perfschema/pfs.cc:1860
#21 0x00007ffe775dcdf5 in start_thread (arg=0x7ffe77b9a700) at pthread_create.c:308
#22 0x00007ffe762a61ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113