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 MySQL :: MySQL 8.0 Reference Manual 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.
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 MySQL 8 Minor Version Upgrades Are ONE-WAY Only - Percona Database Performance Blog
@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 .
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.
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.
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.
@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!
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.
Many thanks for your efforts.
If I can be so bold in asking. If you can make this a priority, it would be appreciated.