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;
© 2024, Oracle Corporation and/or its affiliates
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;