Corrupt log record found (Mysql 8.0.29-0ubuntu0.20.04.2 and Xtrabackup 8.0.28-20)

MySQL & MariaDB Percona XtraBackup
1

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

2

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.

3

Hi Marcelo,

Thanks for your super quick answer :slight_smile: When can i expect an update or does it make sense to downgrade MySQL again?

Br Lukas

4

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.

5

Hi Marcelo,
Is there any estimate for getting 8.0.29 released
?

6

Hi @Maria_Ivanova . We are still in the early stages of understanding all the changes. No ETA at the moment.

7

hi Marcelo,
Is there any update or ETA?
I guess this affects many servers that use the latest mysql version.

8

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.

9

Please have a look here:

10

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?

11

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.

12

Hi @Marcelo_Altmann
How is the QA process going on?
The new version is still not available in the ubuntu repository.

13

@Marcelo_Altmann How’s this coming along?

14

We are getting close to the release. Soon we will publish a blog post with more details.

15

(post deleted by author)

16

Any ETA? There is a lot of folks needing 8.0.29 and are holding off waiting for XB to support it.

17

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

18

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?

19

Ah it seems to have been released now! Thank you

20

@Marcelo_Altmann Is there any release note about the new version?