Bug #83116 handle_fatal_signal (sig=11) in sp_get_flags_for_command
Submitted: 23 Sep 2016 4:32 Modified: 23 Sep 2016 8:48
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S1 (Critical)
Version:8.0-dmr OS:Any
Assigned to: CPU Architecture:Any

[23 Sep 2016 4:32] Roel Van de Paar
Description:
+bt
#0  0x00007f2bdcb9c741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x00000000023fc1b9 in my_write_core (sig=11) at /git/MS8.0_dbg/mysys/stacktrace.cc:275
#2  0x0000000001b517ed in handle_fatal_signal (sig=11) at /git/MS8.0_dbg/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x000000000225c65d in sp_get_flags_for_command (lex=0x7f2baa4d6b38) at /git/MS8.0_dbg/sql/sp.cc:2239
#5  0x0000000001b63ae7 in MYSQLparse (YYTHD=0x7f2baa419000) at /git/MS8.0_dbg/sql/sql_yacc.yy:3862
#6  0x00000000018793d1 in parse_sql (thd=0x7f2baa419000, parser_state=0x7f2bdd18f4e0, creation_ctx=0x0) at /git/MS8.0_dbg/sql/sql_parse.cc:6858
#7  0x00000000018757df in mysql_parse (thd=0x7f2baa419000, parser_state=0x7f2bdd18f4e0) at /git/MS8.0_dbg/sql/sql_parse.cc:5126
#8  0x000000000186c3b8 in dispatch_command (thd=0x7f2baa419000, com_data=0x7f2bdd18fc70, command=COM_QUERY) at /git/MS8.0_dbg/sql/sql_parse.cc:1481
#9  0x000000000186b244 in do_command (thd=0x7f2baa419000) at /git/MS8.0_dbg/sql/sql_parse.cc:1043
#10 0x0000000001b43af1 in handle_connection (arg=0x7f2ba9d6c080) at /git/MS8.0_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#11 0x000000000242bf29 in pfs_spawn_thread (arg=0x7f2ba9de4f20) at /git/MS8.0_dbg/storage/perfschema/pfs.cc:2282
#12 0x00007f2bdcb97dc5 in start_thread (arg=0x7f2bdd190700) at pthread_create.c:308
#13 0x00007f2bdaff4ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;
use INFORMATION_SCHEMA;
CREATE PROCEDURE p1()BEGIN CREATE TABLE t1(c1 CHAR (1));
[23 Sep 2016 4:33] Roel Van de Paar
May be related to #83113
[23 Sep 2016 5:02] Roel Van de Paar
May be related to bug #83119
[23 Sep 2016 8:48] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
This is most likely duplicate of Bug #83112

Thanks,
Umesh