Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.2(EOL), 11.4, 11.5(EOL)
Description
Assertion `mdl_request->ticket == __null' fails upon DML causing auto partition creation via function
--source include/have_partition.inc
|
|
CREATE TABLE t (a INT) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME INTERVAL 1 MINUTE AUTO; |
--delimiter $
|
CREATE FUNCTION f() RETURNS INT BEGIN REPLACE INTO t SELECT * FROM t; RETURN 0; END $ |
--delimiter ;
|
SET timestamp= @@timestamp + 61; |
SELECT f(); |
|
DROP TABLE t; |
DROP FUNCTION f; |
10.11 62bfcfd8b29cb4f2e70dd15155875494ad6a37cf |
mariadbd: /data/bld/10.11-debug/sql/mdl.cc:2063: bool MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**): Assertion `mdl_request->ticket == __null' failed.
|
240819 15:09:18 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007fb185253e32 in __GI___assert_fail (assertion=0x56545a2372e4 "mdl_request->ticket == __null", file=0x56545a236cf8 "/data/bld/10.11-debug/sql/mdl.cc", line=2063, function=0x56545a2372a0 "bool MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**)") at ./assert/assert.c:101
|
#10 0x00005654594c65a3 in MDL_context::try_acquire_lock_impl (this=0x7fb164000f20, mdl_request=0x7fb164015c78, out_ticket=0x7fb1800fd2f8) at /data/bld/10.11-debug/sql/mdl.cc:2063
|
#11 0x00005654594c6ead in MDL_context::acquire_lock (this=0x7fb164000f20, mdl_request=0x7fb164015c78, lock_wait_timeout=86400) at /data/bld/10.11-debug/sql/mdl.cc:2297
|
#12 0x000056545920b916 in sp_acquire_mdl (thd=0x7fb164000dc8, rt=0x7fb164015c78, ot_ctx=0x7fb1800fd590) at /data/bld/10.11-debug/sql/sql_base.cc:3704
|
#13 0x000056545920baff in open_and_process_routine (thd=0x7fb164000dc8, prelocking_ctx=0x7fb1640051a8, rt=0x7fb164015c78, prelocking_strategy=0x7fb1800fd6a8, has_prelocking_list=true, ot_ctx=0x7fb1800fd590, need_prelocking=0x7fb1800fd526, routine_modifies_data=0x7fb1800fd527) at /data/bld/10.11-debug/sql/sql_base.cc:3781
|
#14 0x000056545920dbb9 in open_tables (thd=0x7fb164000dc8, options=..., start=0x7fb1800fd608, counter=0x7fb1800fd624, flags=0, prelocking_strategy=0x7fb1800fd6a8) at /data/bld/10.11-debug/sql/sql_base.cc:4709
|
#15 0x000056545920fab4 in open_and_lock_tables (thd=0x7fb164000dc8, options=..., tables=0x7fb164017560, derived=true, flags=0, prelocking_strategy=0x7fb1800fd6a8) at /data/bld/10.11-debug/sql/sql_base.cc:5610
|
#16 0x00005654591c244e in open_and_lock_tables (thd=0x7fb164000dc8, tables=0x0, derived=true, flags=0) at /data/bld/10.11-debug/sql/sql_base.h:516
|
#17 0x00005654592cee1d in execute_sqlcom_select (thd=0x7fb164000dc8, all_tables=0x0) at /data/bld/10.11-debug/sql/sql_parse.cc:6313
|
#18 0x00005654592c5fe8 in mysql_execute_command (thd=0x7fb164000dc8, is_called_from_prepared_stmt=false) at /data/bld/10.11-debug/sql/sql_parse.cc:3988
|
#19 0x00005654592d431a in mysql_parse (thd=0x7fb164000dc8, rawbuf=0x7fb164015700 "SELECT f()", length=10, parser_state=0x7fb1800fe370) at /data/bld/10.11-debug/sql/sql_parse.cc:8152
|
#20 0x00005654592bf8b1 in dispatch_command (command=COM_QUERY, thd=0x7fb164000dc8, packet=0x7fb16400bc69 "SELECT f()", packet_length=10, blocking=true) at /data/bld/10.11-debug/sql/sql_parse.cc:1895
|
#21 0x00005654592be20a in do_command (thd=0x7fb164000dc8, blocking=true) at /data/bld/10.11-debug/sql/sql_parse.cc:1408
|
#22 0x00005654594b46cc in do_handle_one_connection (connect=0x56545c9962a8, put_in_cache=true) at /data/bld/10.11-debug/sql/sql_connect.cc:1417
|
#23 0x00005654594b4441 in handle_one_connection (arg=0x56545c8ca5c8) at /data/bld/10.11-debug/sql/sql_connect.cc:1319
|
#24 0x00005654599f056c in pfs_spawn_thread (arg=0x56545c995e18) at /data/bld/10.11-debug/storage/perfschema/pfs.cc:2201
|
#25 0x00007fb1852a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#26 0x00007fb18532861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
No obvious immediate problem on a non-debug build.
Attachments
Issue Links
- is caused by
-
MDEV-34171 Memory leakage is detected on running the test versioning.partition
- Closed