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

./mtr --ps-protocol ignores transaction rollback and error during SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.31, 10.5.22, 10.6.15, 11.0.3, 11.1.2, 10.11.7
    • 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
    • Tests
    • None

    Description

      MDEV-31002 modified something in the client/mysqltest.cc test driver, to execute SELECT statements a second time in ./mtr --ps-protocol mode. This logic fails to detect that a SELECT in a multi-statement transaction returned an error and that the transaction was aborted. In such a scenario, re-issuing the SELECT statement would implicitly start a new transaction, which would lead to incorrect results.

      I see that the change set that implemented MDEV-31002 added --disable_ps2_protocol to a large number of tests. At least some of those cases seem to match this scenario. I found this bug while extending the test case innodb.lock_isolation with a test of MDEV-33802.

      Attachments

        Issue Links

          Activity

            People

              lstartseva Lena Startseva
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.