MySQL downgrade after conversion, service won't start

[mbartolic1]

Hi, i attempted to migrate CentOS 8.5.2111 to RHEL. Migration went fine, except after reboot mysql.service would not start.

mysqld.log shows:
[ERROR] [MY-013171] [InnoDB] Cannot boot server version 80021 on data directory built by version 80026. Downgrade is not supported

Before conversion mysql package was at version 8.0.26, after conversion it was 8.0.21. I manually upgraded to version 8.0.30 and now it works.

Conversion process didn't say anything about mysql, nor is there any mention of mysql in convert2rhel.log file.
With yum info mysql --showduplicates i see that RedHat has available version mysql-8.0.26 among others. I understand reasons against automatic upgrading to newer versions, but i don't understand why the process didn't use the same 8.0.26 version which is available? Or at least notify me which packages will be downgraded?

[Venefilyn]

Hi, are you able to provide a log file to us here?

[mbartolic1]

convert2rhel.log
mysqld.log

[bocekm]

Hi @mbartolic1, thanks for the report. We've recently bumped into a similar issue with a different package which we track under https://issues.redhat.com/browse/RHELC-899. We'll investigate both occurrences.

[r0x0d]

Hi, @mbartolic1! The PR #833 potentially fixes this issue.

Sorry for taking so long to come back to you with a fix. I'm testing the PR and making sure that it will fix the case for MySQL too.

---

Update: So, my initial test for #833 didn't fix the MySQL issue. Checking the packages for RHEL 8.5, it seems that 8.0.26 is the latest version available, but for some reason, when we try to reinstall the package it fails and then proceeds to a downgrade.

I will investigate this in a separate PR next week, as #833 is supposed to go with the next release.