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

xtrabackup: Error: xtrabackup_copy_logfile() failed

adityapadityap EntrantLegacy User Role Beginner
There are 31 instances in our environment out of which almost 20 instance backups are failed, due to slowness. We are getting below error.

xtrabackup: error: log block numbers mismatch:

xtrabackup: error: expected log block no. 660048145, but got no. 661096713 from the log file.

xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or log files being too small.

181121 17:32:05 [01] ...done

xtrabackup: Error: xtrabackup_copy_logfile() failed

we observed slowness while execution of Backups.

Comments

  • lalit.choudharylalit.choudhary Percona Percona Staff Role

    The potential solutions to the above problem are:

    • Increasing the size of the redo logs, so they are not wrapped while mysql is working.
    • The read speed is too slow which usually is a sign of IO congestion.
    • The write speed is too slow which usually is a sign of IO congestion or network congestion.
    • Taking backup off-peak time, while the system saturation is lower.


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.