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

    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:

                Smart Checklist