Type:
Priority:
Resolution:
Fixed
Affects Version/s:
None
When a galera node is a replica of an upstream cluster it is impossible to enable optimistic replication, because the expected conflicts that stem from this replication mode will cause galera code to immediately abort replication.
2023-05-17 13:57:20 6930586 [Note] WSREP: ha_rollback_trans(6930586) rolled back: Deadlock found when trying to get lock; try restarting transaction; is_real 0
2023-05-17 13:57:20 6930586 [Note] WSREP: ha_rollback_trans(6930586) rolled back: Deadlock found when trying to get lock; try restarting transaction; is_real 1
2023-05-17 13:57:20 6930586 [Note] WSREP: SQL apply failed, res 149 conflict state: aborted
2023-05-17 13:57:20 6930586 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 0-8174-126467367555, Internal MariaDB error code: 1047
relates to
MDEV-10962
Deadlock with 3 concurrent DELETEs by unique key
Closed
made changes -
2023-05-18 06:53
Field
Original Value
New Value
Fix Version/s
10.4
[ 23604
]
Fix Version/s
10.5
[ 23608
]
Fix Version/s
10.6
[ 24027
]
made changes -
2023-05-23 14:28
Fix Version/s
10.4
[ 23604
]
Fix Version/s
10.6
[ 24027
]
made changes -
2023-05-24 15:45
Assignee
Ramesh Sivaraman
[ JIRAUSER48189
]
made changes -
2023-05-25 07:23
Assignee
Ramesh Sivaraman
[ JIRAUSER48189
]
Julius Goryavsky
[ sysprg
]
made changes -
2023-05-25 07:24
Status
Open
[ 1
]
Confirmed
[ 10101
]
made changes -
2023-06-06 12:17
Status
Confirmed
[ 10101
]
In Progress
[ 3
]
made changes -
2023-06-27 12:25
Assignee
Julius Goryavsky
[ sysprg
]
Seppo Jaakola
[ seppo
]
made changes -
2023-06-28 07:39
Link
This issue duplicates MENT-1822
[ MENT-1822
]
made changes -
2023-08-03 08:54
Component/s
Galera
[ 10124
]
Component/s
Replication
[ 10100
]
Component/s
Galera
[ 14918
]
Component/s
Replication
[ 14976
]
Fix Version/s
10.5
[ 23123
]
Fix Version/s
10.5
[ 23608
]
Key
MENT-1815
MDEV-31833
Affects Version/s
10.5.19-14
[ 28546
]
Project
MariaDB Enterprise
[ 11500
]
MariaDB Server
[ 10000
]
made changes -
2023-08-07 10:25
Status
In Progress
[ 3
]
Stalled
[ 10000
]
made changes -
2023-08-07 10:27
Status
Stalled
[ 10000
]
In Testing
[ 10301
]
made changes -
2023-08-08 11:19
Status
In Testing
[ 10301
]
Stalled
[ 10000
]
made changes -
2023-08-08 11:19
Status
Stalled
[ 10000
]
In Review
[ 10002
]
made changes -
2023-08-16 12:40
Assignee
Seppo Jaakola
[ seppo
]
Julius Goryavsky
[ sysprg
]
made changes -
2023-09-12 02:18
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2023-09-12 02:18
Status
Stalled
[ 10000
]
In Progress
[ 3
]
made changes -
2023-09-12 11:46
issue.field.resolutiondate
2023-09-12 11:46:43.0
2023-09-12 11:46:43.464
made changes -
2023-09-12 11:46
Fix Version/s
10.5.23
[ 29012
]
Fix Version/s
10.6.16
[ 29014
]
Fix Version/s
10.10.7
[ 29018
]
Fix Version/s
10.11.6
[ 29020
]
Fix Version/s
11.0.4
[ 29021
]
Fix Version/s
11.1.3
[ 29023
]
Fix Version/s
11.2.2
[ 29035
]
Fix Version/s
11.3.0
[ 29302
]
Fix Version/s
10.5
[ 23123
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
made changes -
2023-09-14 07:50
Fix Version/s
11.2.2
[ 29035
]
Fix Version/s
11.3.0
[ 29302
]
made changes -
2024-07-04 00:58
Zendesk Related Tickets
196297 201692 185636
Zendesk active tickets
201692
{"report":{"fcp":1421.5999999046326,"ttfb":432.59999990463257,"pageVisibility":"visible","entityId":121931,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"a3db3a7e-1e41-475c-939e-5ce99dcd214d","navigationType":0,"readyForUser":1503.6999998092651,"redirectCount":0,"resourceLoadedEnd":1245,"resourceLoadedStart":438.40000009536743,"resourceTiming":[{"duration":446.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":438.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":438.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":885.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":448.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":438.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":438.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":886.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":456.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":438.90000009536743,"connectEnd":438.90000009536743,"connectStart":438.90000009536743,"domainLookupEnd":438.90000009536743,"domainLookupStart":438.90000009536743,"fetchStart":438.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":438.90000009536743,"responseEnd":895.1999998092651,"responseStart":895.1999998092651,"secureConnectionStart":438.90000009536743},{"duration":524.6999998092651,"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":439.09999990463257,"connectEnd":439.09999990463257,"connectStart":439.09999990463257,"domainLookupEnd":439.09999990463257,"domainLookupStart":439.09999990463257,"fetchStart":439.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":439.09999990463257,"responseEnd":963.7999997138977,"responseStart":963.7999997138977,"secureConnectionStart":439.09999990463257},{"duration":528.2000002861023,"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":439.2999997138977,"connectEnd":439.2999997138977,"connectStart":439.2999997138977,"domainLookupEnd":439.2999997138977,"domainLookupStart":439.2999997138977,"fetchStart":439.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":439.2999997138977,"responseEnd":967.5,"responseStart":967.5,"secureConnectionStart":439.2999997138977},{"duration":528.5,"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":439.5,"connectEnd":439.5,"connectStart":439.5,"domainLookupEnd":439.5,"domainLookupStart":439.5,"fetchStart":439.5,"redirectEnd":0,"redirectStart":0,"requestStart":439.5,"responseEnd":968,"responseStart":968,"secureConnectionStart":439.5},{"duration":528.5999999046326,"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":439.69999980926514,"connectEnd":439.69999980926514,"connectStart":439.69999980926514,"domainLookupEnd":439.69999980926514,"domainLookupStart":439.69999980926514,"fetchStart":439.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":439.69999980926514,"responseEnd":968.2999997138977,"responseStart":968.2999997138977,"secureConnectionStart":439.69999980926514},{"duration":613.0999999046326,"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":439.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":439.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1053,"responseStart":0,"secureConnectionStart":0},{"duration":528.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":440.09999990463257,"connectEnd":440.09999990463257,"connectStart":440.09999990463257,"domainLookupEnd":440.09999990463257,"domainLookupStart":440.09999990463257,"fetchStart":440.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":440.09999990463257,"responseEnd":968.7999997138977,"responseStart":968.7999997138977,"secureConnectionStart":440.09999990463257},{"duration":613.0999999046326,"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":440.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":440.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1053.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":529,"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":440.40000009536743,"connectEnd":440.40000009536743,"connectStart":440.40000009536743,"domainLookupEnd":440.40000009536743,"domainLookupStart":440.40000009536743,"fetchStart":440.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":440.40000009536743,"responseEnd":969.4000000953674,"responseStart":969.2999997138977,"secureConnectionStart":440.40000009536743},{"duration":669.7000002861023,"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":441.19999980926514,"connectEnd":441.19999980926514,"connectStart":441.19999980926514,"domainLookupEnd":441.19999980926514,"domainLookupStart":441.19999980926514,"fetchStart":441.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":441.19999980926514,"responseEnd":1110.9000000953674,"responseStart":1110.9000000953674,"secureConnectionStart":441.19999980926514},{"duration":798.5999999046326,"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":446.40000009536743,"connectEnd":446.40000009536743,"connectStart":446.40000009536743,"domainLookupEnd":446.40000009536743,"domainLookupStart":446.40000009536743,"fetchStart":446.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":446.40000009536743,"responseEnd":1245,"responseStart":1244.9000000953674,"secureConnectionStart":446.40000009536743},{"duration":68.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1095.5,"connectEnd":1095.5,"connectStart":1095.5,"domainLookupEnd":1095.5,"domainLookupStart":1095.5,"fetchStart":1095.5,"redirectEnd":0,"redirectStart":0,"requestStart":1095.5,"responseEnd":1164.0999999046326,"responseStart":1164.0999999046326,"secureConnectionStart":1095.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":152,"responseStart":432,"responseEnd":443,"domLoading":436,"domInteractive":1589,"domContentLoadedEventStart":1589,"domContentLoadedEventEnd":1658,"domComplete":2214,"loadEventStart":2214,"loadEventEnd":2214,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1548.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1549.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1549.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1558.2999997138977},{"name":"activityTabFullyLoaded","time":1719.6999998092651}],"measures":[],"correlationId":"f3035eb97707b0","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":221,"dbReadsTimeInMs":39,"dbConnsTimeInMs":51,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
It looks that the error returned from optimistic async replication applying conflicts is treated as galera cluster failure. The failure should instead be returned to optimistic replication control, where retrying should be handled. I will prepare a pull request for refactoring this failure handling.