Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.8.0 , 10.5.4 , 10.2.33 , 10.3.24 , 10.4.14 , 10.6.0 , 10.7.0 , 10.9.0 , 10.10.0
A race condition that was caused by MDEV-22456 was incorrectly fixed in MDEV-22790 , by attempting to acquire an exclusive page latch, while acquiring an exclusive adaptive hash index partition latch would have been appropriate.
Any attempt to upgrade page latches is prone to deadlocks. Recently, we observed a few hangs that involved nothing more than a small table consisting of one clustered index page, one secondary index page and some undo pages. Those hangs were observed on 10.6, involving the function mtr_t::defer_drop_ahi() . The corresponding function buf_defer_drop_ahi() in earlier releases is equally problematic.
Now that the race condition was correctly fixed in MDEV-27700 , we can simply invoke btr_search_drop_page_hash_index(block, true) whenever we are holding a page latch, to collect any garbage that was left behind by MDEV-22456 . There should be no need to upgrade any page latches.
is caused by
MDEV-22456
Dropping the adaptive hash index may cause DDL to lock up InnoDB
Closed
MDEV-22790
Race between btr_page_mtr_lock() dropping AHI on the same block
Closed
mentioned in
Page Failed to load
Page Failed to load
Page Failed to load
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Show 5 more links (5 mentioned in)
There are no comments yet on this issue.
{"report":{"fcp":1379.7000002861023,"ttfb":332.5,"pageVisibility":"visible","entityId":114162,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"4e874e59-b68a-4147-b99e-dd58188ffb4b","navigationType":0,"readyForUser":1465.4000000953674,"redirectCount":0,"resourceLoadedEnd":1816.7000002861023,"resourceLoadedStart":338.2000002861023,"resourceTiming":[{"duration":492.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":338.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":338.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":493,"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":338.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":338.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":831.5,"responseStart":0,"secureConnectionStart":0},{"duration":551.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":338.7000002861023,"connectEnd":338.7000002861023,"connectStart":338.7000002861023,"domainLookupEnd":338.7000002861023,"domainLookupStart":338.7000002861023,"fetchStart":338.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":338.7000002861023,"responseEnd":890.1000003814697,"responseStart":890.1000003814697,"secureConnectionStart":338.7000002861023},{"duration":598.8000001907349,"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":338.90000009536743,"connectEnd":338.90000009536743,"connectStart":338.90000009536743,"domainLookupEnd":338.90000009536743,"domainLookupStart":338.90000009536743,"fetchStart":338.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":338.90000009536743,"responseEnd":937.7000002861023,"responseStart":937.7000002861023,"secureConnectionStart":338.90000009536743},{"duration":603,"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":339.1000003814697,"connectEnd":339.1000003814697,"connectStart":339.1000003814697,"domainLookupEnd":339.1000003814697,"domainLookupStart":339.1000003814697,"fetchStart":339.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":339.1000003814697,"responseEnd":942.1000003814697,"responseStart":942.1000003814697,"secureConnectionStart":339.1000003814697},{"duration":603.3000001907349,"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":339.30000019073486,"connectEnd":339.30000019073486,"connectStart":339.30000019073486,"domainLookupEnd":339.30000019073486,"domainLookupStart":339.30000019073486,"fetchStart":339.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":339.30000019073486,"responseEnd":942.6000003814697,"responseStart":942.6000003814697,"secureConnectionStart":339.30000019073486},{"duration":603.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":339.5,"connectEnd":339.5,"connectStart":339.5,"domainLookupEnd":339.5,"domainLookupStart":339.5,"fetchStart":339.5,"redirectEnd":0,"redirectStart":0,"requestStart":339.5,"responseEnd":943,"responseStart":943,"secureConnectionStart":339.5},{"duration":696.9000000953674,"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":339.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":339.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1036.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":603.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":339.80000019073486,"connectEnd":339.80000019073486,"connectStart":339.80000019073486,"domainLookupEnd":339.80000019073486,"domainLookupStart":339.80000019073486,"fetchStart":339.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":339.80000019073486,"responseEnd":943.6000003814697,"responseStart":943.5,"secureConnectionStart":339.80000019073486},{"duration":696.9000000953674,"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":339.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":339.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1036.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":604,"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":340.1000003814697,"connectEnd":340.1000003814697,"connectStart":340.1000003814697,"domainLookupEnd":340.1000003814697,"domainLookupStart":340.1000003814697,"fetchStart":340.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":340.1000003814697,"responseEnd":944.1000003814697,"responseStart":944.1000003814697,"secureConnectionStart":340.1000003814697},{"duration":1264.1999998092651,"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":341.30000019073486,"connectEnd":341.30000019073486,"connectStart":341.30000019073486,"domainLookupEnd":341.30000019073486,"domainLookupStart":341.30000019073486,"fetchStart":341.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":341.30000019073486,"responseEnd":1605.5,"responseStart":1605.5,"secureConnectionStart":341.30000019073486},{"duration":1475.2000002861023,"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":341.5,"connectEnd":341.5,"connectStart":341.5,"domainLookupEnd":341.5,"domainLookupStart":341.5,"fetchStart":341.5,"redirectEnd":0,"redirectStart":0,"requestStart":341.5,"responseEnd":1816.7000002861023,"responseStart":1816.7000002861023,"secureConnectionStart":341.5},{"duration":547.9000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1057.9000000953674,"connectEnd":1057.9000000953674,"connectStart":1057.9000000953674,"domainLookupEnd":1057.9000000953674,"domainLookupStart":1057.9000000953674,"fetchStart":1057.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1057.9000000953674,"responseEnd":1605.8000001907349,"responseStart":1605.8000001907349,"secureConnectionStart":1057.9000000953674},{"duration":505.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1372.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1372.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1878.2000002861023,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":167,"responseStart":333,"responseEnd":336,"domLoading":336,"domInteractive":1837,"domContentLoadedEventStart":1837,"domContentLoadedEventEnd":1878,"domComplete":3119,"loadEventStart":3119,"loadEventEnd":3121,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1819.1000003814697},{"name":"bigPipe.sidebar-id.end","time":1819.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1820.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":1820.6000003814697},{"name":"activityTabFullyLoaded","time":1885.2000002861023}],"measures":[],"correlationId":"7bae3042fc1682","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":16,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}