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

LP #1671437: Waiting for master thread to be suspended

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Josef Vogt last update 17-07-2017 08:07:18

      Hi

      From time to time xtrabackup fails and does not finish. In the logs I can see the following message:
      ...
      InnoDB: Starting an apply batch of log records to the database...
      InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
      InnoDB: Apply batch completed
      InnoDB: Creating shared tablespace for temporary tables
      InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      InnoDB: Starting in background the rollback of uncommitted transactions
      InnoDB: Rolling back trx with id 548932575, 1 rows to undo
      InnoDB: Rollback of trx with id 548932575 completed
      InnoDB: Rollback of non-prepared transactions completed
      InnoDB: File './ibtmp1' size is now 12 MB.
      InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
      InnoDB: 32 non-redo rollback segment(s) are active.
      InnoDB: page_cleaner: 1000ms intended loop took 34245m23
      InnoDB: page_cleaner: 1000ms intended loop took 34245m23

      xtrabackup: Recovered WSREP position: 618d728d-3c47-11e6-94c0-527265a4c0cd:147540320
      xtrabackup: starting shutdown with innodb_fast_shutdown = 1
      InnoDB: FTS optimize thread exiting.
      InnoDB: Starting shutdown...
      InnoDB: Waiting for master thread to be suspended
      InnoDB: Waiting for master thread to be suspended
      InnoDB: Waiting for master thread to be suspended
      (this message is repeated over and over, for multiple days)
      ...

      Seems as something is preventing the shutdown to succeed.
      How can I find out what it is?

      The backups are executed as following:

      • Stage One
        /usr/bin/innobackupex -no-timestamp --no-lock --password="pwd" /srv/data/backup/`date +%Y%m%d%H%M%S`
      • Stage Two
        /usr/bin/innobackupex -apply-log /srv/data/backup/`date +%Y%m%d%H%M%S`

      Best regards
      Joe

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist