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
-