Type:
Task
Priority:
Major
Resolution:
Fixed
Introduced a new wsrep_strict_ddl configuration variable in which
Galera checks storage engine of the effected table. If table is not
InnoDB (only storage engine currently fully supporting Galera
replication) DDL-statement will return error code:
ER_GALERA_REPLICATION_NOT_SUPPORTED
eng "DDL-statement is forbidden as table storage engine does not support Galera replication"
However, when wsrep_replicate_myisam=ON we allow DDL-statements to
MyISAM tables. If effected table is allowed storage engine Galera
will run normal TOI.
This new setting should be for now set globally on all
nodes in a cluster. When this setting is set following DDL-clauses
accessing tables not supporting Galera replication are refused:
CREATE TABLE (e.g. CREATE TABLE t1(a int) engine=Aria
ALTER TABLE
TRUNCATE TABLE
CREATE VIEW
CREATE TRIGGER
CREATE INDEX
DROP INDEX
RENAME TABLE
DROP TABLE
Statements on PROCEDURE, EVENT, FUNCTION are allowed as effected
tables are known only at execution. Furthermore, USER, ROLE, SERVER,
DATABASE statements are also allowed as they do not really have
effected table.
Release: 10.5.1CS
relates to
MDEV-20051
Add new mode to wsrep_OSU_method in which Galera checks storage engine of the effected table
Closed
Transition
Time In Source Status
Execution Times
Open
Closed
63d 15h 24m
1
{"report":{"fcp":813.0999999046326,"ttfb":129.5,"pageVisibility":"visible","entityId":85106,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"b8fb9a2f-43a8-4f52-8e60-1fbfe6555c67","navigationType":0,"readyForUser":866.3999998569489,"redirectCount":0,"resourceLoadedEnd":473.5,"resourceLoadedStart":148.39999985694885,"resourceTiming":[{"duration":8.900000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":148.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":148.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":157.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":9.200000047683716,"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":148.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":148.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":157.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":215.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":148.89999985694885,"connectEnd":148.89999985694885,"connectStart":148.89999985694885,"domainLookupEnd":148.89999985694885,"domainLookupStart":148.89999985694885,"fetchStart":148.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":161.09999990463257,"responseEnd":364.19999980926514,"responseStart":185.59999990463257,"secureConnectionStart":148.89999985694885},{"duration":44.90000009536743,"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":149.59999990463257,"connectEnd":149.59999990463257,"connectStart":149.59999990463257,"domainLookupEnd":149.59999990463257,"domainLookupStart":149.59999990463257,"fetchStart":149.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":164.29999995231628,"responseEnd":194.5,"responseStart":188.39999985694885,"secureConnectionStart":149.59999990463257},{"duration":323.90000009536743,"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":149.59999990463257,"connectEnd":149.59999990463257,"connectStart":149.59999990463257,"domainLookupEnd":149.59999990463257,"domainLookupStart":149.59999990463257,"fetchStart":149.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":163.5,"responseEnd":473.5,"responseStart":186.69999980926514,"secureConnectionStart":149.59999990463257},{"duration":47.200000047683716,"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":149.79999995231628,"connectEnd":149.79999995231628,"connectStart":149.79999995231628,"domainLookupEnd":149.79999995231628,"domainLookupStart":149.79999995231628,"fetchStart":149.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":164.59999990463257,"responseEnd":197,"responseStart":190.5,"secureConnectionStart":149.79999995231628},{"duration":47.89999985694885,"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":149.79999995231628,"connectEnd":149.79999995231628,"connectStart":149.79999995231628,"domainLookupEnd":149.79999995231628,"domainLookupStart":149.79999995231628,"fetchStart":149.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":165.39999985694885,"responseEnd":197.69999980926514,"responseStart":191.89999985694885,"secureConnectionStart":149.79999995231628},{"duration":13.399999856948853,"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":150,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":150,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":163.39999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":48.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":150,"connectEnd":150,"connectStart":150,"domainLookupEnd":150,"domainLookupStart":150,"fetchStart":150,"redirectEnd":0,"redirectStart":0,"requestStart":165.79999995231628,"responseEnd":198.39999985694885,"responseStart":193.59999990463257,"secureConnectionStart":150},{"duration":18.40000009536743,"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":150.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":150.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":168.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":52.60000014305115,"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":150.19999980926514,"connectEnd":150.19999980926514,"connectStart":150.19999980926514,"domainLookupEnd":150.19999980926514,"domainLookupStart":150.19999980926514,"fetchStart":150.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":173.89999985694885,"responseEnd":202.79999995231628,"responseStart":199.89999985694885,"secureConnectionStart":150.19999980926514},{"duration":280.39999985694885,"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":178.79999995231628,"connectEnd":178.79999995231628,"connectStart":178.79999995231628,"domainLookupEnd":178.79999995231628,"domainLookupStart":178.79999995231628,"fetchStart":178.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":195.89999985694885,"responseEnd":459.19999980926514,"responseStart":455.2999999523163,"secureConnectionStart":178.79999995231628},{"duration":280.5,"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":178.89999985694885,"connectEnd":178.89999985694885,"connectStart":178.89999985694885,"domainLookupEnd":178.89999985694885,"domainLookupStart":178.89999985694885,"fetchStart":178.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":198.09999990463257,"responseEnd":459.39999985694885,"responseStart":457.09999990463257,"secureConnectionStart":178.89999985694885},{"duration":208.10000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":577.1999998092651,"connectEnd":577.1999998092651,"connectStart":577.1999998092651,"domainLookupEnd":577.1999998092651,"domainLookupStart":577.1999998092651,"fetchStart":577.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":756.2999999523163,"responseEnd":785.2999999523163,"responseStart":783.7999999523163,"secureConnectionStart":577.1999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":2,"responseStart":129,"responseEnd":178,"domLoading":133,"domInteractive":914,"domContentLoadedEventStart":914,"domContentLoadedEventEnd":954,"domComplete":1519,"loadEventStart":1519,"loadEventEnd":1519,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":896.0999999046326},{"name":"bigPipe.sidebar-id.end","time":896.8999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":897},{"name":"bigPipe.activity-panel-pipe-id.end","time":898.0999999046326},{"name":"activityTabFullyLoaded","time":970}],"measures":[],"correlationId":"9e7e938e9a3d76","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}