[MDEV-21659] XA rollback 'foreign_xid' is allowed inside active XA Created: 2020-02-04  Updated: 2020-03-10  Resolved: 2020-03-10

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.5.2

Type: Bug Priority: Critical
Reporter: Andrei Elkin Assignee: Andrei Elkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-742 LP:803649 - Xa recovery failed on cli... Closed

 Description   

--connection crash_me
CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;

  1. prepare a future foreign xid
    xa start '1'; insert into t1 set pk=1; xa end '1'; xa prepare '1'; 

    # KILL server_process & restart
    		 
    xa recover; # =>
    		 
    +----------+--------------+--------------+------+
    		 
    | formatID | gtrid_length | bqual_length | data |
    		 
    +----------+--------------+--------------+------+
    		 
    |        1 |            1 |            0 | 1    |
    		 
    +----------+--------------+--------------+------+
    		 
     
    		 
    --connection default
    		 
    xa start '2';
    		 
    --error 0
    		 
    xa rollback '1' .


Generated at Thu Feb 08 09:08:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.