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

Transaction replay may deadlock with switchover

Details

    Description

      This happens if mariadbmon does a switchover while readwritesplit is replaying a transaction on the server being demoted. As the switchover removes the Master label from the demotion target before putting it into read-only mode, a deadlock occurs where the monitor waits for the SET GLOBAL read_only=1 to complete which is blocked by the earlier transaction that readwritesplit has open. The transaction in readwriteplit in turn is waiting for a server with a Master label to appear and thus a deadlock is formed that'll be resolved once the transaction replay times out.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            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.