Type:
Priority:
Resolution:
Fixed
Affects Version/s:
N/A
serg wrote elsewhere:
Conditions under which online alter works are getting more and more complicated, lots of cases will disable online mode. Perhaps it'd make sense to issue a warning of why exactly online was disabled? Otherwise, I suspect, users will be hardly able to navigate this maze of conditions.
So far this extra diagnostics has not been implemented, error messages still look the way they did before:
bb-11.0-oalter fd06124e66c
MariaDB [test]> alter online table t1 rename to t1a;
ERROR 1845 (0A000): LOCK=NONE/SHARED is not supported for this operation. Try LOCK=EXCLUSIVE
MariaDB [test]> show warnings;
+ -------+------+--------------------------------------------------------------------------+
| Level | Code | Message |
+ -------+------+--------------------------------------------------------------------------+
| Error | 1845 | LOCK=NONE/SHARED is not supported for this operation. Try LOCK=EXCLUSIVE |
+ -------+------+--------------------------------------------------------------------------+
1 row in set (0.000 sec)
{"report":{"fcp":1930.4000000953674,"ttfb":682.0999999046326,"pageVisibility":"visible","entityId":120748,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ddfbe20d-c7fd-4d0f-a6d3-1708f177533b","navigationType":0,"readyForUser":2022.5,"redirectCount":0,"resourceLoadedEnd":1565.5,"resourceLoadedStart":691,"resourceTiming":[{"duration":226.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":691,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":691,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":917.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":227.2000002861023,"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":691.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":691.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":918.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":666.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":691.4000000953674,"connectEnd":691.4000000953674,"connectStart":691.4000000953674,"domainLookupEnd":691.4000000953674,"domainLookupStart":691.4000000953674,"fetchStart":691.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":921.1999998092651,"responseEnd":1357.6999998092651,"responseStart":942.0999999046326,"secureConnectionStart":691.4000000953674},{"duration":873.9000000953674,"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":691.5999999046326,"connectEnd":691.5999999046326,"connectStart":691.5999999046326,"domainLookupEnd":691.5999999046326,"domainLookupStart":691.5999999046326,"fetchStart":691.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":945.1999998092651,"responseEnd":1565.5,"responseStart":959.7999997138977,"secureConnectionStart":691.5999999046326},{"duration":276,"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":691.7999997138977,"connectEnd":691.7999997138977,"connectStart":691.7999997138977,"domainLookupEnd":691.7999997138977,"domainLookupStart":691.7999997138977,"fetchStart":691.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":946.5999999046326,"responseEnd":967.7999997138977,"responseStart":963.2999997138977,"secureConnectionStart":691.7999997138977},{"duration":276.2999997138977,"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":692,"connectEnd":692,"connectStart":692,"domainLookupEnd":692,"domainLookupStart":692,"fetchStart":692,"redirectEnd":0,"redirectStart":0,"requestStart":947.5,"responseEnd":968.2999997138977,"responseStart":964.6999998092651,"secureConnectionStart":692},{"duration":295.30000019073486,"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":692.1999998092651,"connectEnd":692.1999998092651,"connectStart":692.1999998092651,"domainLookupEnd":692.1999998092651,"domainLookupStart":692.1999998092651,"fetchStart":692.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":968,"responseEnd":987.5,"responseStart":985.7999997138977,"secureConnectionStart":692.1999998092651},{"duration":271.90000009536743,"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":692.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":692.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":964.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":315.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":692.5,"connectEnd":692.5,"connectStart":692.5,"domainLookupEnd":692.5,"domainLookupStart":692.5,"fetchStart":692.5,"redirectEnd":0,"redirectStart":0,"requestStart":968.5,"responseEnd":1007.6999998092651,"responseStart":990,"secureConnectionStart":692.5},{"duration":273.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":692.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":692.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":965.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":320,"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":692.6999998092651,"connectEnd":692.6999998092651,"connectStart":692.6999998092651,"domainLookupEnd":692.6999998092651,"domainLookupStart":692.6999998092651,"fetchStart":692.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":968.6999998092651,"responseEnd":1012.6999998092651,"responseStart":991.5,"secureConnectionStart":692.6999998092651},{"duration":864.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":693.9000000953674,"connectEnd":693.9000000953674,"connectStart":693.9000000953674,"domainLookupEnd":693.9000000953674,"domainLookupStart":693.9000000953674,"fetchStart":693.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1256.7999997138977,"responseEnd":1558.0999999046326,"responseStart":1552.6999998092651,"secureConnectionStart":693.9000000953674},{"duration":862.3000001907349,"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":698.7999997138977,"connectEnd":698.7999997138977,"connectStart":698.7999997138977,"domainLookupEnd":698.7999997138977,"domainLookupStart":698.7999997138977,"fetchStart":698.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1427.6999998092651,"responseEnd":1561.0999999046326,"responseStart":1555.0999999046326,"secureConnectionStart":698.7999997138977},{"duration":352.7000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1546.2999997138977,"connectEnd":1546.2999997138977,"connectStart":1546.2999997138977,"domainLookupEnd":1546.2999997138977,"domainLookupStart":1546.2999997138977,"fetchStart":1546.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1867.5,"responseEnd":1899,"responseStart":1898.4000000953674,"secureConnectionStart":1546.2999997138977},{"duration":290.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1948.1999998092651,"connectEnd":1948.1999998092651,"connectStart":1948.1999998092651,"domainLookupEnd":1948.1999998092651,"domainLookupStart":1948.1999998092651,"fetchStart":1948.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":2204.2999997138977,"responseEnd":2238.7999997138977,"responseStart":2238.199999809265,"secureConnectionStart":1948.1999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":441,"responseStart":682,"responseEnd":699,"domLoading":686,"domInteractive":2144,"domContentLoadedEventStart":2144,"domContentLoadedEventEnd":2225,"domComplete":2927,"loadEventStart":2927,"loadEventEnd":2927,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2078.5},{"name":"bigPipe.sidebar-id.end","time":2079.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.start","time":2079.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":2085.199999809265},{"name":"activityTabFullyLoaded","time":2280}],"measures":[],"correlationId":"7782576c168f53","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":147,"dbReadsTimeInMs":16,"dbConnsTimeInMs":31,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-16329 Engine-independent online ALTER TABLE
MDEV-28808
Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part