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.
- is caused by
-
MDEV-34171
Memory leakage is detected on running the test versioning.partition
-
-
Closed
{"report":{"fcp":1098,"ttfb":173.60000038146973,"pageVisibility":"visible","entityId":130375,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b0d9d472-2fc5-498a-aebb-be90a93b2e65","navigationType":0,"readyForUser":1192.6999998092651,"redirectCount":0,"resourceLoadedEnd":1513.8999996185303,"resourceLoadedStart":179,"resourceTiming":[{"duration":341.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":179,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":341.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":179.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520.5,"responseStart":0,"secureConnectionStart":0},{"duration":350.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":179.5,"connectEnd":179.5,"connectStart":179.5,"domainLookupEnd":179.5,"domainLookupStart":179.5,"fetchStart":179.5,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":530.1000003814697,"responseStart":530.1000003814697,"secureConnectionStart":179.5},{"duration":428.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":179.69999980926514,"connectEnd":179.69999980926514,"connectStart":179.69999980926514,"domainLookupEnd":179.69999980926514,"domainLookupStart":179.69999980926514,"fetchStart":179.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":179.69999980926514,"responseEnd":608.1999998092651,"responseStart":608.1999998092651,"secureConnectionStart":179.69999980926514},{"duration":432.70000076293945,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":179.89999961853027,"connectEnd":179.89999961853027,"connectStart":179.89999961853027,"domainLookupEnd":179.89999961853027,"domainLookupStart":179.89999961853027,"fetchStart":179.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":179.89999961853027,"responseEnd":612.6000003814697,"responseStart":612.6000003814697,"secureConnectionStart":179.89999961853027},{"duration":433,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":180.10000038146973,"connectEnd":180.10000038146973,"connectStart":180.10000038146973,"domainLookupEnd":180.10000038146973,"domainLookupStart":180.10000038146973,"fetchStart":180.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":180.10000038146973,"responseEnd":613.1000003814697,"responseStart":613.1000003814697,"secureConnectionStart":180.10000038146973},{"duration":433.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":180.30000019073486,"connectEnd":180.30000019073486,"connectStart":180.30000019073486,"domainLookupEnd":180.30000019073486,"domainLookupStart":180.30000019073486,"fetchStart":180.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":180.30000019073486,"responseEnd":613.8000001907349,"responseStart":613.8000001907349,"secureConnectionStart":180.30000019073486},{"duration":521.2000007629395,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":180.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":701.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":433.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":180.60000038146973,"connectEnd":180.60000038146973,"connectStart":180.60000038146973,"domainLookupEnd":180.60000038146973,"domainLookupStart":180.60000038146973,"fetchStart":180.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":180.60000038146973,"responseEnd":614.3999996185303,"responseStart":614.3999996185303,"secureConnectionStart":180.60000038146973},{"duration":520.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":180.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":701.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":434,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":181,"connectEnd":181,"connectStart":181,"domainLookupEnd":181,"domainLookupStart":181,"fetchStart":181,"redirectEnd":0,"redirectStart":0,"requestStart":181,"responseEnd":615,"responseStart":615,"secureConnectionStart":181},{"duration":649.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":192.39999961853027,"connectEnd":192.39999961853027,"connectStart":192.39999961853027,"domainLookupEnd":192.39999961853027,"domainLookupStart":192.39999961853027,"fetchStart":192.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":192.39999961853027,"responseEnd":842,"responseStart":842,"secureConnectionStart":192.39999961853027},{"duration":1315.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":193,"connectEnd":193,"connectStart":193,"domainLookupEnd":193,"domainLookupStart":193,"fetchStart":193,"redirectEnd":0,"redirectStart":0,"requestStart":193,"responseEnd":1508.3000001907349,"responseStart":1508.3000001907349,"secureConnectionStart":193},{"duration":130.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":716.1000003814697,"connectEnd":716.1000003814697,"connectStart":716.1000003814697,"domainLookupEnd":716.1000003814697,"domainLookupStart":716.1000003814697,"fetchStart":716.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":716.1000003814697,"responseEnd":846.6000003814697,"responseStart":846.6000003814697,"secureConnectionStart":716.1000003814697},{"duration":485,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1025,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1025,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1510,"responseStart":0,"secureConnectionStart":0},{"duration":484.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1026,"connectEnd":1026,"connectStart":1026,"domainLookupEnd":1026,"domainLookupStart":1026,"fetchStart":1026,"redirectEnd":0,"redirectStart":0,"requestStart":1026,"responseEnd":1510.3999996185303,"responseStart":1510.3999996185303,"secureConnectionStart":1026},{"duration":448.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1089.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1089.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1538.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":487.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1026.5,"connectEnd":1026.5,"connectStart":1026.5,"domainLookupEnd":1026.5,"domainLookupStart":1026.5,"fetchStart":1026.5,"redirectEnd":0,"redirectStart":0,"requestStart":1026.5,"responseEnd":1513.8999996185303,"responseStart":1513.8000001907349,"secureConnectionStart":1026.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":15,"responseStart":173,"responseEnd":192,"domLoading":177,"domInteractive":1540,"domContentLoadedEventStart":1540,"domContentLoadedEventEnd":1590,"domComplete":2738,"loadEventStart":2738,"loadEventEnd":2739,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1516},{"name":"bigPipe.sidebar-id.end","time":1517},{"name":"bigPipe.activity-panel-pipe-id.start","time":1517.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":1519.8999996185303},{"name":"activityTabFullyLoaded","time":1600.6000003814697}],"measures":[],"correlationId":"3832d124bea07f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":11,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}