Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10974

WSREP and multi-master replication: slave threads hang waiting for WSREP ready state

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.1.17, 10.1.18
    • 10.1.22
    • Galera, Replication, wsrep
    • CentOS 7 (XenServer VM), vanilla MariaDB 10.1 RPM distribution
    • 10.1.20

    Description

      During start of MariaDB server, slave SQL threads wait for WSREP to reach ready state and only then start applying.

      With Galera Cluster and multi-master replication to it set up, multiple threads wait for the state. And then, basically, on MariaDB restarts, only one thread (seems to be more or less random) gets ready state notification. All other slave threads hang waiting (they are retrieving events to relay logs, but SQL threads are shown running and are really not applying anything, exec position does not increase). Any STOP SLAVE command or MariaDB server shutdown hangs then as well waiting for the hung slave threads to stop.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Alex/AT Alex/AT
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.