handle_fatal_signal (sig=11) in realloc | internal/arena.h:532

[Ramesh Sivaraman]

** GDB info

#0 0x00007f119dab7771 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 realloc (ptr=ptr@entry=0x8, size=size@entry=128) at include/jemalloc/internal/arena.h:532
#4 0x00000000008e9304 in my_realloc (oldpoint=0x8, size=128, my_flags=88) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/my_malloc.c:99
#5 0x000000000070320d in intern_sys_var_ptr (thd=0x7f118b339000, offset=67, global_lock=<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:2745
#6 0x00000000009058d3 in innobase_trx_init (trx=0x7f113d8df468, thd=0x7f118b339000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:2314
#7 check_trx_exists (thd=0x7f118b339000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:2375
#8 ha_innobase::extra (this=0x7f113d849510, operation=HA_EXTRA_ADD_CHILDREN_LIST) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:12667
#9 0x00000000006b360c in open_and_process_table (ot_ctx=0x7f119e06bae0, has_prelocking_list=false, prelocking_strategy=0x7f119e06bd20, flags=0, counter=0x7f118b33b5d8, tables=0x7f113d81f340, lex=0x7f118b33b518, thd=0x7f118b339000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:4822
#10 open_tables (thd=thd@entry=0x7f118b339000, start=start@entry=0x7f119e06bd18, counter=0x7f118b33b5d8, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f119e06bd20) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:5233
#11 0x00000000006b4041 in open_normal_and_derived_tables (thd=thd@entry=0x7f118b339000, tables=0x7f113d81f340, flags=flags@entry=0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_base.cc:5933
#12 0x000000000057e84e in execute_sqlcom_select (thd=thd@entry=0x7f118b339000, all_tables=<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:5604
#13 0x00000000006f86a4 in mysql_execute_command (thd=thd@entry=0x7f118b339000) 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:2989
#14 0x00000000006fd2d8 in mysql_parse (thd=thd@entry=0x7f118b339000, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f119e06d270) 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:6919
#15 0x00000000006fea49 in dispatch_command (command=<optimized out>, thd=0x7f118b339000, packet=0x7f118567b001 "select options,flags from t0", 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
#16 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
#17 0x00000000006cc392 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f118b339000) 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
#18 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7f118b339000) 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
#19 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7f119733f060) 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
#20 0x00007f119dab2df3 in start_thread () from /lib64/libpthread.so.0
#21 0x00007f119c77c1ad in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

PFA testcase info. To reproduce this bug please change 1422851420_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)]

Please always paste the relevant startup options and SQL to the bug itself too

DROP DATABASE test;CREATE DATABASE test;USE test;
create TABLE t0(s char)ENGINE=INNODB;
CALL p0((SELECT COUNT(*)FROM t0));
set GLOBAL cache_check_time=0;
SET SESSION TRANSACTION READ ONLY,ISOLATION LEVEL REPEATABLE READ;
SELECT t0.a,t0.b,t0.a,t0.b FROM t0 JOIN t0 ON t0.b=t0.b;
SET STATEMENT sort_buffer_size=0,myisam_repair_threads=0 FOR OPTIMIZE TABLE t0;
select options,flags from t0;

[Ramesh Sivaraman (rameshvs02)]

Forgot to attach SQL info. Please find the startup options.

--plugin-load=audit_log=audit_log.so --audit_log_strategy=PERFORMANCE --audit_log_flush=ON --audit_log_buffer_size=1G --audit_log_format=NEW --audit_log_rotate_on_size=20 --audit_log_rotations=10 --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --log-error=/dev/shm/1422851420/error.log.out --event-scheduler=ON