Bug #93632 handle_fatal_signal (sig=11) in myrg_status
Submitted: 17 Dec 2018 1:17 Modified: 17 Dec 2018 6:18
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Merge storage engine Severity:S1 (Critical)
Version:8.0.13 OS:Any
Assigned to: CPU Architecture:Any
Tags: release builds

[17 Dec 2018 1:17] Roel Van de Paar
Description:
Core was generated by `/sda/PS141218-percona-server-8.0.13-2-linux-x86_64-opt/bin/mysqld --no-defaults'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
57	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
[Current thread is 1 (Thread 0x7f6e38cc4700 (LWP 3681))]
(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1  0x0000556dc8bb9b17 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
#2  0x0000556dc7ee2805 in handle_fatal_signal (sig=11) at signal_handler.cc:254
#3  <signal handler called>
#4  myrg_status (info=0x7f6db6c97fa0, x=x@entry=0x7f6e38cc1430, flag=flag@entry=26) at myrg_info.cc:56
#5  0x0000556dc910c693 in ha_myisammrg::info (this=0x7f6db6df9028, flag=26) at ha_myisammrg.cc:1131
#6  0x0000556dc910c9ee in ha_myisammrg::open (this=0x7f6db6e17028, 
    name=0x7f6db6cbab58 "/sda/PS141218-percona-server-8.0.13-2-linux-x86_64-opt/data/#sqlce4_9_0", mode=<optimized out>, 
    test_if_locked_arg=<optimized out>, table_def=<optimized out>) at ha_myisammrg.cc:363
#7  0x0000556dc7b66c23 in handler::ha_open (this=this@entry=0x7f6db6e17028, table_arg=<optimized out>, 
    name=name@entry=0x7f6db6cbab58 "/sda/PS141218-percona-server-8.0.13-2-linux-x86_64-opt/data/#sqlce4_9_0", mode=7, 
    test_if_locked=test_if_locked@entry=2, table_def=table_def@entry=0x0) at handler.cc:2838
#8  0x0000556dc910ceb2 in ha_myisammrg::clone (this=0x7f6db6df9028, 
    name=0x7f6db6cbab58 "/sda/PS141218-percona-server-8.0.13-2-linux-x86_64-opt/data/#sqlce4_9_0", mem_root=0x7f6db6c19518)
    at ha_myisammrg.cc:684
#9  0x0000556dc7e1c10d in store_temporary_table_record (thd=thd@entry=0x7f6db6c17000, table=0x7f6db6e11028, db=<optimized out>, 
    mem_root=0x7f6db6c19518, tmp_table=<optimized out>, tmp_table=<optimized out>) at sql_show.cc:3980
#10 0x0000556dc7e1c2df in fill_temporary_tables (thd=0x7f6db6c17000, tables=0x7f6db6dc57e8, cond=<optimized out>)
    at sql_show.cc:4127
#11 0x0000556dc7e1554a in do_fill_table (thd=thd@entry=0x7f6db6c17000, table_list=table_list@entry=0x7f6db6dc57e8, 
    qep_tab=qep_tab@entry=0x7f6db6dc7560) at sql_show.cc:5260
#12 0x0000556dc7e1ed1e in get_schema_tables_result (join=join@entry=0x7f6db6dc6c70, 
    executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:5374
#13 0x0000556dc7e04b8f in JOIN::prepare_result (this=this@entry=0x7f6db6dc6c70) at sql_select.cc:1437
#14 0x0000556dc7d7ebf9 in JOIN::exec (this=0x7f6db6dc6c70) at sql_executor.cc:202
#15 0x0000556dc7e05764 in Sql_cmd_dml::execute_inner (this=0x7f6db6dc5d90, thd=0x7f6db6c17000) at sql_select.cc:698
#16 0x0000556dc7e0d3c0 in Sql_cmd_dml::execute (this=0x7f6db6dc5d90, thd=0x7f6db6c17000) at sql_select.cc:596
#17 0x0000556dc7db9b03 in mysql_execute_command (thd=thd@entry=0x7f6db6c17000, first_level=first_level@entry=true)
    at sql_parse.cc:4518
#18 0x0000556dc7dbce3b in mysql_parse (thd=thd@entry=0x7f6db6c17000, parser_state=parser_state@entry=0x7f6e38cc2d30, 
    update_userstat=update_userstat@entry=false, force_primary_storage_engine=force_primary_storage_engine@entry=false)
    at sql_parse.cc:5259
#19 0x0000556dc7dc01f9 in dispatch_command (thd=thd@entry=0x7f6db6c17000, com_data=com_data@entry=0x7f6e38cc3c60, command=COM_QUERY)
    at sql_parse.cc:1734
#20 0x0000556dc7dc0d69 in do_command (thd=thd@entry=0x7f6db6c17000) at sql_parse.cc:1290
#21 0x0000556dc7ed3ea0 in handle_connection (arg=arg@entry=0x7f6dee2997f0) at conn_handler/connection_handler_per_thread.cc:317
#22 0x0000556dc8c6579f in pfs_spawn_thread (arg=0x7f6e2ebf8c20) at pfs.cc:2836
#23 0x00007f6e3ab146db in start_thread (arg=0x7f6e38cc4700) at pthread_create.c:463
#24 0x00007f6e38de688f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

How to repeat:
CREATE DATABASE test;
USE test;
CREATE TABLE t0(a int)ENGINE=MyISAM;
create temporary TABLE t0(a int)engine=merge union=(t0);
select table_schema,table_name,engine,table_rows from Information_schema.temporary_tables;