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

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21602 CREATE TABLE…PRIMARY KEY…SELECT workaround causes DROP TABLE to ignore locks

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-742 LP:803649 - Xa recovery failed on client disconnection

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22769 Long semaphore wait upon DROP DATABASE with XA holding locks

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 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.