Xtrabackup: error

MySQL & MariaDB Percona XtraBackup
,
1

Hi,

Please help me out from this error while taking physical backup.

xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 351485992, but got no. 401817628 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.
xtrabackup: Error: xtrabackup_copy_logfile() failed.

System details:

MYSQL PERCONA SERVER VERSION 5.6 UBUNTU 14.04

xtrabackup --version
Warning: option ‘innodb_open_files’: signed value -1 adjusted to 10
xtrabackup version 2.3.10 based on MySQL server 5.6.24 Linux (x86_64) (revision id: bd0d4403f36)

Please let me know if you need any further details to investgate the issue.

regards,
Daljit Singh |MySQL/Oracle DBA

2 Likes
2

Hi @Daljit1 ,

Can you please test the backup with the latest 2.4 version?
Version 2.3 is EOL and your specific version 2.3.10 is really old and might contain a lot of issues.
If the error persists on 2.4.21 (current latest) please attach full xtrabackup log.

Thanks

1 Like
3

Hi Altmann,

Thanks for your valuable reply!

I looking for 2.4.21 downloading but this version not available for MySQL server 5.6 UBUNTU 14.04.

Could you suggest me on it please.

image
image1203×596 71.2 KB

Thanks

1 Like
4

Hi @Daljit1 ,

To start with, let’s try PXB 2.4.18 (the latest version we have available for Trusty).

1 Like
5

Hi Altmann,

I will try this and get back response you.

Thanks again.

1 Like
6

Hello Altmann,

Hope you are doing fine!

I upgraded 2.4.18 but getting same error while backup.

We are maintaining backup on slave and I noticed backup completed if slave process not running. (slave stop)

Any idea please suggest me on it.

regards,
Daljit

1 Like