[MDEV-7974] backport fix for mysql bug#12161 (XA and binlog) Created: 2015-04-10  Updated: 2020-03-16  Resolved: 2019-06-20

Status: Closed
Project: MariaDB Server
Component/s: Replication, Server, XA
Fix Version/s: 10.5.2

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Andrei Elkin
Resolution: Duplicate Votes: 4
Labels: upstream-fixed

Issue Links:
Blocks
Duplicate
duplicates MDEV-742 LP:803649 - Xa recovery failed on cli... Closed
Relates
relates to MDEV-20316 InnoDB writes uninitialised tail of X... Closed

 Description   

5.7 finally fixes the 10-yr-old bug#12161 — a.k.a. prepared XA transactions are lost on disconnect. They solved it by introducing a new XA_prepare_log_event. As we'll need to be able to read this event, we can as well merge the whole fix for this bug.



 Comments   
Comment by Elena Stepanova [ 2017-01-24 ]

Is it still possible to do it in 10.2? I'll set it to 10.2-ga to get on the radar, but feel free to unset if it can't be done.

Comment by Marko Mäkelä [ 2018-07-30 ]

MySQL 5.7.23 contains a follow-up fix to Bug#12161:
Bug#27442477 ASSERT `THD->GET_HA_DATA...HAS_STATE(XID_STATE::XA_ACTIVE))' AT HANDLER.CC:1396

Comment by Andrei Elkin [ 2018-11-28 ]

Sent my comments to Alexey.

Comment by Alexey Botchkov [ 2019-02-14 ]

http://lists.askmonty.org/pipermail/commits/2019-February/013412.html

Comment by Alexey Botchkov [ 2019-02-17 ]

patch update
http://lists.askmonty.org/pipermail/commits/2019-February/013425.html

Comment by Alexey Botchkov [ 2019-02-21 ]

patch update #2
http://lists.askmonty.org/pipermail/commits/2019-February/013454.html

Comment by Andrei Elkin [ 2019-03-14 ]

The latest patch needed more work. I am waiting for a next one.

Comment by Alexey Botchkov [ 2019-03-20 ]

http://lists.askmonty.org/pipermail/commits/2019-March/013578.html

Pushed to the bb-hf-mdev7974 branch.

Comment by Marko Mäkelä [ 2019-06-19 ]

We should consider porting a related fix from MySQL 5.7:
BUG#25082593 FOREIGN KEY VALIDATION DOESN'T NEED TO ACQUIRE GAP LOCK IN READ COMMITTED

Comment by Andrei Elkin [ 2019-06-20 ]

The issue duplicates an earlier reported MDEV-742. This one is closed in favor to proceed with the work in the latter one.

Generated at Thu Feb 08 07:23:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.