Assertion `(mem_root->flags & 4) == 0' failed in sp_add_used_routine / Table_triggers_list::add_tables_and_routines_for_triggers

CREATE TABLE t (a INT);

INSERT INTO t VALUES (1),(2); # Optional, fails either way

CREATE TRIGGER tr BEFORE DELETE ON t FOR EACH ROW BEGIN END;

CREATE PROCEDURE pr() DELETE FROM t;

--delimiter $

CREATE FUNCTION f() RETURNS INT BEGIN CALL pr; RETURN 0; END $

--delimiter ;

SELECT f();

CALL pr;

# Cleanup

DROP FUNCTION f;

DROP PROCEDURE pr;

DROP TABLE t;

mariadbd: /data/bld/10.5-asan/mysys/my_alloc.c:212: alloc_root: Assertion `(mem_root->flags & 4) == 0' failed.

241107 21:28:41 [ERROR] mysqld got signal 6 ;

#9  0x00007fa5ccc53e32 in __GI___assert_fail (assertion=0x5555666bce80 "(mem_root->flags & 4) == 0", file=0x5555666bcb80 "/data/bld/10.5-asan/mysys/my_alloc.c", line=212, function=0x5555666bd1a0 <__PRETTY_FUNCTION__.0> "alloc_root") at ./assert/assert.c:101

#10 0x00005555652edabf in alloc_root (mem_root=0x62500010e178, length=480) at /data/bld/10.5-asan/mysys/my_alloc.c:212

#11 0x00005555631a84f6 in Query_arena::alloc (this=0x62500010f560, size=480) at /data/bld/10.5-asan/sql/sql_class.h:1214

#12 0x0000555564191264 in sp_add_used_routine (prelocking_ctx=0x625000110940, arena=0x62500010f560, key=0x7fa5c34ad6f0, handler=0x55556723d660 <sp_handler_trigger>, belong_to_view=0x0) at /data/bld/10.5-asan/sql/sp.cc:2338

#13 0x00005555637a103f in Table_triggers_list::add_tables_and_routines_for_triggers (this=0x61900009ecb8, thd=0x62b000069218, prelocking_ctx=0x625000110940, table_list=0x62500010ee58) at /data/bld/10.5-asan/sql/sql_trigger.cc:2349

#14 0x0000555563321519 in DML_prelocking_strategy::handle_table (this=0x7fa5c34adfc0, thd=0x62b000069218, prelocking_ctx=0x625000110940, table_list=0x62500010ee58, need_prelocking=0x7fa5c34ada90) at /data/bld/10.5-asan/sql/sql_base.cc:4739

#15 0x000055556331b0f1 in extend_table_list (thd=0x62b000069218, tables=0x62500010ee58, prelocking_strategy=0x7fa5c34adfc0, has_prelocking_list=false) at /data/bld/10.5-asan/sql/sql_base.cc:3581

#16 0x000055556331c9ea in open_and_process_table (thd=0x62b000069218, tables=0x62500010ee58, counter=0x7fa5c34adeb0, flags=0, prelocking_strategy=0x7fa5c34adfc0, has_prelocking_list=false, ot_ctx=0x7fa5c34adda0) at /data/bld/10.5-asan/sql/sql_base.cc:3879

#17 0x000055556331f11a in open_tables (thd=0x62b000069218, options=..., start=0x7fa5c34adec0, counter=0x7fa5c34adeb0, flags=0, prelocking_strategy=0x7fa5c34adfc0) at /data/bld/10.5-asan/sql/sql_base.cc:4303

#18 0x000055556332424f in open_and_lock_tables (thd=0x62b000069218, options=..., tables=0x62500010ee58, derived=true, flags=0, prelocking_strategy=0x7fa5c34adfc0) at /data/bld/10.5-asan/sql/sql_base.cc:5250

#19 0x0000555563279c5c in open_and_lock_tables (thd=0x62b000069218, tables=0x62500010ee58, derived=true, flags=0) at /data/bld/10.5-asan/sql/sql_base.h:509

#20 0x00005555641c8eec in mysql_delete (thd=0x62b000069218, table_list=0x62500010ee58, conds=0x0, order_list=0x6250001114f0, limit=18446744073709551615, options=0, result=0x0) at /data/bld/10.5-asan/sql/sql_delete.cc:343

#21 0x00005555634c0021 in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4937

#22 0x0000555563261b4e in sp_instr_stmt::exec_core (this=0x62500010f560, thd=0x62b000069218, nextp=0x7fa5c34afa50) at /data/bld/10.5-asan/sql/sp_head.cc:3842

#23 0x000055556326011b in sp_lex_keeper::reset_lex_and_exec_core (this=0x62500010f5a8, thd=0x62b000069218, nextp=0x7fa5c34afa50, open_tables=false, instr=0x62500010f560) at /data/bld/10.5-asan/sql/sp_head.cc:3564

#24 0x00005555632612d6 in sp_instr_stmt::execute (this=0x62500010f560, thd=0x62b000069218, nextp=0x7fa5c34afa50) at /data/bld/10.5-asan/sql/sp_head.cc:3745

#25 0x0000555563251e40 in sp_head::execute (this=0x62500010e138, thd=0x62b000069218, merge_da_on_success=true) at /data/bld/10.5-asan/sql/sp_head.cc:1442

#26 0x000055556325870a in sp_head::execute_procedure (this=0x62500010e138, thd=0x62b000069218, args=0x62b00006e330) at /data/bld/10.5-asan/sql/sp_head.cc:2483

#27 0x00005555634b2918 in do_execute_sp (thd=0x62b000069218, sp=0x62500010e138) at /data/bld/10.5-asan/sql/sql_parse.cc:3110

#28 0x00005555634b4472 in Sql_cmd_call::execute (this=0x62b000038300, thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:3356

#29 0x00005555634c8c6e in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:6179

#30 0x00005555634d603b in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "CALL pr", length=7, parser_state=0x7fa5c34b1c70, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8237

#31 0x00005555634ab321 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "CALL pr", packet_length=7, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1891

#32 0x00005555634a7cb4 in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1375

#33 0x0000555563901869 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1407

#34 0x00005555639013cf in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319

#35 0x000055556455f1f0 in pfs_spawn_thread (arg=0x615000006c18) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201

#36 0x00007fa5ccca8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#37 0x00007fa5ccd2861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81