enterprise-support team mailing list archive

[Jaime Sicam <1705151@xxxxxxxxxxxxxxxxxx>]

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