Issues with prepared XA transactions

Description

Test case:

 

often fails due to MySQL unable to start with following error:

 

Note that RocksDB engine needs to be enabled, otherwise MySQL starts successfully.

Test bug1254227.sh doesn't fail, mysql rolls back XA transaction on startup.

xtrabackup is missing following patch which used to rollback XA transactions in previous versions:

 

If we put that patch back everything becomes OK with InnoDB. This however needs to be tested with transactions involving both RocksDB and InnoDB.

Also, considering out approach to RocksDB backup we won't be able to rollback prepared XA transactions in RocksDB. Workaround I have found for rocksdb is to copy MySQL binary log to the backup directory.

Environment

None

blocks

Smart Checklist

Activity

Show:

Manish Chawla January 28, 2019 at 7:57 AM

Ran an incremental backup restore when the following sql were running:

PS8.0.13-3 failed to come up after restore. The logs displayed:

PXB8 incremental prepare display in the end:

Done

Details

Assignee

Reporter

Time tracking

1w 2d 1h 45m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created January 27, 2019 at 9:21 PM
Updated March 6, 2024 at 7:20 PM
Resolved February 6, 2019 at 9:59 AM