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