handle_fatal_signal (sig=11) in setup_tables

[Roel Van de Paar]

DROP DATABASE test;CREATE DATABASE test;USE test;
SET STATEMENT myisam_repair_threads=(select max(v1)FROM t1) FOR select 1;

Leads to

+bt
#0 0x00007fe6f25c6771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab976a in my_write_core (sig=11) at /git/percona-server_dbg/mysys/stacktrace.c:422
#2 0x00000000007301b3 in handle_fatal_signal (sig=11) at /git/percona-server_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000077c377 in setup_tables (thd=0x7fe65dfed000, context=0x7fe65341f188, from_clause=0x7fe65341f2b8, tables=0x7fe65341fd48, leaves=0x7fe6f2bbc810, select_insert=false) at /git/percona-server_dbg/sql/sql_base.cc:8597
#5 0x000000000077c622 in setup_tables_and_check_access (thd=0x7fe65dfed000, context=0x7fe65341f188, from_clause=0x7fe65341f2b8, tables=0x7fe65341fd48, leaves=0x7fe65341f2f8, select_insert=false, want_access_first=1, want_access=1) at /git/percona-server_dbg/sql/sql_base.cc:8676
#6 0x000000000080cf34 in JOIN::prepare (this=0x7fe653420520, tables_init=0x7fe65341fd48, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x7fe65341f138, unit_arg=0x7fe65341f448) at /git/percona-server_dbg/sql/sql_resolver.cc:128
#7 0x0000000000952a3a in subselect_single_select_engine::prepare (this=0x7fe6534203e0) at /git/percona-server_dbg/sql/item_subselect.cc:2640
#8 0x000000000094b7c0 in Item_subselect::fix_fields (this=0x7fe6534202c0, thd=0x7fe65dfed000, ref=0x7fe653420428) at /git/percona-server_dbg/sql/item_subselect.cc:381
#9 0x000000000072eb00 in set_var::check (this=0x7fe653420418, thd=0x7fe65dfed000) at /git/percona-server_dbg/sql/set_var.cc:625
#10 0x000000000072e858 in sql_set_variables (thd=0x7fe65dfed000, var_list=0x7fe65dff0208) at /git/percona-server_dbg/sql/set_var.cc:572
#11 0x00000000007e348c in mysql_execute_command (thd=0x7fe65dfed000) at /git/percona-server_dbg/sql/sql_parse.cc:2922
#12 0x00000000007edf05 in mysql_parse (thd=0x7fe65dfed000, rawbuf=0x7fe65341f010 "SET STATEMENT myisam_repair_threads=(select max(v1)FROM t1) FOR select 1", length=72, parser_state=0x7fe6f2bbddf0) at /git/percona-server_dbg/sql/sql_parse.cc:6922
#13 0x00000000007dfd7b in dispatch_command (command=COM_QUERY, thd=0x7fe65dfed000, packet=0x7fe651e32001 "SET STATEMENT myisam_repair_threads=(select max(v1)FROM t1) FOR select 1", packet_length=72) at /git/percona-server_dbg/sql/sql_parse.cc:1434
#14 0x00000000007dec99 in do_command (thd=0x7fe65dfed000) at /git/percona-server_dbg/sql/sql_parse.cc:1051
#15 0x00000000007a6c21 in do_handle_one_connection (thd_arg=0x7fe65dfed000) at /git/percona-server_dbg/sql/sql_connect.cc:1532
#16 0x00000000007a6729 in handle_one_connection (arg=0x7fe65dfed000) at /git/percona-server_dbg/sql/sql_connect.cc:1443
#17 0x0000000000b0a510 in pfs_spawn_thread (arg=0x7fe6ebb51740) at /git/percona-server_dbg/storage/perfschema/pfs.cc:1860
#18 0x00007fe6f25c1df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007fe6f128b1ad in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

Issue not reproducible on MS 5.6.22

[Roel Van de Paar (roel11)]

Happens in PS-03.02-16-percona-server-5.7.10-1rc1-linux-x86_64-debug also

[Shahriyar Rzayev (rzayev-sehriyar)]

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