Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1039

LP #1717158: Safe-slave-backups stucks with long query

    XMLWordPrintable

    Details

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

      Description

      **Reported in Launchpad by markus_albe last update 10-11-2017 08:12:52

      When using --safe-slave-backup the following can happen:

      t1: temporary table is created
      t2: long DML starts
      t3: safe-slave-backup STOP SLAVE arrives
      t4: slave SQL thread is killed and long DML is rollback'ed.
      t5: safe-slave-backup START SLAVE arrives... and restarts where long DML starts.
      t6 safe-slave-backup sleeps a bit...but far less than the long DML, so it will STOP SLAVE again while the long DML is still running, repeating the above ad-eternum.

      Proposed fix would be for safe-slave-backup to check position when it stops slave, and make sure replication position has moved forward since it last stopped. This way at least we won't loop over the exact same query every time, depleting all retries.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: