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

Read-only transaction are not synchronized by causal_reads=universal

    XMLWordPrintable

    Details

      Description

      The fix to MXS-4260 broke causal_reads=universal in a way that now makes it ineffective when read-only transactions are open.

      The synchronization query is treated as being a part of the read-only transaction and it ends up being routed "correctly" to the server that's executing the read-only transaction. The GTID synchronization query relies on the routing hint taking precedence over the normal transaction handling logic which previously caused the query to be routed to the currently selected master server. This change won't cause visible problems apart from a lack of synchronization but it will cause a debug assertion to be hit if the current master server fails during the sync query.

        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.