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