Replication breaks using XA transaction(one phase) and binlog_format=STATEMENT

[Jaime Sicam]

Tested on Percona Server 5.7.18:

Test used in https://bugs.mysql.com/bug.php?id=83295

CREATE DATABASE /*! IF NOT EXISTS*/ xatest;
USE xatest;
DROP TABLE IF EXISTS `xatest`;
CREATE TABLE `xatest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;
XA START 'xatest';
DELETE FROM xatest where id=1;
XA END 'xatest';
XA COMMIT 'xatest' ONE PHASE;

Replication error:
               Last_SQL_Error: Error 'XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state' on query. Default database: 'xatest'. Query: 'COMMIT'

[Laurynas Biveinis (laurynas-biveinis)]

Jaime, please use "Target to Series" and set individual statuses for series

[Sveta Smirnova (svetasmirnova)]

Workaround from the upstream bug report: 'And if use `XA PREPARE` (not use `ONE PHASE`), replication error not occurs."

[Sveta Smirnova (svetasmirnova)]

Upstream bug fixed in 8.0.4 and 5.7.21

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1109