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

After "stop slave" times out, check replication status with "show slave status"

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 23.02.14
    • None
    • mariadbmon
    • None

    Description

      When executing "stop slave" with semisync replication, the replica server will tell the primary server that it's stopping replication. If the primary is down, this part can stall (even though this stall should be limited by rpl_semi_sync_slave_kill_conn_timeout). Other possible reasons for stalling could be an ongoing backup or FTWRL.

      In some cases, this has caused MariaDB Monitor switchover/failover to time out. To deal with this, the monitor should check replication status with "show all slaves status" after "stop slave" has timed out. If replication status shows that slave threads have stopped, failover/switchover can proceeed.

      Attachments

        Activity

          People

            esa.korhonen Esa Korhonen
            esa.korhonen Esa Korhonen
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.