handle_fatal_signal (sig=11) in THD::set_new_thread_id

[Roel Van de Paar]

Core was generated by `/sda/PS071116-percona-server-5.7.16-9-linux-x86_64-debug/bin/mysqld --no-defaul'.
Program terminated with signal 11, Segmentation fault.
#0 0x00007fb7b5943741 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 0x00007fb7b5943741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00000000018466f4 in my_write_core (sig=11) at /git/PS-5.7.16_dbg/mysys/stacktrace.c:247
#2 0x0000000000e7d38b in handle_fatal_signal (sig=11) at /git/PS-5.7.16_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00000000014b26fd in THD::set_new_thread_id (this=0x0) at /git/PS-5.7.16_dbg/sql/sql_class.cc:1800
#5 0x00000000016358ac in Thread_pool_connection_handler::add_connection (this=0x7fb7af3fe060, channel_info=0x7fb787fb1a00) at /git/PS-5.7.16_dbg/sql/threadpool_unix.cc:1333
#6 0x0000000000ec4542 in Connection_handler_manager::process_new_connection (this=0x7fb7af3f3400, channel_info=0x7fb787fb1a00)
    at /git/PS-5.7.16_dbg/sql/conn_handler/connection_handler_manager.cc:301
#7 0x0000000000e7682a in Connection_acceptor<Mysqld_socket_listener>::connection_event_loop (this=0x7fb7af3fe298) at /git/PS-5.7.16_dbg/sql/conn_handler/connection_acceptor.h:68
#8 0x0000000000e6e33c in mysqld_main (argc=48, argv=0x7fb7b1c30108) at /git/PS-5.7.16_dbg/sql/mysqld.cc:5306
#9 0x0000000000e64d50 in main (argc=48, argv=0x7fff5ddf2c68) at /git/PS-5.7.16_dbg/sql/main.cc:25

[Roel Van de Paar (roel11)]

Very low frequency bug, but interesting. Also seems sporadic. Uploading core/mysqld/ldd/data

[Roel Van de Paar (roel11)]

gdb ./mysqld/mysqld ./data/core.30230.1000.1000.11.1478573526.mysqld

[Laurynas Biveinis (laurynas-biveinis)]

Missed error handling in case of OOM (real, or in QA likely simulated by "SET GLOBAL debug= '+d,simulate_resource_failure';")

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/1166

[Shahriyar Rzayev (rzayev-sehriyar)]

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