xtrabackup: Error: xtrabackup_copy_logfile() failed

MySQL & MariaDB Percona XtraBackup
1

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.

2
  • 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.
1 Like