Type:
Priority:
Resolution:
Fixed
DDL operations in MariaDB are known to not be crash-safe. The most unsafe is ALGORITHM=INPLACE, because the .frm file is replaced out of sync with the InnoDB transaction commit.
One thing that can be improved is that when the server is killed before the InnoDB transaction commit becomes durable, the intermediate table should be removable by executing a statement like
DROP TABLE `#mysql50##sql-abcd_1.frm`;
Currently, the intermediate table in the InnoDB internal data dictionary is not derived from the .frm file name, and such a DROP TABLE statement would leave orphan entries in the InnoDB internal data dictionary.
relates to
MDEV-13407
innodb.drop_table_background failed in buildbot with "Tablespace for table exists"
Closed
made changes -
2017-11-13 09:15
Field
Original Value
New Value
issue.field.resolutiondate
2017-11-13 09:15:38.0
2017-11-13 09:15:38.882
made changes -
2017-11-13 09:15
Fix Version/s
10.3.3
[ 22644
]
Fix Version/s
10.3
[ 22126
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2018-09-26 09:52
Fix Version/s
10.2.19
[ 23207
]
made changes -
2021-12-06 21:23
Workflow
MariaDB v3
[ 83771
]
MariaDB v4
[ 133393
]
{"report":{"fcp":1905.1999998092651,"ttfb":680.2999997138977,"pageVisibility":"visible","entityId":64270,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"29c21d99-5636-4e66-9f46-81aadc542079","navigationType":0,"readyForUser":1992.5999999046326,"redirectCount":0,"resourceLoadedEnd":1575.5999999046326,"resourceLoadedStart":689,"resourceTiming":[{"duration":162.2999997138977,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":689,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":689,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":851.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":159.5,"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":693.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":693.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":852.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":599,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":693.5,"connectEnd":693.5,"connectStart":693.5,"domainLookupEnd":693.5,"domainLookupStart":693.5,"fetchStart":693.5,"redirectEnd":0,"redirectStart":0,"requestStart":868,"responseEnd":1292.5,"responseStart":896.5999999046326,"secureConnectionStart":693.5},{"duration":819.2000002861023,"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":694.2999997138977,"connectEnd":694.2999997138977,"connectStart":694.2999997138977,"domainLookupEnd":694.2999997138977,"domainLookupStart":694.2999997138977,"fetchStart":694.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":868.2999997138977,"responseEnd":1513.5,"responseStart":889,"secureConnectionStart":694.2999997138977},{"duration":204.69999980926514,"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":694.5999999046326,"connectEnd":694.5999999046326,"connectStart":694.5999999046326,"domainLookupEnd":694.5999999046326,"domainLookupStart":694.5999999046326,"fetchStart":694.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":869.0999999046326,"responseEnd":899.2999997138977,"responseStart":895.8999996185303,"secureConnectionStart":694.5999999046326},{"duration":204.69999980926514,"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":694.6999998092651,"connectEnd":694.6999998092651,"connectStart":694.6999998092651,"domainLookupEnd":694.6999998092651,"domainLookupStart":694.6999998092651,"fetchStart":694.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":870.6999998092651,"responseEnd":899.3999996185303,"responseStart":897.0999999046326,"secureConnectionStart":694.6999998092651},{"duration":204.60000038146973,"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":694.8999996185303,"connectEnd":694.8999996185303,"connectStart":694.8999996185303,"domainLookupEnd":694.8999996185303,"domainLookupStart":694.8999996185303,"fetchStart":694.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":873.3999996185303,"responseEnd":899.5,"responseStart":897.5999999046326,"secureConnectionStart":694.8999996185303},{"duration":176.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":695.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":695.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":871.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":204.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":695.2999997138977,"connectEnd":695.2999997138977,"connectStart":695.2999997138977,"domainLookupEnd":695.2999997138977,"domainLookupStart":695.2999997138977,"fetchStart":695.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":875.3999996185303,"responseEnd":899.5999999046326,"responseStart":898,"secureConnectionStart":695.2999997138977},{"duration":177.30000019073486,"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":695.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":695.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":872.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":210.69999980926514,"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":695.5999999046326,"connectEnd":695.5999999046326,"connectStart":695.5999999046326,"domainLookupEnd":695.5999999046326,"domainLookupStart":695.5999999046326,"fetchStart":695.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":875.7999997138977,"responseEnd":906.2999997138977,"responseStart":898.5,"secureConnectionStart":695.5999999046326},{"duration":879.2000002861023,"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":696.3999996185303,"connectEnd":696.3999996185303,"connectStart":696.3999996185303,"domainLookupEnd":696.3999996185303,"domainLookupStart":696.3999996185303,"fetchStart":696.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1105,"responseEnd":1575.5999999046326,"responseStart":1569.5999999046326,"secureConnectionStart":696.3999996185303},{"duration":872.6999998092651,"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":701.5999999046326,"connectEnd":701.5999999046326,"connectStart":701.5999999046326,"domainLookupEnd":701.5999999046326,"domainLookupStart":701.5999999046326,"fetchStart":701.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1295.6999998092651,"responseEnd":1574.2999997138977,"responseStart":1564.2999997138977,"secureConnectionStart":701.5999999046326},{"duration":191.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1455.7999997138977,"connectEnd":1455.7999997138977,"connectStart":1455.7999997138977,"domainLookupEnd":1455.7999997138977,"domainLookupStart":1455.7999997138977,"fetchStart":1455.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1611.3999996185303,"responseEnd":1647.2999997138977,"responseStart":1646.6999998092651,"secureConnectionStart":1455.7999997138977}],"fetchStart":0,"domainLookupStart":473,"domainLookupEnd":484,"connectStart":484,"connectEnd":503,"secureConnectionStart":492,"requestStart":504,"responseStart":680,"responseEnd":702,"domLoading":685,"domInteractive":2067,"domContentLoadedEventStart":2067,"domContentLoadedEventEnd":2145,"domComplete":2807,"loadEventStart":2807,"loadEventEnd":2808,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2028.2999997138977},{"name":"bigPipe.sidebar-id.end","time":2029.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":2029.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":2031.8999996185303},{"name":"activityTabFullyLoaded","time":2164.3999996185303}],"measures":[],"correlationId":"84a7bc90d691fb","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":106,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Major
MDEV-13407 innodb.drop_table_background failed in buildbot with "Tablespace for table exists"
I have added that in MariaDB 10.3, one can drop an orphaned #sql- table name with DROP TABLE #sql-...
This is a temporary fix until we make table name creation in ALTER TABLE crash proof
(10.3 or 10.4)