MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
Posted by: Christos Chatzaras
Date: June 08, 2022 03:33AM

Daniel Mason was able to reproduce the issue and create a bug report which MySQL team accepted.

If you already upgrade to 8.0.29 then do a "mysqlcheck -Ao" which will recreate the data and solve the issue for tables that are NOT already corrupted.

If any tables are already corrupted (it's silent corruption so data may be already corrupted and you don't know it) MySQL will crash but you will at least know that tables are corrupted.

I was able to mysqldump && restore using innodb_force_recovery = 1 on some servers, but one MySQL server was not able to even start and I had to restore from backups.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Massive increase in InnoDB corruption issues since upgrade to 8.0.29
9876
Ralf Meyer
May 21, 2022 05:55PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1875
Peter Brawley
May 21, 2022 07:37PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1772
Laura Scott
May 25, 2022 12:24AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
2205
Daniel Mason
June 01, 2022 02:35AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
2108
Ralf Meyer
June 01, 2022 04:54AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1304
Christos Chatzaras
June 01, 2022 05:17PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1196
Christos Chatzaras
June 01, 2022 05:25PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1394
Daniel Mason
June 01, 2022 06:03PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1388
Christos Chatzaras
June 02, 2022 01:56AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1725
Daniel Mason
June 02, 2022 02:35AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1368
Ralf Meyer
June 02, 2022 04:23AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1614
Christos Chatzaras
June 02, 2022 04:41AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1247
Milutin Kubik
June 08, 2022 02:30AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
2348
Christos Chatzaras
June 08, 2022 03:33AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1305
Morten M
June 15, 2022 02:50AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1442
Marcelo Altmann
June 16, 2022 08:31AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1573
Jon Stephens
June 17, 2022 08:12AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
2050
Daniel Mason
July 02, 2022 03:02PM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1228
Duong Nguyen Quy
August 01, 2022 10:11AM
Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29
1721
Ralf Meyer
August 05, 2022 02:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.