Not the answer you need?
Register and ask your own question!

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

tenmatenma EntrantInactive User Role Beginner
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)</pre>


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 </pre>


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?

Comments

  • tenmatenma Entrant Inactive User Role Beginner
    Any ideas about this?
  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    Hi,

    Some questions:

    Is the server a slave?

    Are you using mysqld_multi?

    Regards.
  • mparrettmparrett Entrant Inactive User Role Beginner
    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.
  • rockyrocky Entrant Inactive User Role Beginner
  • jichenghanjichenghan Entrant Inactive User Role Beginner
    me too.I also encountered such a problem
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.