handle_fatal_signal (sig=11) in plugin_var_memalloc_free | sql/sql_plugin.cc:3098

[Ramesh Sivaraman]

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
UPDATE performance_schema.setup_instruments SET ENABLED=0;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ ONLY;
select straight_join * FROM t0 join t0 as t0 on t0.a=t0.a IN t0 as t0 on t0.a=t0.c and t0.b=t0.c;
SET STATEMENT myisam_sort_buffer_size=0,myisam_repair_threads=0 FOR OPTIMIZE TABLE t0;

** GDB info

#0 0x00007fc1d4206771 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 free (ptr=0x1366240 <my_charset_utf8_bin>) at include/jemalloc/internal/arena.h:532
#4 0x000000000070665c in plugin_var_memalloc_free (vars=0x7fc1c233f688) 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:3098
#5 cleanup_variables (vars=0x7fc1c233f688, thd=0x7fc1c233f000) 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:2909
#6 plugin_thdvar_cleanup (thd=thd@entry=0x7fc1c233f000) 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:2930
#7 0x00000000006cbae9 in end_connection (thd=0x7fc1c233f000) 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:1319
#8 0x00000000006cc3b2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fc1c233f000) 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:1535
#9 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7fc1c233f000) 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
#10 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7fc1cd73f6a0) 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
#11 0x00007fc1d4201df3 in start_thread () from /lib64/libpthread.so.0
#12 0x00007fc1d2ecb1ad in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

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