Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2(EOL), 10.6
-
None
Description
The following test returns an error for the first XA ROLLBACK statement. I think that at least starting with 10.5 (thanks to the changes of MDEV-742) it should be possible to detach the transaction from the original connection and allow another connection to execute the XA COMMIT or XA ROLLBACK.
--source include/have_innodb.inc
|
create table test(x int) engine=innodb; |
xa start 0x01,0x01,0x01;
|
insert into test(x) values (1); |
xa end 0x01,0x01,0x01; |
xa prepare 0x01,0x01,0x01; |
xa recover;
|
connect other,localhost,root,,; |
xa recover;
|
--error ER_XAER_NOTA
|
xa rollback 0x01,0x01,0x01; |
disconnect other;
|
connection default; |
xa rollback 0x01,0x01,0x01; |
drop table test; |
Note: XA RECOVER will list the transaction to both connections.
Attachments
Issue Links
- relates to
-
MDEV-742 LP:803649 - Xa recovery failed on client disconnection
-
- Closed
-
Still repeatable with 10.6.13 build from current GitHb sources, just in case:
Yuliyas-Air:mysql-test Valerii$ ./mtr --suite=innodb MDEV-25055Logging: ./mtr --suite=innodb MDEV-25055VS config:vardir: /Users/Valerii/dbs/maria10.6/mysql-test/varChecking leftover processes...Removing old var directory...Creating var directory '/Users/Valerii/dbs/maria10.6/mysql-test/var'...Checking supported features...MariaDB Version 10.6.13-MariaDB- SSL connections supportedCollecting tests...Installing system database...==============================================================================TEST RESULT TIME (ms) or COMMENT--------------------------------------------------------------------------worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019create table test(x int) engine=innodb;xa start 0x01,0x01,0x01;insert into test(x) values (1);xa end 0x01,0x01,0x01;xa prepare 0x01,0x01,0x01;xa recover;formatID gtrid_length bqual_length data1 1 1connect other,localhost,root,,;xa recover;formatID gtrid_length bqual_length data1 1 1xa rollback 0x01,0x01,0x01;ERROR XAE04: XAER_NOTA: Unknown XIDdisconnect other;connection default;xa rollback 0x01,0x01,0x01;drop table test;innodb.MDEV-25055 'innodb' [ pass ] 41--------------------------------------------------------------------------The servers were restarted 0 timesSpent 0.041 of 18 seconds executing testcasesCompleted: All 1 tests were successful.