MySQL 8.0.29 - Woocommerce InnoDB corruption

[Jamira40]

Hey,

Just to let you know there is ongoing bug with MySQL 8.0.29 that is causing silent InnoDB corruption mainly with Woocommerce updates.

Some info is here MySQL :: Re: Massive increase in InnoDB corruption issues since upgrade to 8.0.29

Oh and little info. This will cause MySQL to crash like hard...

 

[cPRex]

Hey there! thanks for that - I've let our database team know!

 

[Hedloff]

What's the best way to downgrade the servers to the last used mysql version?

We continue to have this issue on multiple servers and need to restore from backup each time.

Causing alot of missing data and angry customers!

 

[cPRex]

-redacted-

 

[Hedloff]

Will try that, thanks!

 

[Hedloff]

Do you have any plans to remove it so others that do upgrade will not suffer the same issues?
Remove the packages from repo?

 

[cPRex]

I've let our MySQL team know and I reply back with some details once I have them!

 

[cPRex]

@Hedloff - it's been noted that trying even minor downgrades with MySQL 8 can cause issues, so it would be best not to try that. I've removed my earlier post recommending that action.

 

[cPRex]

MySQL 8.0.29 was released in April 2022, so there isn't anything we can do on our side at this point. MySQL updates are handled directly from their repositories, so any cPanel server that is using MySQL 8 would have version 8.0.29 for some time already.

It's also worth noting that this specific bug is set to private on the MySQL end: MySQL Bugs: Access denied

 

[Hedloff]

Well, can cause issues is better than the whole MySQL will go corrupt and needs to be restored from backup. Not everyone has backup either, so what kind of issue have others faced with a downgrade?
We just updated rest of our servers now in June because of the security update in cPanel!

 

[cPRex]

Not everyone has backup either, so what kind of issue have others faced with a downgrade?

Everything from "working as intended" to "MySQL not restarting at all" has been reported.