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

XA PREPARE breaks MDL in pseudo_slave_mode=1

    XMLWordPrintable

Details

    Description

      USE test;
      CREATE TABLE t(a INT);
      XA START '0';
      SET pseudo_slave_mode=1;
      INSERT INTO t VALUES(7050+0.75);
      XA PREPARE '0';
      XA END '0';
      XA PREPARE '0';
      TRUNCATE TABLE t;
      # Shutdown to observe hang (mysqladmin shutdown will hang)
      

      Will cause 10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24 (dbg+opt) to hang. Earlier releases not affected.

      Note the difference on the last command:

      10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24

      10.5.4>TRUNCATE TABLE t;
      Query OK, 0 rows affected (0.013 sec)
      

      10.4.14 ea7830eef48333e28f98a9b91f05a95735b465a3

      10.4.14>TRUNCATE TABLE t;
      ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the  PREPARED state
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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