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

session_track_trx_state set to true causes incorrect routing of SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.5.15
    • 2.5.17
    • readwritesplit
    • None

    Description

      Any of the following conditions inside a transaction can cause the following SELECT to return the incorrect value:

      Client connects to maxscale, which is configured with session_track_trx_state = TRUE
      Client issues `set autocommit=0;`
      Client performs an insert via an `INSERT... RETURNING` statement

      The failing action is the next one, namely:

      Client performs a SELECT operation immediately after the `INSERT... RETURNING` statement which involves data from the previously inserted row

      Attachments

        Activity

          People

            markus makela markus makela
            kjoiner Kyle Joiner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.