Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
10.6 , 10.11 , 11.0(EOL) , 11.1(EOL) , 11.2(EOL) , 11.3(EOL) , 11.4
The following failure is reported by MemorySanitizer on our CI systems every now and then, and I can reproduce it locally as well:
10.6 73291de74e49a84700ce4e2aa2c7ec6769d884dc
innodb_gis.rtree_compress '16k,innodb' w1 [ 3 fail ]
Test ended at 2024-04-08 17:14:37
CURRENT_TEST: innodb_gis.rtree_compress
mysqltest: At line 43: query 'rollback' failed: <Unknown> (2013): Lost connection to server during query
...
==932423==WARNING: MemorySanitizer: use-of-uninitialized-value
#0 0x5641413d732e in rtr_pcur_getnext_from_path(dtuple_t const*, page_cur_mode_t, btr_cur_t*, unsigned long, unsigned long, bool, mtr_t*) /mariadb/10.6/storage/innobase/gis/gis0sea.cc:292:3
#1 0x5641413c817e in rtr_search(dtuple_t const*, btr_latch_mode, btr_pcur_t*, mtr_t*) /mariadb/10.6/storage/innobase/gis/gis0sea.cc:1087:8
#2 0x5641418bbc90 in row_undo_ins_remove_sec_low(btr_latch_mode, dict_index_t*, dtuple_t*, que_thr_t*) /mariadb/10.6/storage/innobase/row/row0uins.cc:283:7
#3 0x5641418b6c14 in row_undo_ins_remove_sec(dict_index_t*, dtuple_t*, que_thr_t*) /mariadb/10.6/storage/innobase/row/row0uins.cc:353:8
#4 0x5641418b6c14 in row_undo_ins_remove_sec_rec(undo_node_t*, que_thr_t*) /mariadb/10.6/storage/innobase/row/row0uins.cc:547:10
#5 0x5641418b6c14 in row_undo_ins(undo_node_t*, que_thr_t*) /mariadb/10.6/storage/innobase/row/row0uins.cc:599:9
#6 0x5641418b3429 in row_undo(undo_node_t*, que_thr_t*) /mariadb/10.6/storage/innobase/row/row0undo.cc:399:5
#7 0x5641418b3429 in row_undo_step(que_thr_t*) /mariadb/10.6/storage/innobase/row/row0undo.cc:440:8
#8 0x5641417021fe in que_thr_step(que_thr_t*) /mariadb/10.6/storage/innobase/que/que0que.cc:586:9
#9 0x5641417021fe in que_run_threads_low(que_thr_t*) /mariadb/10.6/storage/innobase/que/que0que.cc:644:25
#10 0x5641417021fe in que_run_threads(que_thr_t*) /mariadb/10.6/storage/innobase/que/que0que.cc:664:2
#11 0x564141988b70 in trx_t::rollback_low(trx_savept_t*) /mariadb/10.6/storage/innobase/trx/trx0roll.cc:125:5
#12 0x564141982dcd in trx_rollback_for_mysql_low(trx_t*) /mariadb/10.6/storage/innobase/trx/trx0roll.cc:196:7
#13 0x564141982dcd in trx_rollback_for_mysql(trx_t*) /mariadb/10.6/storage/innobase/trx/trx0roll.cc
#14 0x5641410d3d85 in innobase_rollback(handlerton*, THD*, bool) /mariadb/10.6/storage/innobase/handler/ha_innodb.cc:4697:11
#15 0x56413f9c4faf in ha_rollback_trans(THD*, bool) /mariadb/10.6/sql/handler.cc:2237:17
#16 0x5641408bdfae in trans_rollback(THD*) /mariadb/10.6/sql/transaction.cc:387:8
#17 0x5641403aed19 in mysql_execute_command(THD*, bool) /mariadb/10.6/sql/sql_parse.cc:5777:27
#18 0x564140395f52 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /mariadb/10.6/sql/sql_parse.cc:8139:18
#19 0x56414038e690 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /mariadb/10.6/sql/sql_parse.cc:1896:7
#20 0x564140397014 in do_command(THD*, bool) /mariadb/10.6/sql/sql_parse.cc:1409:17
#21 0x56414087e4f5 in do_handle_one_connection(CONNECT*, bool) /mariadb/10.6/sql/sql_connect.cc:1415:11
#22 0x56414087df65 in handle_one_connection /mariadb/10.6/sql/sql_connect.cc:1317:5
#23 0x564140e72c40 in pfs_spawn_thread /mariadb/10.6/storage/perfschema/pfs.cc:2201:3
#24 0x7f586a6a645b in start_thread nptl/pthread_create.c:444:8
#25 0x7f586a726bbb in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Uninitialized value was stored to memory at
#0 0x5641413d7327 in page_is_leaf(unsigned char const*) /mariadb/10.6/storage/innobase/include/page0page.h:263:10
#1 0x5641413d7327 in rtr_pcur_getnext_from_path(dtuple_t const*, page_cur_mode_t, btr_cur_t*, unsigned long, unsigned long, bool, mtr_t*) /mariadb/10.6/storage/innobase/gis/gis0sea.cc:292:3
Memory was marked as uninitialized
#0 0x56413f8dc971 in __msan_allocated_memory (/dev/shm/10.6msan/sql/mariadbd+0xfd9971) (BuildId: 963d974e3992c2b5)
#1 0x5641412af2fa in buf_LRU_block_free_non_file_page(buf_block_t*) /mariadb/10.6/storage/innobase/buf/buf0lru.cc:975:2
A possible reason why earlier versions are not affected could be that MDEV-23484 was fixed in 10.6.
The problem seems to be inadequate locking in rtr_pcur_getnext_from_path() . I have a patch that passes the following execution on my local system (see MDEV-20377 how to build and run tests with MemorySanitizer):
LD_LIBRARY_PATH=~ /libmsan-18 MSAN_SYMBOLIZER_PATH=~ /bin/llvm-symbolizer-msan . /mtr --parallel=auto --repeat=10 innodb_gis.rtree_compress{,,,,,,,,,,}
10.6 73291de74e49a84700ce4e2aa2c7ec6769d884dc with patch
innodb_gis.rtree_compress '4k,innodb' w14 [ 10 pass ] 17794
innodb_gis.rtree_compress '4k,innodb' w17 [ 10 pass ] 17397
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 8710.576 of 305 seconds executing testcases
Completed: All 330 tests were successful.
{"report":{"fcp":939,"ttfb":307,"pageVisibility":"visible","entityId":128645,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"e8672e62-9711-4841-812a-7899df4b9dde","navigationType":0,"readyForUser":1036.1000000014901,"redirectCount":0,"resourceLoadedEnd":1226.3999999985099,"resourceLoadedStart":312.5,"resourceTiming":[{"duration":137.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":312.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":312.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":450,"responseStart":0,"secureConnectionStart":0},{"duration":137.59999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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","startTime":312.80000000447035,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":312.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":450.3999999985099,"responseStart":0,"secureConnectionStart":0},{"duration":146.79999999701977,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":313.1000000014901,"connectEnd":313.1000000014901,"connectStart":313.1000000014901,"domainLookupEnd":313.1000000014901,"domainLookupStart":313.1000000014901,"fetchStart":313.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":313.1000000014901,"responseEnd":459.8999999985099,"responseStart":459.8999999985099,"secureConnectionStart":313.1000000014901},{"duration":215,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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","startTime":313.30000000447035,"connectEnd":313.30000000447035,"connectStart":313.30000000447035,"domainLookupEnd":313.30000000447035,"domainLookupStart":313.30000000447035,"fetchStart":313.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":313.30000000447035,"responseEnd":528.3000000044703,"responseStart":528.3000000044703,"secureConnectionStart":313.30000000447035},{"duration":218.80000000447035,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":313.5,"connectEnd":313.5,"connectStart":313.5,"domainLookupEnd":313.5,"domainLookupStart":313.5,"fetchStart":313.5,"redirectEnd":0,"redirectStart":0,"requestStart":313.5,"responseEnd":532.3000000044703,"responseStart":532.3000000044703,"secureConnectionStart":313.5},{"duration":219.20000000298023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":313.6000000014901,"connectEnd":313.6000000014901,"connectStart":313.6000000014901,"domainLookupEnd":313.6000000014901,"domainLookupStart":313.6000000014901,"fetchStart":313.6000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":313.6000000014901,"responseEnd":532.8000000044703,"responseStart":532.8000000044703,"secureConnectionStart":313.6000000014901},{"duration":219.29999999701977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":313.80000000447035,"connectEnd":313.80000000447035,"connectStart":313.80000000447035,"domainLookupEnd":313.80000000447035,"domainLookupStart":313.80000000447035,"fetchStart":313.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":313.80000000447035,"responseEnd":533.1000000014901,"responseStart":533.1000000014901,"secureConnectionStart":313.80000000447035},{"duration":296.20000000298023,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":313.8999999985099,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":610.1000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":219.60000000149012,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":314.1000000014901,"connectEnd":314.1000000014901,"connectStart":314.1000000014901,"domainLookupEnd":314.1000000014901,"domainLookupStart":314.1000000014901,"fetchStart":314.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":314.1000000014901,"responseEnd":533.7000000029802,"responseStart":533.7000000029802,"secureConnectionStart":314.1000000014901},{"duration":296,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":314.30000000447035,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":610.3000000044703,"responseStart":0,"secureConnectionStart":0},{"duration":219.90000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":314.3999999985099,"connectEnd":314.3999999985099,"connectStart":314.3999999985099,"domainLookupEnd":314.3999999985099,"domainLookupStart":314.3999999985099,"fetchStart":314.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":314.3999999985099,"responseEnd":534.3000000044703,"responseStart":534.3000000044703,"secureConnectionStart":314.3999999985099},{"duration":400.3999999985099,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":315.5,"responseEnd":715.8999999985099,"responseStart":715.8999999985099,"secureConnectionStart":315.5},{"duration":903.7000000029802,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":315.6000000014901,"connectEnd":315.6000000014901,"connectStart":315.6000000014901,"domainLookupEnd":315.6000000014901,"domainLookupStart":315.6000000014901,"fetchStart":315.6000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":315.6000000014901,"responseEnd":1219.3000000044703,"responseStart":1219.3000000044703,"secureConnectionStart":315.6000000014901},{"duration":81.79999999701977,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":642.8000000044703,"connectEnd":642.8000000044703,"connectStart":642.8000000044703,"domainLookupEnd":642.8000000044703,"domainLookupStart":642.8000000044703,"fetchStart":642.8000000044703,"redirectEnd":0,"redirectStart":0,"requestStart":642.8000000044703,"responseEnd":724.6000000014901,"responseStart":724.6000000014901,"secureConnectionStart":642.8000000044703},{"duration":331.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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","startTime":888.8999999985099,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":888.8999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1220.3999999985099,"responseStart":0,"secureConnectionStart":0},{"duration":331,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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","startTime":890,"connectEnd":890,"connectStart":890,"domainLookupEnd":890,"domainLookupStart":890,"fetchStart":890,"redirectEnd":0,"redirectStart":0,"requestStart":890,"responseEnd":1221,"responseStart":1221,"secureConnectionStart":890},{"duration":336,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/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","startTime":890.3999999985099,"connectEnd":890.3999999985099,"connectStart":890.3999999985099,"domainLookupEnd":890.3999999985099,"domainLookupStart":890.3999999985099,"fetchStart":890.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":890.3999999985099,"responseEnd":1226.3999999985099,"responseStart":1226.3999999985099,"secureConnectionStart":890.3999999985099},{"duration":319,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":932.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":932.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1251.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":129,"responseStart":307,"responseEnd":310,"domLoading":310,"domInteractive":1254,"domContentLoadedEventStart":1254,"domContentLoadedEventEnd":1299,"domComplete":2455,"loadEventStart":2455,"loadEventEnd":2457,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1224},{"name":"bigPipe.sidebar-id.end","time":1224.8000000044703},{"name":"bigPipe.activity-panel-pipe-id.start","time":1225},{"name":"bigPipe.activity-panel-pipe-id.end","time":1227.3999999985099},{"name":"activityTabFullyLoaded","time":1315}],"measures":[],"correlationId":"1bb4187421caa0","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":111,"dbReadsTimeInMs":20,"dbConnsTimeInMs":31,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}