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

DROP TABLE inconsistencies when using pseudo_slave_mode with a temporary table

    XMLWordPrintable

Details

    Description

      While MariaDB/MySQL version info is below, I set affected and fix versions to 'N/A' as it is not entirely clear what the expected outcome is. Possible regression.

      SET pseudo_slave_mode=1;
      		 
      CREATE TEMPORARY TABLE t2 (c INT) ENGINE=InnoDB;
      		 
      XA START 'x';
      		 
      XA END 'x';
      		 
      XA PREPARE 'x';
      		 
      DROP TABLE t2;

      Leads to, on MariaDB 10.5 to 10.11 to:

      CS 10.5.28 24e5d564005904bc589fc869ea2f913eec8e6c3a (Optimized)

      		 
      10.5.28-opt>DROP TABLE t2;
      		 
      Query OK, 0 rows affected (0.000 sec)

      On MariaDB 11.4 to 11.8 however we see:

      CS 11.4.5 9e7762e718b5f39bc38cebfabc3ff4cb57b1cc68 (Optimized)

      		 
      11.4.5-opt>DROP TABLE t2;
      		 
      ERROR 1051 (42S02): Unknown table 'test.t2'

      On MySQL 5.5 to 5.7 we see:

      MySQL 5.5.62 bac287c315b1792e7ae33f91add6a60292f9bae8 (Optimized)

      		 
      5.5.62-opt>DROP TABLE t2;
      		 
      ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the  PREPARED state

      And on MySQL 8.0 to 9.1 we see:

      MySQL 8.0.36 49ef33f7edadef3ae04665e73d1babd40179a4f1 (Optimized)

      		 
      8.0.36-opt>DROP TABLE t2;
      		 
      Query OK, 0 rows affected (0.00 sec)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22733 XA PREPARE breaks MDL in pseudo_slave_mode=1

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36970 Serious binglog replay data inconsistency when using XA with a temporary table

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Activity

            People

              bnestere Brandon Nesterenko
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.