Infinite "Log Scanned up to...(n)" loop

MySQL & MariaDB Percona XtraBackup
1

Hi,

I am trying to run nightly full backups using the latest innobackup ex. I have encoutnered a problem whereby after all tables have been backed up and copied to the backup file, I encounter an infinite loop of:

log scanned up to (14051476102)>> log scanned up to (14051476102)>> log scanned up to (14051476102)>> log scanned up to (14051476102)>> log scanned up to (14051476102)>> log scanned up to (14051476102)>> log scanned up to (14051476102)

I have left this running for over 24 hours but it won’t finish. CPU usage is at 0% during this time. ‘ls -lh’ shows the backup file has not been updated since about 5 minutes after the backup started.

This is the command line I am running:

/usr/bin/innobackupex --compress --safe-slave-backup --defaults-file=/data/cred/cred.cnf --extra-lsndir=/vol/tmp --stream=xbstream $folder/$fn > $folder/$fn

if I remove the --stream=xbstream then it works fine. Switching from xbstream to tar does not work either.

Any idea what’s going on?

2

Any ideas about this?

3

Hi,

Some questions:

Is the server a slave?

Are you using mysqld_multi?

Regards.

4

I know this thread is pretty old, but I just wanted to add that if you are streaming a backup, you should double check that your connection to the remote host is working properly. For example, if your ssh authentication isn’t working, you can see this “scanning log” infinitely type of problem.

5

me too.I also encountered such a problem