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

          Alex/AT Could you describe the topology that you are trying out and also
          elaborate the problem (preferably with the steps to repeat the scenario)?

          nirbhay_c Nirbhay Choubey (Inactive) added a comment - Alex/AT Could you describe the topology that you are trying out and also elaborate the problem (preferably with the steps to repeat the scenario)?
          Alex/AT Alex/AT added a comment -

          Seems to be resolved in 10.1.22 with the STOP SLAVE deadlock fix.

          Alex/AT Alex/AT added a comment - Seems to be resolved in 10.1.22 with the STOP SLAVE deadlock fix.

          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.