Xtrabackup endlessly prints "log scanned up to (xxx)"

[axel]

I am using this command:
xtrabackup --host=XX.XXX.XX.XX --user=XXX --password=XXX --backup --target-dir=/root/backups/

to run backups. However, xtrabackup doesn’t seem to be finishing the task. It just endlessly prints “2023-05-03T10:55:23.916415-00:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (19480638)” for 4 hours now.

My backup server is running on digitalocean with the following specs:
4 GB Memory / 2 Intel vCPUs / 80 GB Disk / NYC1 - Ubuntu 20.04 (LTS) x64

I have a master-slave architecture setup and these are the specs:
Master: 32 GB Memory / 200 GB Disk / NYC1 - Ubuntu 20.04 (LTS) x64
Slave: 16 GB Memory / 200 GB Disk / NYC1 - Ubuntu 20.04 (LTS) x64

Please help.

[kedarpercona]

Welcome back Axel,

Did you happen to see if this is relevant: https://forums.percona.com/t/xtrabackup-endless-loop-of-log-scanned-up-to/

I also invite you to go through How Xtrabackup Works.

Let us know if those links are helpful.

Thanks,
Kedar.

[matthewb]

Hello @axel,
Do you have any MyISAM tables? I also see you are missing --parallel N option in your command. Without this option, xtrabackup is essentially single-threaded and thus your backup will be slow overall.

[Stateros]

I faced a similar issue during migration up to 8.0.30 and the next 8.0.32. Check my situation if it’s applicable to you. Xtrabackup 8.0.30 issue. [ERROR] [MY-011825] [Xtrabackup] read_logfile() failed