Bug #120317 Upgrading from MySQL 9.6 to 9.7 with yum doesn't work as expected

• Submitted: 22 Apr 5:59
• Modified: 24 Apr 5:55
• Reporter: Daniël van Eeden (OCA)
• Status: Open
• Category: MySQL Package Repos
• Severity: S2 (Serious)
• Version: 9.7.0
• OS: Any
• Assigned to: Balasubramanian Kandasamy
• CPU Architecture: Any
• Tags: dnf, rpm, yum

[22 Apr 5:59] Daniël van Eeden

Description:
Running a `dnf update` didn't update from MySQL 9.6 to MySQL 9.7 as expected.

Looks like the repo definition wasn't automatically updated.

$ grep '\[mysql'  /etc/yum.repos.d/mysql-community.repo
[mysql-connectors-community]
[mysql-8.4-lts-community]
[mysql-tools-8.4-lts-community]
[mysql-cluster-8.4-lts-community]
[mysql-innovation-community]
[mysql-tools-innovation-community]
[mysql-cluster-innovation-community]

$ grep '\[mysql'  /etc/yum.repos.d/mysql-community.repo.rpmnew 
[mysql-connectors-community]
[mysql-8.4-lts-community]
[mysql-tools-8.4-lts-community]
[mysql-cluster-8.4-lts-community]
[mysql-9.7-lts-community]
[mysql-tools-9.7-lts-community]
[mysql-cluster-9.7-lts-community]
[mysql-innovation-community]
[mysql-tools-innovation-community]
[mysql-cluster-innovation-community]

How to repeat:
Upgrade from MySQL 9.6.0 to MySQL 9.7.0 on Fedora.

Suggested fix:
I fixed this by doing this:

sudo mv /etc/yum.repos.d/mysql-community.repo.rpmnew /etc/yum.repos.d/mysql-community.repo

And then editing /etc/yum.repos.d/mysql-community.repo to re-enable the innovation repositories that I had enabled previously. I did this with vim, but it should probably be done using `dnf config-manager`.

[23 Apr 6:47] Balasubramanian Kandasamy

Thanks for the bug report. We are working on it.

[23 Apr 16:38] Balasubramanian Kandasamy

We have fixed the YUM repositories. Updating from 9.6 to 9.7 should work as expected.

Could you please try now?

[24 Apr 5:50] Balasubramanian Kandasamy

Also, To install the MySQL 9.7 LTS release, you could enable the LTS series subrepository before executing installation commands

$> sudo dnf config-manager --enable mysql-9.7-lts-community
$> sudo dnf config-manager --enable mysql-tools-9.7-lts-community

To enable the mysql-innovation-community subrepository:

$> sudo dnf config-manager --enable mysql-innovation-community
$> sudo dnf config-manager --enable mysql-tools-innovation-community

[24 Apr 5:55] Daniël van Eeden

> Could you please try now?

As I already fixed this manually, I can't try this again.