Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14609

XA Transction unable to ROLLBACK TO SAVEPOINT

Details

    • 5.5.59

    Description

      It appears it's not possible to restore to an savepoint within in a XA transaction

      create table t1(
      	c1 int
      ) engine=innodb;
       
      XA START 'xa1';
      SAVEPOINT savepoint1;
      INSERT INTO t1 (c1) VALUES (1),(2),(3),(4);
       
      ROLLBACK TO SAVEPOINT savepoint1;
      

      this gives error:
      Error Code: 1399. XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state

      When i try the exact same query in mysql (5.7), this produces no errors, also the transaction is restored to the actual savepoint.
      When savepoints wouldn't be supported in XA transactions, i would expect the SAVEPOINT x would already result in an error.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            2d 9h 40m 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            32d 14h 13m 1
            Alexander Barkov made transition -
            In Progress Closed
            2d 20h 28m 1

            People

              bar Alexander Barkov
              olafbuitelaar Olaf Buitelaar
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.