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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.15
    • Fix Version/s: 2.5.17
    • Component/s: readwritesplit
    • Labels:
      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

            Assignee:
            markus makela markus makela
            Reporter:
            kjoiner Kyle Joiner
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration