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

Implicit rollback by LOAD INDEX or CACHE INDEX should not touch prepared user XA

    XMLWordPrintable

Details

    Description

      Elaborated MDEV-32347 description test demonstrates how a prepared user XA transaction
      gets rolled back:

      CREATE TABLE ti (c INT KEY) engine=Innodb;
      		 
      XA START 'xid_i';
      		 
      INSERT INTO ti VALUES (1);
      		 
      XA END 'xid_i';
      		 
      XA PREPARE 'xid_i';
      		 
       
      		 
      # --error ER_XAER_RMFAIL
      		 
      LOAD INDEX INTO CACHE c KEY(PRIMARY);
      		 
       
      		 
      XA COMMIT 'xid_i';
      		 
       
      		 
      SELECT count(*) = 1 FROM ti;
      		 
      # => 0 (sic!)

      LOAD INDEX INTO CACHE and CACHE INDEX ... must also error out which is not done (by at least LOAD INDEX) either.

      No other sql commands, form either DML:s or DDL:s class, are found to produce similar effect.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31949 slow parallel replication of user xa

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32347 Stack smashing/looping, ASAN use-after-poison in xid_t::eq/event_xid_t::serialize, SIGSEGV in serialize_xid and Assertion `is_async_xac || thd->lex->xid->eq(thd->transaction->xid_state.get_xid())' failed in binlog_rollback_flush_trx_cache upon LOAD INDEX

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

          Activity

            People

              Unassigned Unassigned
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.