Xtrabackup 8.0.11 and MySQL 8.0.20: xtrabackup: Error: recv_find_max_checkpoint() failed

I’m using Xtrabackup 8.0.11 and MySQL 8.0.20 and when I execute the following code line:
sudo xtrabackup --backup -uxxxx -p --socket=/mysqldata/mysql.sock --history --compress --slave-info --compress-threads=10 --target-dir=/xtrabackup
I am getting following Result—:
00:00:03 Using server version 8.0.2000:00:03 xtrabackup: uses posix_fadvise().00:00:03 xtrabackup: cd to /mysqldata00:00:03 xtrabackup: open files limit requested 65535, set to 6553500:00:03 xtrabackup: using the following InnoDB configuration:00:00:03 xtrabackup:   innodb_data_home_dir = .00:00:03 xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend00:00:03 xtrabackup:   innodb_log_group_home_dir = ./00:00:03 xtrabackup:   innodb_log_files_in_group = 200:00:03 xtrabackup:   innodb_log_file_size = 214748364800:00:03 Number of pools: 100:00:03 200428 00:00:03 Connecting to MySQL server host: localhost, user: sqladmin, password: set, port: not set, socket: /mysqldata/mysql.sock00:00:03 Unknown redo log format (4). Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/ upgrading-downgrading.html.00:00:03 xtrabackup: Error: recv_find_max_checkpoint() failed.

As I checked in MySQL 8.0.20 release (release date 24-April-2020)
 MySql has some changes in the redo log format.
How I can resolve this now. 

1 Like

Can I check if this is a script that you were successfully using before upgrading software? If that’s the case, what have you gone from and to? I’m checking in with the team, but a few more details could help. Is it a production environment? What OS are you running, please? 

Hello again, I have an update. 
The redo log format did indeed change in the latest MySQL version, and Percona XtraBackup will not be current with that until the next release. The only way to resolve the issue immediately would be to revert to 8.0.19 but that itself comes with some severe warnings, please read this blog post by my colleague Marco https://www.percona.com/blog/2020/01/10/mysql-8-minor-version-upgrades-are-one-way-only/

@lorraine
1)Succesful backup with MySQL8.0.19(27-April-2020) and Xtrabackup 8.0.11.
sudo xtrabackup --backup -u xxxxx -p --socket=/mysqldata/mysql.sock --history --compress --slave-info --compress-threads=10 --target-dir=/xtrabackup

00:00:02 Using server version 8.0.1900:00:02 xtrabackup: uses posix_fadvise().00:00:02 xtrabackup: cd to /mysqldata00:00:02 xtrabackup: open files limit requested 65535, set to 6553500:00:02 xtrabackup: using the following InnoDB configuration:00:00:02 xtrabackup:   innodb_data_home_dir = .00:00:02 xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend00:00:02 xtrabackup:   innodb_log_group_home_dir = ./00:00:02 xtrabackup:   innodb_log_files_in_group = 200:00:02 xtrabackup:   innodb_log_file_size = 214748364800:00:02 Number of pools: 100:00:02 200427 00:00:02 Connecting to MySQL server host: localhost, user: sqladmin, password: set, port: not set, socket: /mysqldata/mysql.sock00:00:02 200427 00:00:02 >> log scanned up to (5983781423982)00:00:02 xtrabackup: Redo Log Archiving is not set up.00:00:02 xtrabackup: Generating a list of tablespaces00:00:02 Directories to scan '.;./;.'

2)Is this is Production env.
3)Os Release 
CentOS Linux release 7.8.2003 (Core)

Do we have any fix for this , we are still getting this error .

1 Like

Hi @Vensasind .

This issue has been fixed already. Can you please send us the version of MySQL you are trying to backup, your version of xtrabackup, and a copy of xtrabackup output showing the full error.

1 Like

Hiya
There definitely is still a problem

root@:/tmp# dpkg -l | egrep ‘mysql-server|xtrabackup’
ii mysql-server 8.0.29-0ubuntu0.20.04.3 all MySQL database server (metapackage depending on the latest version)
ii mysql-server-8.0 8.0.29-0ubuntu0.20.04.3 amd64 MySQL database server binaries and system database setup
ii mysql-server-core-8.0 8.0.29-0ubuntu0.20.04.3 amd64 MySQL database server binaries
ii percona-xtrabackup-80 8.0.28-20-1.focal amd64 Open source backup tool for InnoDB and XtraDB

what I get is:
2022-05-09T09:30:24.030461-00:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-05-09T09:30:24.038025-00:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-05-09T09:30:24.168645-00:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /var/run/mysqld/mysqld.sock
2022-05-09T09:30:24.173446-00:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2022-05-09T09:30:24.367171-00:00 0 [ERROR] [MY-012530] [InnoDB] Unknown redo log format (5). Please follow the instructions at MySQL :: MySQL 8.0 Reference Manual upgrading-downgrading.html.
2022-05-09T09:30:24.367456-00:00 0 [ERROR] [MY-011825] [Xtrabackup] recv_find_max_checkpoint() failed.

2 Likes

Hi @Brent_Clark ,

Your error is because MySQL 8.0.29 changed the redo log format and Percona Xtrabackup 8.0.28 does not understand it.

For now, you can either downgrade MySQL to 8.0.28 or wait for Percona Xtrabackup 8.0.29 to be released.

1 Like