Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1999

LP #1710585: DDL stuck in "checking permissions" and cluster gets locked

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Grigorijs last update 27-10-2017 10:44:26

      Got situation that DDL operation on one of the cluster's node (with TOI OSU) hang in "checking permissions" state. With that also all cluster was locked (due to TOI).

      Problem seems to be occasional and random (as this operations normally execute successfully) - so it looks really as some bug (maybe some wrong mutex in checking permissions operations).

      Kill operation on stuck thread gives nothing, the only way to get cluster back to operation is to hard reset problematic node.

      Software version:
      ii percona-xtradb-cluster-57 5.7.18-29.20-1.jessie amd64 Percona XtraDB Cluster with Galera

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                lalit.choudhary Lalit Choudhary
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: