# Xtrabackup 8.0.11 and MySQL 8.0.20: xtrabackup: Error: recv\_find\_max\_checkpoint() failed **URL:** \ **Category:** Percona XtraBackup\ **Created:** [April 28, 2020, 1:25am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583 "2020-04-28T01:25:46Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![SujitR](https://avatars.discourse-cdn.com/v4/letter/s/65b543/32.png) [@SujitR](https://forums.percona.com/u/SujitR)\ **Post date:** [April 28, 2020, 1:25am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/1 "2020-04-28T01:25:46Z")
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.sock**00:00:03 Unknown redo log format (4). Please follow the instructions at [MySQL :: MySQL 8.0 Reference Manual](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.  ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [April 28, 2020, 3:18am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/2 "2020-04-28T03:18:15Z")
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?  ---
**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Post date:** [April 28, 2020, 3:35am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/3 "2020-04-28T03:35:16Z")
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 [MySQL 8 Minor Version Upgrades Are ONE-WAY Only - Percona Database Performance Blog](https://www.percona.com/blog/2020/01/10/mysql-8-minor-version-upgrades-are-one-way-only/) ---
**Author:** ![SujitR](https://avatars.discourse-cdn.com/v4/letter/s/65b543/32.png) [@SujitR](https://forums.percona.com/u/SujitR)\ **Post date:** [April 28, 2020, 8:01am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/4 "2020-04-28T08:01:33Z")
@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) ---
**Author:** ![Vensasind](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vensasind/32/3105_2.png) [@Vensasind](https://forums.percona.com/u/Vensasind)\ **Post date:** [March 13, 2021, 10:50am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/5 "2021-03-13T10:50:00Z")
Do we have any fix for this , we are still getting this error . ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [March 15, 2021, 10:34am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/6 "2021-03-15T10:34:28Z")
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. ---
**Author:** ![Brent\_Clark](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/brent_clark/32/6519_2.png) [@Brent\_Clark](https://forums.percona.com/u/Brent_Clark)\ **Post date:** [May 9, 2022, 9:34am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/7 "2022-05-09T09:34:41Z")
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](http://dev.mysql.com/doc/refman/8.0/en/) upgrading-downgrading.html. 2022-05-09T09:30:24.367456-00:00 0 [ERROR] [MY-011825] [Xtrabackup] recv\_find\_max\_checkpoint() failed. ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [May 9, 2022, 11:15am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/8 "2022-05-09T11:15:16Z")
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. ---
**Author:** ![Ash\_Powell](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ash_powell/32/6610_2.png) [@Ash\_Powell](https://forums.percona.com/u/Ash_Powell)\ **Post date:** [May 25, 2022, 2:57am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/9 "2022-05-25T02:57:23Z")
@Marcelo_Altmann , @Brent_Clark . Just throwing my name in here as well. I’ve got the same exact issue. With MySQL 8.0.29 and Xtrabackup 8.0.28. Marcelo. Do you happen know if there’s an ETA for an Xtrabackup 8.0.29 release? Thanks so much! ---
**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\ **Post date:** [May 26, 2022, 11:09am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/10 "2022-05-26T11:09:55Z")
Hi @Ash_Powell We are still working on PXB 8.0.29 . We have done good progress and should start testing it in the next few days, however, we still don’t have any ETA for the release yet. ---
**Author:** ![Brent\_Clark](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/brent_clark/32/6519_2.png) [@Brent\_Clark](https://forums.percona.com/u/Brent_Clark)\ **Post date:** [June 24, 2022, 11:14am UTC](https://forums.percona.com/t/xtrabackup-8-0-11-and-mysql-8-0-20-xtrabackup-error-recv-find-max-checkpoint-failed/7583/11 "2022-06-24T11:14:20Z")
Many thanks for your efforts. If I can be so bold in asking. If you can make this a priority, it would be appreciated.