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

              Assignee:
              elenst Elena Stepanova
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: