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

SQL ADMIN command execution can cause deadlock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.7.23-31.31
    • Fix Version/s: 5.6.45-28.36, 5.7.27-31.39
    • Component/s: None
    • Labels:
      None

      Description

      • ADMIN command like OPTIMIZE etc... can cause complete cluster stall.
      • MySQL may decide to run OPTIMIZE with table re-creation (InnoDB approach).  Table-recreation is internal so the binlog is turned off. Changes done by upstream to fix another bug also caused this binlog turn off action to turn off wsrep_on = off this means OPTIMIZE (DDL statement running under TOI mode) can't brute force abort the local running transaction. This eventually breaks consistency semantics and leads to a deadlock.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              krunal.bauskar Krunal Bauskar (Inactive)
              Reporter:
              krunal.bauskar Krunal Bauskar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 6 hours, 15 minutes
                  6h 15m