hi there
Since i upgraded our MySQL version to 8.0.29 the backup with xtrabackup is failing due to a corrupt log record.
Error in log:
2022-05-05T14:57:45.023045+02:00 0 [Note] [MY-012522] [InnoDB] Set innodb_force_recovery to ignore this error.
2022-05-05T14:57:45.023064+02:00 0 [ERROR] [MY-012519] [InnoDB] ############### CORRUPT LOG RECORD FOUND ###############
2022-05-05T14:57:45.023077+02:00 0 [Note] [MY-012520] [InnoDB] Log record type 67, page 201:1492. Log parsing proceeded successfully up to 59650859782. Previous log record type 67, is multi 0 Recv offset 219, prev 219
2022-05-05T14:57:45.023089+02:00 0 [Note] [MY-012521] [InnoDB] Hex dump starting 100 bytes before and ending 100 bytes after the corrupted record:
len 200; hex 1fe1001f8800053e24000062936a18fbee81a9000062936a02fbee81a90028811002fbee81a9002a811002fbee81a9006881101f94fbee81a900290b00854f2465373338663331392d663833302d343730382d393332612d656562346635613561663834c380c985d400010009000180008006800780000000000500057fff80002ccf8107000a00081c242407000208f39265373338663331392d663833302d343730382d393332612d65656234663561356166383400000062936a82000001a901103336363262; asc >$ b j b j ( * h ) O$e738f319-f830-4708-932a-eeb4f5a5af84 , $$ e738f319-f830-4708-932a-eeb4f5a5af84 b j 3662b;
Is there any known issues with these version? I just read the A Quick Peek At MySQL 8.0.29 - Percona Database Performance Blog where is says there is no big change in this version. But still i do have the issue since the upgrade of MySQL.
I also found a similiar ticket with the same error message with version 8.0.22 here: [PXB-2319] CORRUPT LOG RECORD FOUND - MySQL 8 - Percona JIRA
BR Lukas
1 Like
Hi @nobeerhere
Percona Xtrabackup 8.0.28 is not compatible with MySQL 8.0.29 as the server introduced some changes into the redo log format.
We are currently working on merging those changes to xtrabackup.
2 Likes
Hi Marcelo,
Thanks for your super quick answer 
When can i expect an update or does it make sense to downgrade MySQL again?
Br Lukas
1 Like
We are in the first stages of understanding the changes and merge. No point in trying to give you an estimate as this is too early yet.
I would say the safest procedure here will be to downgrade to 8.0.28 and wait for the official release of xtrabackup 8.0.29.
1 Like
Hi Marcelo,
Is there any estimate for getting 8.0.29 released
?
1 Like
Hi @Maria_Ivanova . We are still in the early stages of understanding all the changes. No ETA at the moment.
1 Like
hi Marcelo,
Is there any update or ETA?
I guess this affects many servers that use the latest mysql version.
3 Likes
Hi Maria,
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.
3 Likes
Hi Marcelo
Sorry to be a pest. I’ve been checking back every couple of days for any news but not seen anything. How’s it going with PXB 8.0.29?
1 Like
Hi @Michael_Smith , 8.0.29 development release work has been completed.
We have the packages that are the candidates to be made the release already build and under QA testing. Everything going smoothly on QA cycle, it should be a matter of a couple of days to complete the package testing and make the release available on repos and download page.
We understand backups are a crucial part of everyone’s infrastructure and this time the release took a bit longer, we have a blog post explaining why at MySQL 8.0.29 and Percona XtraBackup Incompatibilities - Percona Database Performance Blog .
Thanks for your patience.
3 Likes
Hi @Marcelo_Altmann
How is the QA process going on?
The new version is still not available in the ubuntu repository.
4 Likes
@Marcelo_Altmann How’s this coming along?
3 Likes
We are getting close to the release. Soon we will publish a blog post with more details.
3 Likes
Any ETA? There is a lot of folks needing 8.0.29 and are holding off waiting for XB to support it.
1 Like
For now, we are still advising people to not upgrade to 8.0.29 (with or without PXB).
Check MySQL :: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1 Like
In our case we were previously on mysql 8.0.27 and had frequent database crashes which forced us to upgrade.
In 8.0.29 we’ve not seen any database crashes or other problems but obviously we do want to have xtrabackup running. Any chance of a release in the near future?
2 Likes
Ah it seems to have been released now! Thank you
2 Likes
@Marcelo_Altmann Is there any release note about the new version?
1 Like