[MDEV-23793]  Assertion `m_thd == __null' failed in sp_head::~sp_head() Created: 2020-09-22  Updated: 2022-01-27  Resolved: 2022-01-27

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.4, 10.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Oleksandr Byelkin
Resolution: Duplicate Votes: 0
Labels: regression

Issue Links:
Duplicate
duplicates MDEV-21173 Assertion `m_thd == __null' failed in... Closed

 Description   

create procedure sp() select 1 procedure analyse((select 1),100);

10.5 ccbe6bb6fc3cbe31e744

mariadbd: /10.5/sql/sp_head.cc:878: virtual sp_head::~sp_head(): Assertion `m_thd == __null' failed.
200922 16:33:40 [ERROR] mysqld got signal 6 ;
 
Server version: 10.5.6-MariaDB-debug-log
 
linux/raise.c:51(__GI_raise)[0x7fa7652947bb]
stdlib/abort.c:81(__GI_abort)[0x7fa76527f535]
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fa76527f40f]
??:0(__assert_fail)[0x7fa76528d102]
sql/sp_head.cc:880(sp_head::~sp_head())[0x55931e304b1c]
sql/sp_head.cc:521(sp_head::destroy(sp_head*))[0x55931e302fa4]
sql/sql_lex.cc:1355(lex_end_stage1(LEX*))[0x55931e3c5e85]
sql/sql_lex.cc:1326(lex_end(LEX*))[0x55931e3c5d11]
sql/sql_class.cc:3850(THD::end_statement())[0x55931e38c482]
sql/sql_parse.cc:8017(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55931e40f894]
sql/sql_parse.cc:1870(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55931e3fbb1b]
sql/sql_parse.cc:1348(do_command(THD*))[0x55931e3fa251]
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55931e59f665]
sql/sql_connect.cc:1314(handle_one_connection)[0x55931e59f3ce]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55931eadb8cd]
nptl/pthread_create.c:487(start_thread)[0x7fa765d4dfa3]
x86_64/clone.S:97(clone)[0x7fa7653564cf]
 
Query (0x7fa744014040): create procedure sp() select 1 procedure analyse((select 1),100)

non-debug returns error "PROCEDURE does not support subqueries or stored functions"



 Comments   
Comment by Elena Stepanova [ 2020-09-22 ]

Looks much like MDEV-21173

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