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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.21-20
    • Component/s: 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

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

              Dates

              • Created:
                Updated:
                Resolved: