Public bug reported: 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' ** Affects: mysql-server Importance: Unknown Status: Unknown ** Affects: percona-server Importance: Undecided Status: New ** Tags: i198558 ** Bug watch added: MySQL Bug System #83295 http://bugs.mysql.com/bug.php?id=83295 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=83295 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/1705151 Title: Replication breaks using XA transaction(one phase) and binlog_format=STATEMENT To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1705151/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
