handle_fatal_signal (sig=11) in find_sys_var | sql/sql_plugin.cc:2556

[Ramesh Sivaraman]

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
SET lc_messages=cs_CZ;
SET @@session.tx_read_only=TRUE;
SET DEBUG_SYNC='now SIGNAL altered';
explain extended select * FROM t0 as t0 left join t0 as t0 on t0.d0=t0.a0 left join t0 as t0 on t0.a0=t0.d0;
SET STATEMENT myisam_sort_buffer_size=0,myisam_repair_threads=0,sort_buffer_size=0,binlog_format=row,keep_files_on_create=OFF,max_join_size=0 FOR DROP FUNCTION myProc;
SET GLOBAL innodb_priority_master=0;

**GDB info

#0 0x00007fa27b960771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006772cd in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 0x00000000005b6dca in get_server_errmsgs () at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/derror.cc:40
#4 0x00000000008e703d in my_get_err_msg (nr=nr@entry=1193) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/my_error.c:149
#5 0x00000000008e70d4 in my_error (nr=1193, MyFlags=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/my_error.c:176
#6 0x0000000000705ac4 in find_sys_var (thd=thd@entry=0x7fa269b3f000, str=0x7fa24481f0d0 "innodb_priority_master", length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_plugin.cc:2556
#7 0x00000000005812fe in find_sys_var_null_base (thd=thd@entry=0x7fa269b3f000, tmp=tmp@entry=0x7fa27bf0f3f0) at /var/lib/jenkins/jobs/percona-server-5.6-source-tarballs/workspace/sql/sql_yacc.yy:354
#8 0x00000000007a718a in MYSQLparse (YYTHD=YYTHD@entry=0x7fa269b3f000) at /var/lib/jenkins/jobs/percona-server-5.6-source-tarballs/workspace/sql/sql_yacc.yy:15085
#9 0x00000000006fcb2c in parse_sql (thd=thd@entry=0x7fa269b3f000, parser_state=parser_state@entry=0x7fa27bf10270, creation_ctx=creation_ctx@entry=0x0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:8932
#10 0x00000000006fcf51 in mysql_parse (thd=thd@entry=0x7fa269b3f000, rawbuf=<optimized out>, length=35, parser_state=parser_state@entry=0x7fa27bf10270) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6822
#11 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7fa269b3f000, packet=0x7fa2633b3001 "SET GLOBAL innodb_priority_master=0", packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#12 0x00000000007007a9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#13 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fa269b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#14 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7fa269b3f000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#15 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7fa274f3f6a0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#16 0x00007fa27b95bdf3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007fa27a6251ad in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

PFA testcase info. To reproduce this bug please change 1422449381_mybase to PS base path, then init > start > cl (to verify it's up) > run. But testcase above should work fine.

[Laurynas Biveinis (laurynas-biveinis)]

SET lc_messages=cs_CZ;
SET @@session.tx_read_only=TRUE;
SET DEBUG_SYNC='now SIGNAL altered';
main.foo31 [ fail ]
        Test ended at 2015-01-30 10:39:02

CURRENT_TEST: main.foo31
mysqltest: At line 4: query 'explain extended select * FROM t0 as t0 left join t0 as t0 on t0.d0=t0.a0 left join t0 as t0 on t0.a0=t0.d0' failed: 1066: Nejednozna\010Dn? tabulka/alias: 't0'

The bug bundle has references to specific user names and libjemalloc hardcoded paths. I am not willing to spend time to debug it right now.

[Roel Van de Paar (roel11)]

- Does not reproduce on PS-03.02-16-percona-server-5.7.10-1rc1-linux-x86_64-debug
- Does not reproduce on PS-03.02.16-percona-server-5.6.28-76.1-linux-x86_64-debug

[Shahriyar Rzayev (rzayev-sehriyar)]

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