Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11 , 11.0(EOL) , 11.1(EOL)
When replicating an XA transaction, if the body of the transaction (XA START through XA PREPARE) runs into an error, but that error is in skip-slave-errors, it won't be be binlogged. The corresponding XA COMMIT, however, will be binlogged without error, leading to an invalid binary log. The following MTR test snippet highlights this:
config file: rpl_bug.cnf
!include ../my.cnf
[mysqld.2]
slave-skip-errors=1032
innodb
log-slave-updates
[mysqld.3]
innodb
[ENV]
SERVER_MYPORT_1= @mysqld.1.port
SERVER_MYPORT_2= @mysqld.2.port
SERVER_MYPORT_3= @mysqld.3.port
mtr file: rpl_bug.test
--source include/have_innodb.inc
--source include/have_binlog_format_row.inc
--let $rpl_server_count= 3
--let $rpl_topology= 1->2->3
--source include/rpl_init.inc
--echo #
--echo # Initialize test data
--connection server_1
create table t1 (a int) engine=innodb;
insert into t1 values (1);
insert into t1 values (2);
--source include/save_master_gtid.inc
--connection server_2
--source include/sync_with_master_gtid.inc
--connection server_2
set statement SQL_LOG_BIN=0 FOR delete from t1 where a=1;
--connection server_1
xa start '1';
update t1 set a=3 where a=1;
xa end '1';
xa prepare '1';
xa commit '1';
--source include/save_master_gtid.inc
--connection server_3
--let $slave_sql_errno=1397
--source include/wait_for_slave_sql_error.inc
--die Hit Error 'XAER_NOTA: Unknown XID' on query
--echo #
--echo # Cleanup
--connection server_1
DROP TABLE t1;
--source include/save_master_gtid.inc
--connection server_2
--source include/sync_with_master_gtid.inc
--source include/rpl_end.inc
--echo # End of tests
relates to
MDEV-25616
Binlog event for XA COMMIT is generated without matching XA START, replication aborts
Closed
No workflow transitions have been executed yet.
{"report":{"fcp":864.9000000953674,"ttfb":263.5,"pageVisibility":"visible","entityId":123872,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"fa7d7f18-1217-4382-bf47-ad8af83cfdf4","navigationType":0,"readyForUser":932.8000001907349,"redirectCount":0,"resourceLoadedEnd":829.8000001907349,"resourceLoadedStart":284.2000000476837,"resourceTiming":[{"duration":52.700000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":284.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":336.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":52.799999952316284,"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":284.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":337.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":125.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":284.5,"connectEnd":284.5,"connectStart":284.5,"domainLookupEnd":284.5,"domainLookupStart":284.5,"fetchStart":284.5,"redirectEnd":0,"redirectStart":0,"requestStart":284.5,"responseEnd":409.7000000476837,"responseStart":409.7000000476837,"secureConnectionStart":284.5},{"duration":199.60000014305115,"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":284.7000000476837,"connectEnd":284.7000000476837,"connectStart":284.7000000476837,"domainLookupEnd":284.7000000476837,"domainLookupStart":284.7000000476837,"fetchStart":284.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":284.7000000476837,"responseEnd":484.30000019073486,"responseStart":484.30000019073486,"secureConnectionStart":284.7000000476837},{"duration":196.10000014305115,"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":284.7000000476837,"connectEnd":284.7000000476837,"connectStart":284.7000000476837,"domainLookupEnd":284.7000000476837,"domainLookupStart":284.7000000476837,"fetchStart":284.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":284.7000000476837,"responseEnd":480.80000019073486,"responseStart":480.80000019073486,"secureConnectionStart":284.7000000476837},{"duration":200.29999995231628,"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":284.80000019073486,"connectEnd":284.80000019073486,"connectStart":284.80000019073486,"domainLookupEnd":284.80000019073486,"domainLookupStart":284.80000019073486,"fetchStart":284.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":284.80000019073486,"responseEnd":485.10000014305115,"responseStart":485.10000014305115,"secureConnectionStart":284.80000019073486},{"duration":200.70000004768372,"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":284.90000009536743,"connectEnd":284.90000009536743,"connectStart":284.90000009536743,"domainLookupEnd":284.90000009536743,"domainLookupStart":284.90000009536743,"fetchStart":284.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":284.90000009536743,"responseEnd":485.60000014305115,"responseStart":485.60000014305115,"secureConnectionStart":284.90000009536743},{"duration":201.09999990463257,"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":285.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":486.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":201,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":285.2000000476837,"connectEnd":285.2000000476837,"connectStart":285.2000000476837,"domainLookupEnd":285.2000000476837,"domainLookupStart":285.2000000476837,"fetchStart":285.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":285.2000000476837,"responseEnd":486.2000000476837,"responseStart":486.2000000476837,"secureConnectionStart":285.2000000476837},{"duration":201.5,"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":285.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":486.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":201.5,"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":285.40000009536743,"connectEnd":285.40000009536743,"connectStart":285.40000009536743,"domainLookupEnd":285.40000009536743,"domainLookupStart":285.40000009536743,"fetchStart":285.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":285.40000009536743,"responseEnd":486.90000009536743,"responseStart":486.90000009536743,"secureConnectionStart":285.40000009536743},{"duration":356.60000014305115,"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":286.2000000476837,"connectEnd":286.2000000476837,"connectStart":286.2000000476837,"domainLookupEnd":286.2000000476837,"domainLookupStart":286.2000000476837,"fetchStart":286.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":286.2000000476837,"responseEnd":642.8000001907349,"responseStart":642.8000001907349,"secureConnectionStart":286.2000000476837},{"duration":543.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":286.30000019073486,"connectEnd":286.30000019073486,"connectStart":286.30000019073486,"domainLookupEnd":286.30000019073486,"domainLookupStart":286.30000019073486,"fetchStart":286.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":286.30000019073486,"responseEnd":829.8000001907349,"responseStart":829.8000001907349,"secureConnectionStart":286.30000019073486},{"duration":172.10000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":621.5,"connectEnd":621.5,"connectStart":621.5,"domainLookupEnd":621.5,"domainLookupStart":621.5,"fetchStart":621.5,"redirectEnd":0,"redirectStart":0,"requestStart":621.5,"responseEnd":793.6000001430511,"responseStart":793.6000001430511,"secureConnectionStart":621.5},{"duration":74.29999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":806.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":806.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":881.1000001430511,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":122,"responseStart":263,"responseEnd":264,"domLoading":281,"domInteractive":985,"domContentLoadedEventStart":985,"domContentLoadedEventEnd":1017,"domComplete":1208,"loadEventStart":1208,"loadEventEnd":1208,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":971.8000001907349},{"name":"bigPipe.sidebar-id.end","time":972.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":972.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":973.1000001430511},{"name":"activityTabFullyLoaded","time":1026.2000000476837}],"measures":[],"correlationId":"86b78e56d73f83","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":81,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}