The function dict_stats_process_entry_from_defrag_pool() fails to invoke dict_table_close() when an index does not exist in the table (for example because it has been dropped):
dict_index_t* index = dict_table_find_index_on_id(table, index_id);
|
|
if (index == NULL) {
|
return;
|
}
|
|
/* Check whether index is corrupted */
|
if (dict_index_is_corrupted(index)) {
|
dict_table_close(table, FALSE, FALSE);
|
return;
|
}
|
As you can see above, existing but corrupted indexes are handled correctly.
Failure to release a table handle should cause an infinite wait at some point in InnoDB, at least in DROP TABLE:
2017-12-02 21:06:52 139784064132864 [Warning] InnoDB: Waited 270 seconds for ref-count on table: `db`.`tablename` space: 12345
|
- is caused by
-
MDEV-5834
Merge Kakao Defragmentation implementation to MariaDB 10.1
-
-
Closed
There are no comments yet on this issue.
{"report":{"fcp":928.1999999880791,"ttfb":344.19999998807907,"pageVisibility":"visible","entityId":64715,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d88a646d-3c34-4164-86ea-dfc9b019c463","navigationType":0,"readyForUser":1006.6000000238419,"redirectCount":0,"resourceLoadedEnd":953.6999999880791,"resourceLoadedStart":350.5,"resourceTiming":[{"duration":19.400000035762787,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":350.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":350.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":369.9000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":19.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":350.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":350.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":370.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":72.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":351,"connectEnd":351,"connectStart":351,"domainLookupEnd":351,"domainLookupStart":351,"fetchStart":351,"redirectEnd":0,"redirectStart":0,"requestStart":351,"responseEnd":423.60000002384186,"responseStart":423.60000002384186,"secureConnectionStart":351},{"duration":172.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":351.19999998807907,"connectEnd":351.19999998807907,"connectStart":351.19999998807907,"domainLookupEnd":351.19999998807907,"domainLookupStart":351.19999998807907,"fetchStart":351.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":351.19999998807907,"responseEnd":523.8000000119209,"responseStart":523.8000000119209,"secureConnectionStart":351.19999998807907},{"duration":176.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":351.4000000357628,"connectEnd":351.4000000357628,"connectStart":351.4000000357628,"domainLookupEnd":351.4000000357628,"domainLookupStart":351.4000000357628,"fetchStart":351.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":351.4000000357628,"responseEnd":527.6000000238419,"responseStart":527.6000000238419,"secureConnectionStart":351.4000000357628},{"duration":177.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":351.5,"connectEnd":351.5,"connectStart":351.5,"domainLookupEnd":351.5,"domainLookupStart":351.5,"fetchStart":351.5,"redirectEnd":0,"redirectStart":0,"requestStart":351.5,"responseEnd":528.6999999880791,"responseStart":528.6999999880791,"secureConnectionStart":351.5},{"duration":178,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":351.80000001192093,"connectEnd":351.80000001192093,"connectStart":351.80000001192093,"domainLookupEnd":351.80000001192093,"domainLookupStart":351.80000001192093,"fetchStart":351.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":351.80000001192093,"responseEnd":529.8000000119209,"responseStart":529.8000000119209,"secureConnectionStart":351.80000001192093},{"duration":218.0999999642372,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":351.9000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":351.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":570,"responseStart":0,"secureConnectionStart":0},{"duration":178.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":352.10000002384186,"connectEnd":352.10000002384186,"connectStart":352.10000002384186,"domainLookupEnd":352.10000002384186,"domainLookupStart":352.10000002384186,"fetchStart":352.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":352.10000002384186,"responseEnd":531,"responseStart":531,"secureConnectionStart":352.10000002384186},{"duration":218,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":352.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":352.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":570.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":179.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":352.4000000357628,"connectEnd":352.4000000357628,"connectStart":352.4000000357628,"domainLookupEnd":352.4000000357628,"domainLookupStart":352.4000000357628,"fetchStart":352.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":352.4000000357628,"responseEnd":532.1000000238419,"responseStart":532.1000000238419,"secureConnectionStart":352.4000000357628},{"duration":230.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":353.30000001192093,"connectEnd":353.30000001192093,"connectStart":353.30000001192093,"domainLookupEnd":353.30000001192093,"domainLookupStart":353.30000001192093,"fetchStart":353.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":353.30000001192093,"responseEnd":583.6000000238419,"responseStart":583.6000000238419,"secureConnectionStart":353.30000001192093},{"duration":232.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":353.30000001192093,"connectEnd":353.30000001192093,"connectStart":353.30000001192093,"domainLookupEnd":353.30000001192093,"domainLookupStart":353.30000001192093,"fetchStart":353.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":353.30000001192093,"responseEnd":586.1999999880791,"responseStart":586.1999999880791,"secureConnectionStart":353.30000001192093},{"duration":3,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":582,"connectEnd":582,"connectStart":582,"domainLookupEnd":582,"domainLookupStart":582,"fetchStart":582,"redirectEnd":0,"redirectStart":0,"requestStart":582,"responseEnd":585,"responseStart":585,"secureConnectionStart":582},{"duration":21.100000023841858,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":603.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":603.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":624.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":261.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":604.5,"connectEnd":604.5,"connectStart":604.5,"domainLookupEnd":604.5,"domainLookupStart":604.5,"fetchStart":604.5,"redirectEnd":0,"redirectStart":0,"requestStart":604.5,"responseEnd":865.8000000119209,"responseStart":865.8000000119209,"secureConnectionStart":604.5},{"duration":157,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":705.1000000238419,"connectEnd":705.1000000238419,"connectStart":705.1000000238419,"domainLookupEnd":705.1000000238419,"domainLookupStart":705.1000000238419,"fetchStart":705.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":705.1000000238419,"responseEnd":862.1000000238419,"responseStart":862.1000000238419,"secureConnectionStart":705.1000000238419},{"duration":119.30000001192093,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":920.1999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":920.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1039.5,"responseStart":0,"secureConnectionStart":0},{"duration":21.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":934.6000000238419,"connectEnd":934.6000000238419,"connectStart":934.6000000238419,"domainLookupEnd":934.6000000238419,"domainLookupStart":934.6000000238419,"fetchStart":934.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":934.6000000238419,"responseEnd":956.1000000238419,"responseStart":956.1000000238419,"secureConnectionStart":934.6000000238419},{"duration":348.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":604.9000000357628,"connectEnd":604.9000000357628,"connectStart":604.9000000357628,"domainLookupEnd":604.9000000357628,"domainLookupStart":604.9000000357628,"fetchStart":604.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":604.9000000357628,"responseEnd":953.6999999880791,"responseStart":953.6999999880791,"secureConnectionStart":604.9000000357628}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":2,"responseStart":344,"responseEnd":347,"domLoading":347,"domInteractive":1067,"domContentLoadedEventStart":1067,"domContentLoadedEventEnd":1109,"domComplete":1159,"loadEventStart":1159,"loadEventEnd":1160,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1043.699999988079},{"name":"bigPipe.sidebar-id.end","time":1044.6000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1044.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1045.199999988079},{"name":"activityTabFullyLoaded","time":1123.4000000357628}],"measures":[],"correlationId":"7595e56df21ed0","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":275,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}