[MDEV-16036] Debug assertion failed in resignal on create temporary table Created: 2018-04-26  Updated: 2018-12-20  Resolved: 2018-12-20

Status: Closed
Project: MariaDB Server
Component/s: Stored routines
Affects Version/s: 10.3.6
Fix Version/s: 10.3.12

Type: Bug Priority: Major
Reporter: Jérôme Brauge Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None
Environment:

Centos 7 / Mariadb 10.3.6
Windows 10 / Mariadb 10.3.7


Attachments: File bad_exit_handler.sql    

 Description   

Attached script throw debug assertion failed in RESIGNAL when "create temporay table" generate note 1050 "Table 'wrk_rchtra' already exists."
The exception handler is executed which is not normal on a note.



 Comments   
Comment by Elena Stepanova [ 2018-04-26 ]

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

Comment by Oleksandr Byelkin [ 2018-12-20 ]

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.

Generated at Thu Feb 08 08:25:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.