Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1109

LP #1705151: Replication breaks using XA transaction(one phase) and binlog_format=STATEMENT

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 5.7.21-20
    • 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'

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist