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

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 5.7.26-29, 8.0.16-7, Not 5.6.x
    • 8.0.17-8, 5.7.28-31
    • 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

      Attachments

        Activity

          People

            przemyslaw.skibinski Przemyslaw Skibinski
            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

                Smart Checklist