Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.4(EOL) , 10.5 , 10.6 , 10.11 , 11.0(EOL)
Environment:
cmake . -DCMAKE_BUILD_TYPE=Debug -DPROTECT_STATEMENT_MEMROOT=ON ...
CREATE TABLE t (a INT );
INSERT INTO t VALUES (1),(2); # Optional, fails either way
PREPARE stmt FROM "UPDATE t SET a = 0 LIMIT ?" ;
EXECUTE stmt USING 0;
EXECUTE stmt USING 1;
# CLeanup
DROP TABLE t;
10.4 9b5d711ac384e4f3ce397746aa1711cdf284b9ab
mysqld: /data/bld/10.4-bug/mysys/my_alloc.c:214: alloc_root: Assertion `(mem_root->flags & 4) == 0' failed.
240409 1:39:04 [ERROR] mysqld got signal 6 ;
#9 0x00007fc9b2354e32 in __GI___assert_fail (assertion=0x5596db66eccd "(mem_root->flags & 4) == 0", file=0x5596db66ebd0 "/data/bld/10.4-bug/mysys/my_alloc.c", line=214, function=0x5596db66ed78 <__PRETTY_FUNCTION__.0> "alloc_root") at ./assert/assert.c:101
#10 0x00005596db0851e6 in alloc_root (mem_root=0x7fc99c1aa298, length=16) at /data/bld/10.4-bug/mysys/my_alloc.c:214
#11 0x00005596da2c93bb in Sql_alloc::operator new (size=16, mem_root=0x7fc99c1aa298) at /data/bld/10.4-bug/sql/sql_alloc.h:39
#12 0x00005596da2c94ec in base_list::push_back (this=0x7fc99c048268, info=0x7fc99c0493a8, mem_root=0x7fc99c1aa298) at /data/bld/10.4-bug/sql/sql_list.h:195
#13 0x00005596da37bc93 in List<TABLE_LIST>::push_back (this=0x7fc99c048268, a=0x7fc99c0493a8, mem_root=0x7fc99c1aa298) at /data/bld/10.4-bug/sql/sql_list.h:505
#14 0x00005596da3dd1ed in st_select_lex::save_leaf_tables (this=0x7fc99c048000, thd=0x7fc99c000da0) at /data/bld/10.4-bug/sql/sql_lex.cc:5096
#15 0x00005596da536bcc in mysql_update (thd=0x7fc99c000da0, table_list=0x7fc99c0493a8, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=0, ignore=false, found_return=0x7fc9ac2a8220, updated_return=0x7fc9ac2a82e0) at /data/bld/10.4-bug/sql/sql_update.cc:1349
#16 0x00005596da4121d6 in mysql_execute_command (thd=0x7fc99c000da0) at /data/bld/10.4-bug/sql/sql_parse.cc:4462
#17 0x00005596da440d6d in Prepared_statement::execute (this=0x7fc99c1a9f20, expanded_query=0x7fc9ac2a89e0, open_cursor=false) at /data/bld/10.4-bug/sql/sql_prepare.cc:5025
#18 0x00005596da43ef6c in Prepared_statement::execute_loop (this=0x7fc99c1a9f20, expanded_query=0x7fc9ac2a89e0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/bld/10.4-bug/sql/sql_prepare.cc:4472
#19 0x00005596da43c700 in mysql_sql_stmt_execute (thd=0x7fc99c000da0) at /data/bld/10.4-bug/sql/sql_prepare.cc:3531
#20 0x00005596da4108ff in mysql_execute_command (thd=0x7fc99c000da0) at /data/bld/10.4-bug/sql/sql_parse.cc:4005
#21 0x00005596da41e799 in mysql_parse (thd=0x7fc99c000da0, rawbuf=0x7fc99c0147f8 "EXECUTE stmt USING 1", length=20, parser_state=0x7fc9ac2a93c0, is_com_multi=false, is_next_command=false) at /data/bld/10.4-bug/sql/sql_parse.cc:8097
#22 0x00005596da409e14 in dispatch_command (command=COM_QUERY, thd=0x7fc99c000da0, packet=0x7fc99c00ac51 "EXECUTE stmt USING 1", packet_length=20, is_com_multi=false, is_next_command=false) at /data/bld/10.4-bug/sql/sql_parse.cc:1857
#23 0x00005596da40867b in do_command (thd=0x7fc99c000da0) at /data/bld/10.4-bug/sql/sql_parse.cc:1378
#24 0x00005596da5ac66b in do_handle_one_connection (connect=0x5596dd28e130) at /data/bld/10.4-bug/sql/sql_connect.cc:1419
#25 0x00005596da5ac3d3 in handle_one_connection (arg=0x5596dd28e130) at /data/bld/10.4-bug/sql/sql_connect.cc:1323
#26 0x00005596daaff1b0 in pfs_spawn_thread (arg=0x5596dd1e0d40) at /data/bld/10.4-bug/storage/perfschema/pfs.cc:1869
#27 0x00007fc9b23a9044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#28 0x00007fc9b242961c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
made changes -
2024-04-08 22:53
Summary
Assertion `(mem_root->flags & 4) == 0' fails on 2nd execution of PS with -DPROTECT_STATEMENT_MEMROOT=ON
Assertion `(mem_root->flags & 4) == 0' fails on 2nd execution of PS with -DWITH_PROTECT_STATEMENT_MEMROOT=ON
made changes -
2024-04-08 23:12
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.11
[ 27614
]
Fix Version/s
11.0
[ 28320
]
Fix Version/s
11.1
[ 28549
]
Fix Version/s
11.2
[ 28603
]
Fix Version/s
11.4
[ 29301
]
Affects Version/s
10.5
[ 23123
]
Affects Version/s
10.6
[ 24028
]
Affects Version/s
10.11
[ 27614
]
Affects Version/s
11.0
[ 28320
]
Affects Version/s
11.1
[ 28549
]
Affects Version/s
11.2
[ 28603
]
Affects Version/s
11.4
[ 29301
]
Affects Version/s
11.5
[ 29506
]
made changes -
2024-05-03 14:42
Fix Version/s
11.0
[ 28320
]
made changes -
2024-08-28 00:39
Affects Version/s
11.1
[ 28549
]
Affects Version/s
11.2
[ 28603
]
Affects Version/s
11.4
[ 29301
]
Affects Version/s
11.5
[ 29506
]
made changes -
2024-08-28 00:40
Fix Version/s
11.1
[ 28549
]
Fix Version/s
11.2
[ 28603
]
Fix Version/s
11.4
[ 29301
]
made changes -
2024-09-06 03:32
Fix Version/s
10.5.27
[ 29902
]
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.11
[ 27614
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2024-09-06 03:32
Fix Version/s
10.6.20
[ 29903
]
Fix Version/s
10.11.10
[ 29904
]
Fix Version/s
11.2.6
[ 29906
]
Fix Version/s
11.4.4
[ 29907
]
{"report":{"fcp":1211.5999999046326,"ttfb":299.40000009536743,"pageVisibility":"visible","entityId":128649,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"7ece11d5-a378-40b9-8181-9c519febc5f0","navigationType":0,"readyForUser":1300.3000001907349,"redirectCount":0,"resourceLoadedEnd":1626,"resourceLoadedStart":304.5,"resourceTiming":[{"duration":344.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":304.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":304.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":648.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":344.40000009536743,"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":304.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":304.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":649.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":362.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":305.09999990463257,"connectEnd":305.09999990463257,"connectStart":305.09999990463257,"domainLookupEnd":305.09999990463257,"domainLookupStart":305.09999990463257,"fetchStart":305.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":305.09999990463257,"responseEnd":667.4000000953674,"responseStart":667.4000000953674,"secureConnectionStart":305.09999990463257},{"duration":424.59999990463257,"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":305.30000019073486,"connectEnd":305.30000019073486,"connectStart":305.30000019073486,"domainLookupEnd":305.30000019073486,"domainLookupStart":305.30000019073486,"fetchStart":305.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":305.30000019073486,"responseEnd":729.9000000953674,"responseStart":729.9000000953674,"secureConnectionStart":305.30000019073486},{"duration":428.59999990463257,"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":305.40000009536743,"connectEnd":305.40000009536743,"connectStart":305.40000009536743,"domainLookupEnd":305.40000009536743,"domainLookupStart":305.40000009536743,"fetchStart":305.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":305.40000009536743,"responseEnd":734,"responseStart":734,"secureConnectionStart":305.40000009536743},{"duration":429.5,"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":305.59999990463257,"connectEnd":305.59999990463257,"connectStart":305.59999990463257,"domainLookupEnd":305.59999990463257,"domainLookupStart":305.59999990463257,"fetchStart":305.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":305.59999990463257,"responseEnd":735.0999999046326,"responseStart":735.0999999046326,"secureConnectionStart":305.59999990463257},{"duration":429.8999996185303,"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":305.7000002861023,"connectEnd":305.7000002861023,"connectStart":305.7000002861023,"domainLookupEnd":305.7000002861023,"domainLookupStart":305.7000002861023,"fetchStart":305.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":305.7000002861023,"responseEnd":735.5999999046326,"responseStart":735.5999999046326,"secureConnectionStart":305.7000002861023},{"duration":501.59999990463257,"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":312.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":312.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":814.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":423.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":312.80000019073486,"connectEnd":312.80000019073486,"connectStart":312.80000019073486,"domainLookupEnd":312.80000019073486,"domainLookupStart":312.80000019073486,"fetchStart":312.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":312.80000019073486,"responseEnd":736.2000002861023,"responseStart":736.2000002861023,"secureConnectionStart":312.80000019073486},{"duration":501.59999990463257,"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":313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":814.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":423.7999997138977,"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":313.2000002861023,"connectEnd":313.2000002861023,"connectStart":313.2000002861023,"domainLookupEnd":313.2000002861023,"domainLookupStart":313.2000002861023,"fetchStart":313.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":313.2000002861023,"responseEnd":737,"responseStart":737,"secureConnectionStart":313.2000002861023},{"duration":593.1000003814697,"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":347.09999990463257,"connectEnd":347.09999990463257,"connectStart":347.09999990463257,"domainLookupEnd":347.09999990463257,"domainLookupStart":347.09999990463257,"fetchStart":347.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":347.09999990463257,"responseEnd":940.2000002861023,"responseStart":940.2000002861023,"secureConnectionStart":347.09999990463257},{"duration":1239.2999997138977,"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":386.7000002861023,"connectEnd":386.7000002861023,"connectStart":386.7000002861023,"domainLookupEnd":386.7000002861023,"domainLookupStart":386.7000002861023,"fetchStart":386.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":386.7000002861023,"responseEnd":1626,"responseStart":1626,"secureConnectionStart":386.7000002861023},{"duration":119.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":839.9000000953674,"connectEnd":839.9000000953674,"connectStart":839.9000000953674,"domainLookupEnd":839.9000000953674,"domainLookupStart":839.9000000953674,"fetchStart":839.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":839.9000000953674,"responseEnd":959.5,"responseStart":959.5,"secureConnectionStart":839.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":67,"responseStart":300,"responseEnd":387,"domLoading":303,"domInteractive":1657,"domContentLoadedEventStart":1657,"domContentLoadedEventEnd":1707,"domComplete":2338,"loadEventStart":2338,"loadEventEnd":2338,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1627.7000002861023},{"name":"bigPipe.sidebar-id.end","time":1628.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1628.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1633.5},{"name":"activityTabFullyLoaded","time":1724.2000002861023}],"measures":[],"correlationId":"7bfda97ac84882","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":152,"dbReadsTimeInMs":25,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-14959 Control over memory allocated for SP/PS