Description:
(gdb) bt
#0 0x00007f6ee2953a01 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000055fde6a9473b in my_write_core (sig=<optimized out>) at ../../include/my_thread.h:88
#2 0x000055fde5597b09 in handle_fatal_signal (sig=11) at ../../sql/signal_handler.cc:171
#3 <signal handler called>
#4 0x000055fde58c7ee9 in sp_prepare_func_item(THD*, Item**) [clone .localalias] () at ../../sql/sp.cc:2398
#5 0x000055fde58c81a8 in sp_eval_expr (thd=thd@entry=0x7f6ecfdd8800, result_field=0x7f6e67482798, expr_item_ptr=<optimized out>) at ../../sql/sp.cc:2442
#6 0x000055fde53cded6 in sp_rcontext::set_variable (this=this@entry=0x7f6e67481598, thd=thd@entry=0x7f6ecfdd8800, field=<optimized out>, value=<optimized out>)
at ../../sql/sp_rcontext.cc:409
#7 0x000055fde53c3ecf in set_variable (value=<optimized out>, var_idx=1, thd=0x7f6ecfdd8800, this=0x7f6e67481598) at ../../sql/sp_rcontext.h:172
#8 sp_head::execute_procedure (this=this@entry=0x7f6e674c0830, thd=thd@entry=0x7f6ecfdd8800, args=0x7f6e674bfa10) at ../../sql/sp_head.cc:2805
#9 0x000055fde58f75d1 in Sql_cmd_call::execute_inner (this=0x7f6e674bfea8, thd=0x7f6ecfdd8800) at ../../sql/sql_call.cc:236
#10 0x000055fde51a383d in Sql_cmd_dml::execute(THD*) [clone .localalias] () at ../../sql/sql_select.cc:585
#11 0x000055fde5190c37 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:4657
#12 0x000055fde5488389 in Prepared_statement::execute(String*, bool) [clone .localalias] () at ../../sql/sql_prepare.cc:3512
#13 0x000055fde5487c4e in Prepared_statement::execute_loop (this=0x7f6e67430000, expanded_query=0x7f6e755537f0, open_cursor=<optimized out>) at ../../sql/sql_prepare.cc:3019
#14 0x000055fde548742a in mysql_sql_stmt_execute(THD*) () at ../../sql/sql_prepare.cc:1971
#15 0x000055fde5192114 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:3276
#16 0x000055fde5197b08 in dispatch_sql_command (thd=0x7f6ecfdd8800, parser_state=<optimized out>) at ../../sql/sql_parse.cc:5254
#17 0x000055fde5198df7 in dispatch_command(THD*, COM_DATA const*, enum_server_command) [clone .localalias] () at ../../sql/sql_parse.cc:1896
#18 0x000055fde51986b7 in do_command (thd=thd@entry=0x7f6ecfdd8800) at ../../sql/sql_parse.cc:1334
#19 0x000055fde5305698 in threadpool_process_request(THD*) () at ../../../plugin/threadpool/threadpool_common.cc:241
#20 0x000055fde5306459 in handle_event (connection=0x7f6ecfdeada8) at ../../../plugin/threadpool/threadpool_unix.cc:1571
#21 worker_main (param=param@entry=0x55fde9929600 <all_groups+29696>) at ../../../plugin/threadpool/threadpool_unix.cc:1617
#22 0x000055fde6faf2f0 in pfs_spawn_thread (arg=0x7f6e81e05b28) at ../../../storage/perfschema/pfs.cc:2899
#23 0x00007f6ee294ee25 in start_thread () from /lib64/libpthread.so.0
#24 0x00007f6ee1757bad in clone () from /lib64/libc.so.6
(gdb) f 15
#15 0x000055fde5192114 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:3276
3276 ../../sql/sql_parse.cc: No such file or directory.
(gdb) p thd->m_query_string
$1 = {str = 0x7f6e6746cb18 "CALL p4(@c)", length = 11}
How to repeat:
During the pressure test, we create procedures with the same name but different repeatedly.It's not clear how to reproduce it with certainty.
Description: (gdb) bt #0 0x00007f6ee2953a01 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000055fde6a9473b in my_write_core (sig=<optimized out>) at ../../include/my_thread.h:88 #2 0x000055fde5597b09 in handle_fatal_signal (sig=11) at ../../sql/signal_handler.cc:171 #3 <signal handler called> #4 0x000055fde58c7ee9 in sp_prepare_func_item(THD*, Item**) [clone .localalias] () at ../../sql/sp.cc:2398 #5 0x000055fde58c81a8 in sp_eval_expr (thd=thd@entry=0x7f6ecfdd8800, result_field=0x7f6e67482798, expr_item_ptr=<optimized out>) at ../../sql/sp.cc:2442 #6 0x000055fde53cded6 in sp_rcontext::set_variable (this=this@entry=0x7f6e67481598, thd=thd@entry=0x7f6ecfdd8800, field=<optimized out>, value=<optimized out>) at ../../sql/sp_rcontext.cc:409 #7 0x000055fde53c3ecf in set_variable (value=<optimized out>, var_idx=1, thd=0x7f6ecfdd8800, this=0x7f6e67481598) at ../../sql/sp_rcontext.h:172 #8 sp_head::execute_procedure (this=this@entry=0x7f6e674c0830, thd=thd@entry=0x7f6ecfdd8800, args=0x7f6e674bfa10) at ../../sql/sp_head.cc:2805 #9 0x000055fde58f75d1 in Sql_cmd_call::execute_inner (this=0x7f6e674bfea8, thd=0x7f6ecfdd8800) at ../../sql/sql_call.cc:236 #10 0x000055fde51a383d in Sql_cmd_dml::execute(THD*) [clone .localalias] () at ../../sql/sql_select.cc:585 #11 0x000055fde5190c37 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:4657 #12 0x000055fde5488389 in Prepared_statement::execute(String*, bool) [clone .localalias] () at ../../sql/sql_prepare.cc:3512 #13 0x000055fde5487c4e in Prepared_statement::execute_loop (this=0x7f6e67430000, expanded_query=0x7f6e755537f0, open_cursor=<optimized out>) at ../../sql/sql_prepare.cc:3019 #14 0x000055fde548742a in mysql_sql_stmt_execute(THD*) () at ../../sql/sql_prepare.cc:1971 #15 0x000055fde5192114 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:3276 #16 0x000055fde5197b08 in dispatch_sql_command (thd=0x7f6ecfdd8800, parser_state=<optimized out>) at ../../sql/sql_parse.cc:5254 #17 0x000055fde5198df7 in dispatch_command(THD*, COM_DATA const*, enum_server_command) [clone .localalias] () at ../../sql/sql_parse.cc:1896 #18 0x000055fde51986b7 in do_command (thd=thd@entry=0x7f6ecfdd8800) at ../../sql/sql_parse.cc:1334 #19 0x000055fde5305698 in threadpool_process_request(THD*) () at ../../../plugin/threadpool/threadpool_common.cc:241 #20 0x000055fde5306459 in handle_event (connection=0x7f6ecfdeada8) at ../../../plugin/threadpool/threadpool_unix.cc:1571 #21 worker_main (param=param@entry=0x55fde9929600 <all_groups+29696>) at ../../../plugin/threadpool/threadpool_unix.cc:1617 #22 0x000055fde6faf2f0 in pfs_spawn_thread (arg=0x7f6e81e05b28) at ../../../storage/perfschema/pfs.cc:2899 #23 0x00007f6ee294ee25 in start_thread () from /lib64/libpthread.so.0 #24 0x00007f6ee1757bad in clone () from /lib64/libc.so.6 (gdb) f 15 #15 0x000055fde5192114 in mysql_execute_command(THD*, bool) [clone .localalias] () at ../../sql/sql_parse.cc:3276 3276 ../../sql/sql_parse.cc: No such file or directory. (gdb) p thd->m_query_string $1 = {str = 0x7f6e6746cb18 "CALL p4(@c)", length = 11} How to repeat: During the pressure test, we create procedures with the same name but different repeatedly.It's not clear how to reproduce it with certainty.