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

Xtrabackup fails with xtrabackup: Error: xtrabackup_copy_datafile() failed

PrakashSelvaPrakashSelva EntrantInactive User Role Novice
Hi team,

I'm using percona-xtrabackup-24-2.4.15-1.el7.x86_64 against MySQL 5.7.27.

The backup command used is the following:

Shell# xtrabackup --defaults-file=/etc/my.cnf --user=root --password=xxxxxx --target-dir=/data/backup/ --backup

But, it fails with the following error every time:

190913 03:17:23 [01] Copying ./ibdata1 to /root/Mysql-Backup/2019-09-13_03-17-22/ibdata1
190913 03:17:33 >> log scanned up to (704545337814)
190913 03:17:34 >> log scanned up to (704545338360)
190913 03:17:35 >> log scanned up to (704545338916)
190913 03:17:36 >> log scanned up to (704545338916)
190913 03:17:37 >> log scanned up to (704545338916)
190913 03:17:38 >> log scanned up to (704545338916)
InnoDB: 10485760 bytes should have been read. Only 7184384 bytes read. Retrying for the remaining bytes.
190913 03:17:39 >> log scanned up to (704545338916)
190913 03:17:40 >> log scanned up to (704545338916)
190913 03:17:41 >> log scanned up to (704545338916)
InnoDB: Retry attempts for reading partial data failed.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.


Could you help to identify the cause for this issue? Thanks in advance.

Regards,
Prakash
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.