Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5824

MTS STOP SLAVE takes over a minute when master crashed during event logging

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.26-29, 8.0.16-7, Not 5.6.x
    • Fix Version/s: 8.0.17-8, 5.7.28-31
    • Component/s: None

      Description

      After a master crashes during binlogging replication event, where the slave already started to copy it to it's relay log, but didn't finish, a STOP SLAVE on such multi-threaded slave takes longer then expected.
      In the test case below, it takes over one minute. That long delay may be a problem for failover automation scripts.
      The issue does not happen when slave_parallel_workers=0.

      Fully reproducible test case available in the upstream report for the same issue: https://bugs.mysql.com/bug.php?id=96400

      Likely related is also: https://jira.percona.com/browse/FB8-105

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                przemyslaw.skibinski Przemyslaw Skibinski
                Reporter:
                przemyslaw.malkowski@percona.com Przemyslaw Malkowski
              • Votes:
                1 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 - 3 days, 1 hour, 30 minutes
                  3d 1h 30m