Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3959

Transaction replay doesn't reset transaction on implicit commit

    XMLWordPrintable

Details

    Description

      When transaction_replay is enabled, the following transaction is not treated as two separate transactions but one big transaction:

      CREATE TABLE test.t1(id INT);
      BEGIN;
      INSERT INTO test.t1 VALUES (1);
      BEGIN;
      INSERT INTO test.t1 VALUES (2);
      -- Transaction is replayed here
      COMMIT;
       
      -- This will return three rows
      SELECT * FROM test.t1;
      

      If the transaction ends up being replayed after the second transaction has started, the first transaction will be executed twice and you'll end up with three rows in the table instead of two.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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