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

Smartrouter interrupts the wrong query

    XMLWordPrintable

Details

    • MXS-SPRINT-167, MXS-SPRINT-168, MXS-SPRINT-169

    Description

      If two queries with different canonical query forms (e.g. SELECT user FROM t1 and SELECT host FROM t1) are executed back to back and the first query triggers a latency measurement, the second query can end up being interrupted if it ends up being executed on the server that is measured to be the slower server.

      This happens because the KILL QUERY command that is used to interrupt the slower servers is not executed synchronously and just waiting for all the results to complete is not enough: the KILL commands must also complete before new queries should be allowed.

      Original description:


      The test appears to fail with:

      214: 07:45:01   2.1s: TEST_FAILED! Thread 7 failed to SELECT: Query execution was interrupted
      

      The query should never get interrupted which means an error leaks to the client that it shouldn't see.

      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.