Bug #88281 handle_fatal_signal (sig=11) in ha_myisammrg::detach_children
Submitted: 28 Oct 2017 5:31 Modified: 28 Oct 2017 17:04
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:8.0.3 RC/5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug

[28 Oct 2017 5:31] Roel Van de Paar
Description:
2017-10-28T05:01:18.285635Z 0 [Note] /sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.3-rc-debug-log'  socket: '/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/socket.sock'  port: 16654  MySQL Community Server (GPL)
2017-10-28T05:01:18.289686Z 4 [Note] Event Scheduler: scheduler thread started with id 4
05:02:16 UTC - mysqld got signal 11 ;

Core was generated by `/sda/MS201017-mysql-8.0.3-rc-linux-x86_64-debug/bin/mysqld --no-defaults --sql_'.
Program terminated with signal 11, Segmentation fault.
#0  0x00007f72abc139b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61	  val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0  0x00007f72abc139b1 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x000000000369e428 in my_write_core (sig=11) at /git/mysql-server_dbg/mysys/stacktrace.cc:291
#2  0x000000000286b8f6 in handle_fatal_signal (sig=11) at /git/mysql-server_dbg/sql/signal_handler.cc:234
#3  <signal handler called>
#4  0x0000000003c64bf5 in ha_myisammrg::detach_children (this=0x7f72651c1030)
    at /git/mysql-server_dbg/storage/myisammrg/ha_myisammrg.cc:978
#5  0x0000000003c65a9f in ha_myisammrg::extra (this=0x7f72651c1030, operation=HA_EXTRA_DETACH_CHILDREN)
    at /git/mysql-server_dbg/storage/myisammrg/ha_myisammrg.cc:1320
#6  0x00000000024195ec in mark_tmp_table_for_reuse (table=0x7f72650e1c20) at /git/mysql-server_dbg/sql/sql_base.cc:1398
#7  0x0000000002419512 in mark_temp_tables_as_free_for_reuse (thd=0x7f7265019000) at /git/mysql-server_dbg/sql/sql_base.cc:1373
#8  0x0000000002419c6c in close_thread_tables (thd=0x7f7265019000) at /git/mysql-server_dbg/sql/sql_base.cc:1693
#9  0x00000000024bea8b in mysql_execute_command (thd=0x7f7265019000, first_level=true)
    at /git/mysql-server_dbg/sql/sql_parse.cc:4788
#10 0x00000000024c042b in mysql_parse (thd=0x7f7265019000, parser_state=0x7f72ac1b92f0)
    at /git/mysql-server_dbg/sql/sql_parse.cc:5414
#11 0x00000000024b68e7 in dispatch_command (thd=0x7f7265019000, com_data=0x7f72ac1b9b80, command=COM_QUERY)
    at /git/mysql-server_dbg/sql/sql_parse.cc:1708
#12 0x00000000024b53f5 in do_command (thd=0x7f7265019000) at /git/mysql-server_dbg/sql/sql_parse.cc:1291
#13 0x000000000285b2d6 in handle_connection (arg=0x7f72982eb3c0)
    at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:328
#14 0x00000000036ec54d in pfs_spawn_thread (arg=0x7f7298392620) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2985
#15 0x00007f72abc0ee25 in start_thread (arg=0x7f72ac1ba700) at pthread_create.c:308
#16 0x00007f72a9fee34d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
# mysqld options required for replay: --sql_mode=
CREATE DATABASE test;
USE test;
SET default_storage_engine="MyIsam";
CREATE TABLE t1(i int,KEY USING BTREE (i)) ENGINE=none;
CREATE TEMPORARY TABLE t2(i INT)ENGINE=MERGE UNION=(t1) INSERT_METHOD=LAST;
SHOW FIELDS FROM t2;
[28 Oct 2017 17:04] MySQL Verification Team
Thank you for the bug report. Verified as described.