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.

        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

                  Smart Checklist