Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL)
Currently next-key lock is requested only if a record is delete-marked for locking unique search in RR isolation level. There can be several delete-marked records for the same unique key, that's why InnoDB scans the records until non-delete-marked record is reached. For range scan next-key locks are used for RR to protect scanned range from inserting new records by other transactions. And this is the reason of why next-key locks are used for delete-marked records for unique searches.
If a record is not delete-marked, the requested lock type is "not-gap". When a record is not delete-marked during lock request by trx 1, and some other transaction holds conflicting lock, trx 1 creates waiting not-gap lock on the record and suspends. During trx 1 suspending the record can be delete-marked. And when the lock is granted on conflicting transaction commit or rollback, it's type is still "not-gap". So we have "not-gap" lock on delete-marked record for RR. And this let some other transaction to insert some record with the same unique key when trx 1 is not committed, what can cause isolation violation commonly, and duplicate key errors on slaves particularly, as for MDEV-30010
is blocked by
MDEV-20605
Awaken transaction can miss inserted by other transaction records due to wrong persistent cursor restoration
Closed
relates to
MDEV-30010
Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
Closed
mentioned in
Page Failed to load
Page Failed to load
Page Failed to load
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Show 33 more links (33 mentioned in)
{"report":{"fcp":1137.3000001907349,"ttfb":192.7000002861023,"pageVisibility":"visible","entityId":117668,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"dad8f213-67ef-4fba-826b-cca1f630ad42","navigationType":0,"readyForUser":1231.5,"redirectCount":0,"resourceLoadedEnd":963.4000000953674,"resourceLoadedStart":228.7000002861023,"resourceTiming":[{"duration":431.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":228.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":660.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":431.7000002861023,"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":229,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":229,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":660.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":441.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":229.2000002861023,"connectEnd":229.2000002861023,"connectStart":229.2000002861023,"domainLookupEnd":229.2000002861023,"domainLookupStart":229.2000002861023,"fetchStart":229.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":229.2000002861023,"responseEnd":670.5,"responseStart":670.5,"secureConnectionStart":229.2000002861023},{"duration":468.40000009536743,"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":229.30000019073486,"connectEnd":229.30000019073486,"connectStart":229.30000019073486,"domainLookupEnd":229.30000019073486,"domainLookupStart":229.30000019073486,"fetchStart":229.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":229.30000019073486,"responseEnd":697.7000002861023,"responseStart":697.7000002861023,"secureConnectionStart":229.30000019073486},{"duration":472.7000002861023,"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":229.5,"connectEnd":229.5,"connectStart":229.5,"domainLookupEnd":229.5,"domainLookupStart":229.5,"fetchStart":229.5,"redirectEnd":0,"redirectStart":0,"requestStart":229.5,"responseEnd":702.2000002861023,"responseStart":702.2000002861023,"secureConnectionStart":229.5},{"duration":472.80000019073486,"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":229.80000019073486,"connectEnd":229.80000019073486,"connectStart":229.80000019073486,"domainLookupEnd":229.80000019073486,"domainLookupStart":229.80000019073486,"fetchStart":229.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":229.80000019073486,"responseEnd":702.6000003814697,"responseStart":702.6000003814697,"secureConnectionStart":229.80000019073486},{"duration":473.09999990463257,"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":229.90000009536743,"connectEnd":229.90000009536743,"connectStart":229.90000009536743,"domainLookupEnd":229.90000009536743,"domainLookupStart":229.90000009536743,"fetchStart":229.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":229.90000009536743,"responseEnd":703,"responseStart":703,"secureConnectionStart":229.90000009536743},{"duration":475.19999980926514,"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":230.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":230.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":705.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":473.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":230.2000002861023,"connectEnd":230.2000002861023,"connectStart":230.2000002861023,"domainLookupEnd":230.2000002861023,"domainLookupStart":230.2000002861023,"fetchStart":230.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":230.2000002861023,"responseEnd":703.4000000953674,"responseStart":703.4000000953674,"secureConnectionStart":230.2000002861023},{"duration":475.19999980926514,"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":230.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":230.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":705.5,"responseStart":0,"secureConnectionStart":0},{"duration":473.6000003814697,"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":230.5,"connectEnd":230.5,"connectStart":230.5,"domainLookupEnd":230.5,"domainLookupStart":230.5,"fetchStart":230.5,"redirectEnd":0,"redirectStart":0,"requestStart":230.5,"responseEnd":704.1000003814697,"responseStart":704.1000003814697,"secureConnectionStart":230.5},{"duration":507.6000003814697,"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":232.5,"connectEnd":232.5,"connectStart":232.5,"domainLookupEnd":232.5,"domainLookupStart":232.5,"fetchStart":232.5,"redirectEnd":0,"redirectStart":0,"requestStart":232.5,"responseEnd":740.1000003814697,"responseStart":740.1000003814697,"secureConnectionStart":232.5},{"duration":730.7999997138977,"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":232.60000038146973,"connectEnd":232.60000038146973,"connectStart":232.60000038146973,"domainLookupEnd":232.60000038146973,"domainLookupStart":232.60000038146973,"fetchStart":232.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":232.60000038146973,"responseEnd":963.4000000953674,"responseStart":963.4000000953674,"secureConnectionStart":232.60000038146973}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":193,"responseEnd":194,"domLoading":226,"domInteractive":1297,"domContentLoadedEventStart":1297,"domContentLoadedEventEnd":1345,"domComplete":2790,"loadEventStart":2790,"loadEventEnd":2791,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1276.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1277.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1277.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":1280.4000000953674},{"name":"activityTabFullyLoaded","time":1359.3000001907349}],"measures":[],"correlationId":"7cffd53cd84f31","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":98,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Major MDEV-20605 Awaken transaction can miss inserted by other transaction records due to wrong persistent cursor restoration
Page Failed to load
Page Loading...