Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
None
-
None
Description
**Reported in Launchpad by Jaime Sicam last update 02-10-2017 14:08:12
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'