Elena Stepanova added a comment - 2018-04-26 12:58 Thanks for the report and test case. 10.3 9f84451d8 mysqld: /data/src/10.3/sql/sql_signal.cc:355: bool Sql_cmd_common_signal::raise_condition(THD*, Sql_condition*): Assertion `(cond->m_level == Sql_condition::WARN_LEVEL_WARN) || (cond->m_level == Sql_condition::WARN_LEVEL_ERROR)' failed. 180426 15:58:09 [ERROR] mysqld got signal 6 ;   #7 0x00007fd62b77cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055561a1b6977 in Sql_cmd_common_signal::raise_condition (this=0x7fd6140784a8, thd=0x7fd614000b00, cond=0x7fd625920360) at /data/src/10.3/sql/sql_signal.cc:354 #9 0x000055561a1b6df4 in Sql_cmd_resignal::execute (this=0x7fd6140784a8, thd=0x7fd614000b00) at /data/src/10.3/sql/sql_signal.cc:457 #10 0x000055561a05c7db in mysql_execute_command (thd=0x7fd614000b00) at /data/src/10.3/sql/sql_parse.cc:6282 #11 0x0000555619f83fc8 in sp_instr_stmt::exec_core (this=0x7fd614078518, thd=0x7fd614000b00, nextp=0x7fd6259216fc) at /data/src/10.3/sql/sp_head.cc:3595 #12 0x0000555619f833d8 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fd614078568, thd=0x7fd614000b00, nextp=0x7fd6259216fc, open_tables=false, instr=0x7fd614078518) at /data/src/10.3/sql/sp_head.cc:3311 #13 0x0000555619f83b81 in sp_instr_stmt::execute (this=0x7fd614078518, thd=0x7fd614000b00, nextp=0x7fd6259216fc) at /data/src/10.3/sql/sp_head.cc:3498 #14 0x0000555619f7d945 in sp_head::execute (this=0x7fd61400c378, thd=0x7fd614000b00, merge_da_on_success=true) at /data/src/10.3/sql/sp_head.cc:1349 #15 0x0000555619f802ea in sp_head::execute_procedure (this=0x7fd61400c378, thd=0x7fd614000b00, args=0x7fd6140056e0) at /data/src/10.3/sql/sp_head.cc:2287 #16 0x000055561a0519bf in do_execute_sp (thd=0x7fd614000b00, sp=0x7fd61400c378) at /data/src/10.3/sql/sql_parse.cc:2944 #17 0x000055561a05253c in Sql_cmd_call::execute (this=0x7fd614014e18, thd=0x7fd614000b00) at /data/src/10.3/sql/sql_parse.cc:3186 #18 0x000055561a05c7db in mysql_execute_command (thd=0x7fd614000b00) at /data/src/10.3/sql/sql_parse.cc:6282 #19 0x000055561a0612a8 in mysql_parse (thd=0x7fd614000b00, rawbuf=0x7fd614014d58 "call p4()", length=9, parser_state=0x7fd6259235d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001 #20 0x000055561a04ea8b in dispatch_command (command=COM_QUERY, thd=0x7fd614000b00, packet=0x7fd61408ff81 "", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846 #21 0x000055561a04d4ca in do_command (thd=0x7fd614000b00) at /data/src/10.3/sql/sql_parse.cc:1391 #22 0x000055561a1affbd in do_handle_one_connection (connect=0x55561cc36e30) at /data/src/10.3/sql/sql_connect.cc:1402 #23 0x000055561a1afd4a in handle_one_connection (arg=0x55561cc36e30) at /data/src/10.3/sql/sql_connect.cc:1308 #24 0x000055561a6339bb in pfs_spawn_thread (arg=0x55561cc4a6d0) at /data/src/10.3/storage/perfschema/pfs.cc:1862 #25 0x00007fd62d453494 in start_thread (arg=0x7fd625924700) at pthread_create.c:333 #26 0x00007fd62b83993f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Oleksandr Byelkin added a comment - 2018-12-20 10:23 evision-id: 5b02c215cd600ce762892526e2f5604511308fb3 (mariadb-10.3.10-120-g5b02c215cd6) parent(s): b26736cdb1105f5c500c0a6b51954ac4a83665b0 author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2018-12-20 11:22:13 +0100 message: MDEV-16036 : Debug assertion failed in resignal on create temporary table Reising condition on NOTW controlled by OPTION_SQL_NOTES. —