Article 4ZJQS Percona xtrabackup hangs indefinitely in apply-log phase

Percona xtrabackup hangs indefinitely in apply-log phase

by
rylan76
from LinuxQuestions.org on (#4ZJQS)
Hi All

I'm using Percona xtrabackup to backup a Percona 5.7 (MySQL 5.7) instance.

It has been working fine for about 2 years.

Here is what I execute for phase 1 of xtrabackup - the initial phase:

Code:innobackupex --user=root --password=xxx --parallel=4 --rsync /backup_todayand then for phase 2 - the apply-log phase

Code:innobackupex --apply-log --user=root --password=xxx --use-memory=2GB
/backup_todayIn phase 2 xtrabackup then gets stuck for, well, so far 16 hours, just endlessly outputting

Code:InnoDB: Waiting for 1 active transactions to finish
InnoDB: Waiting for 1 active transactions to finish
InnoDB: Waiting for 1 active transactions to finishfor tens of thousands of lines until I kill -1 the xtrabackup process.

A "show processlist" in the associated Percona 5.7 instance shows no running transactions, no locked transactions, or any other activity...

Any ideas what I can do to get xtrabackup to actually finish a backup?

Thx!latest?d=yIl2AUoC8zA latest?i=NRwMDcqwQv0:YltJn1_g4yE:F7zBnMy latest?i=NRwMDcqwQv0:YltJn1_g4yE:V_sGLiP latest?d=qj6IDK7rITs latest?i=NRwMDcqwQv0:YltJn1_g4yE:gIN9vFwNRwMDcqwQv0
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments