Bug #87560 XA PREPARE log order error in replication and binlog recovery

• Submitted: 28 Aug 2017 9:14
• Modified: 13 Dec 2017 7:44
• Reporter: Wei Zhao (OCA)
• Status: Verified
• Category: MySQL Server: XA transactions
• Severity: S2 (Serious)
• Version: mysql-5.7.17
• OS: Any
• CPU Architecture: Any
• Tags: binlog, recovery, replication, xa

[17 Nov 2017 1:57] Wei Zhao

adding the patch as contribution

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: xa_prepare_swap_order.diff (application/octet-stream, text), 3.22 KiB.

[17 Nov 2017 1:58] Wei Zhao

adding the patch as contribution

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: recover_xa_trx_in_binlog_recovery.diff (application/octet-stream, text), 8.84 KiB.

[14 Dec 2017 1:53] Wei Zhao

this patch fixes the 'XA COMMIT ... ONE PHASE' bug I appended above.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: xa_cop_swap_order.diff (application/octet-stream, text), 2.04 KiB.

[14 Dec 2017 6:21] Wei Zhao

This patch has to be applied after applying the 'recover_xa_trx_in_binlog_recovery.diff' patch I submitted earlier. 

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: xa_cop_recovery.diff (application/octet-stream, text), 1.94 KiB.