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

            Assignee:
            markus makela markus makela
            Reporter:
            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.