handle_fatal_signal (sig=11) in THD::cleanup | sql/sql_class.cc:1691

[Ramesh Sivaraman]

** Startup

 --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/1422938410/error.log.out --event-scheduler=ON

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
create temporary TABLE t1 (a int) engine=innodb;
SET @increment_offset=@@global.auto_increment_offset;
SET @@GLOBAL.userstat=ON;
handler t1 open as a1;
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
select least(1,2,3) | greatest(16,32,8),least(5,4)*1,greatest(-1.0,1.0)*1,least(3,2,1)*1.0,greatest(1,1.1,1.0),least("10",9),greatest("A","B","0");

** GDB info

#0 0x00007f94687b1771 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 ha_index_or_rnd_end (this=0x0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/handler.h:2040
#4 mysql_ha_close_table (tables=0x7f94084c9a00, thd=0x7f9455f39000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_handler.cc:135
#5 mysql_ha_cleanup (thd=0x7f9455f39000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_handler.cc:1009
#6 0x00000000006c8488 in THD::cleanup (this=this@entry=0x7f9455f39000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_class.cc:1691
#7 0x00000000006c8858 in THD::release_resources (this=this@entry=0x7f9455f39000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_class.cc:1771
#8 0x00000000005adb9c in one_thread_per_connection_end (thd=0x7f9455f39000, block_pthread=true) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/mysqld.cc:2833
#9 0x00000000006cc316 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f9455f39000) 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:1546
#10 0x00000000006cc480 in handle_one_connection (arg=arg@entry=0x7f9455f39000) 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
#11 0x0000000000afd6b3 in pfs_spawn_thread (arg=0x7f9461f3f060) 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
#12 0x00007f94687acdf3 in start_thread () from /lib64/libpthread.so.0
#13 0x00007f94674761ad in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

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

[Ramesh Sivaraman (rameshvs02)]

May be this bug is related to : https://bugs.launchpad.net/percona-server/5.6/+bug/1384656

[Ramesh Sivaraman (rameshvs02)]

This is an upstream bug : http://bugs.mysql.com/bug.php?id=75741

[Roel Van de Paar (roel11)]

Whilst 5.6 with the options as listed does not crash anymore, without those options it does.

[Roel Van de Paar (roel11)]

5.5. Crashes also (with/without options) on _Z18mysql_ha_rm_tablesP3THDP10TABLE_LIST (ref bug 1384656 and upstream #74583, #74584 - Fixed in 5.7.6)

[Shahriyar Rzayev (rzayev-sehriyar)]

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