MENU
| Whimsical Blog
  1. Home
  2. education
  3. I can no longer update mysql with dnf

I can no longer update mysql with dnf

education
mamushi

As usual, I typed dnf update and selected “y” because there were updaters for MySQL-related packages, and the following error occurred.

[root@instance-20221217-0000 ~]# dnf update
Last metadata expiration check: 0:28:38 ago on Mon 22 Jan 2024 07:26:42 AM JST.
Dependencies resolved.
================================================================================
 Package Arch Version Repository Size
================================================================================
Installing: kernel-uek aarch
 kernel-uek aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 1.8 M
 kernel-uek-core aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 46 M
 kernel-uek-devel aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 39 M
 kernel-uek-modules aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 52 M
Upgrading: mysql-community-client
 mysql-community-client
                      aarch64 8.0.36-1.el9 mysql80-community 3.4 M
 Upgrading: mysql-community-client-plugins
                      aarch64 8.0.36-1.el9 mysql80-community 1.3 M
 mysql-community-common
                      aarch64 8.0.36-1.el9 mysql80-community 556 k
 mysql-community-icu-data-files
                      aarch64 8.0.36-1.el9 mysql80-community 2.3 M
 mysql-community-libs aarch64 8.0.36-1.el9 mysql80-community 1.4 M
 mysql-community-server
                      aarch64 8.0.36-1.el9 mysql80-community 48 M
 nspr aarch64 4.35.0-4.el9_3 ol9_appstream 135 k
 nss aarch64 3.90.0-4.el9_3 ol9_appstream 692 k
 nss-softokn aarch64 3.90.0-4.el9_3 ol9_appstream 382 k
 nss-softokn-freebl aarch64 3.90.0-4.el9_3 ol9_appstream 323 k
 nss-sysinit aarch64 3.90.0-4.el9_3 ol9_appstream 18 k
 nss-util aarch64 3.90.0-4.el9_3 ol9_appstream 86 k
 python3-cryptography aarch64 36.0.1-4.0.1.el9 ol9_oci_included 1.5 M
 python39-oci-sdk aarch64 2.118.0-1.el9 ol9_oci_included 70 M
Removing: kernel-uek aarch64 2.118.0-1.el9
 kernel-uek aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 0
 kernel-uek-core aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 196 M
 kernel-uek-devel aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 87 M
 kernel-uek-modules aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 47 M

Transaction Summary
================================================================================
Install 4 Packages
Upgrade 14 Packages
Remove 4 Packages

Total download size: 269 M
Is this ok [y/N]: y
Downloading Packages: y
(1/18): kernel-uek-5.15.0-202.135.2.el9uek.aarc 13 MB/s | 1.8 MB 00:00
(2/18): kernel-uek-devel-5.15.0-202.135.2.el9ue 36 MB/s | 39 MB 00:01
(3/18): kernel-uek-core-5.15.0-202.135.2.el9uek 32 MB/s | 46 MB 00:01
(4/18): kernel-uek-modules-5.15.0-202.135.2.el9 27 MB/s | 52 MB 00:01
(5/18): mysql-community-client-plugins-8.0.36-1 1.6 MB/s | 1.3 MB 00:00
(6/18): mysql-community-common-8.0.36-1.el9.aar 2.7 MB/s | 556 kB 00:00
(7/18): mysql-community-icu-data-files-8.0.36-1 29 MB/s | 2.3 MB 00:00
(8/18): mysql-community-libs-8.0.36-1.el9.aarch 17 MB/s | 1.4 MB 00:00
(9/18): python3-cryptography-36.0.1-4.0.1.el9.a 30 MB/s | 1.5 MB 00:00
(10/18): mysql-community-client-8.0.36-1.el9.aa 2.4 MB/s | 3.4 MB 00:01
(11/18): nspr-4.35.0-4.el9_3.aarch64.rpm 11 MB/s | 135 kB 00:00
(12/18): nss-3.90.0-4.el9_3.aarch64.rpm 27 MB/s | 692 kB 00:00
(13/18): nss-softokn-3.90.0-4.el9_3.aarch64.rpm 20 MB/s | 382 kB 00:00
(14/18): nss-softokn-freebl-3.90.0-4.el9_3.aarch 14 MB/s | 323 kB 00:00
(15/18): nss-sysinit-3.90.0-4.el9_3.aarch64.rpm 1.4 MB/s | 18 kB 00:00
(16/18): nss-util-3.90.0-4.el9_3.aarch64.rpm 7.3 MB/s | 86 kB 00:00
(17/18): python39-oci-sdk-2.118.0-1.el9.aarch64 52 MB/s | 70 MB 00:01
(18/18): mysql-community-server-8.0.36-1.el9.aa 20 MB/s | 48 MB 00:02
--------------------------------------------------------------------------------
Total 56 MB/s | 269 MB 00:04
MySQL 8.0 Community Server 3.0 MB/s | 3.1 kB 00:00
GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 (0x3A79BD29) is already installed
The GPG keys listed for the "MySQL 8.0 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository. Failing package is: mysql-community-client-8.0.36-1.el9.aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-client-plugins-8.0.36-1.el9.aarch64.rpm is not installed.8.0.36-1.el9.aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-common-8.0.36-1.el9.aarch64.rpm is not installed. aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-icu-data-files-8.0.36-1.el9.aarch64.rpm is not installed.8.0.36-1.el9.aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-libs-8.0.36-1.el9.aarch64.rpm is not installed. Failing package is: mysql-community-libs-8.0.36-1.el9.aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-server-8.0.36-1.el9.aarch64.rpm is not installed. aarch64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'dnf clean packages'.
Error: GPG check FAILED

So I entered ‘dnf clean packages’ as instructed, but the same error persists. I will try to resolve this.

According to the error message, it appears that there is a GPG key mismatch while trying to update the MySQL 8.0 Community Server packages. To resolve this issue, you need to install the proper GPG key.

While searching online, I found that a new 2023 key is available. Importing this new key may solve the problem. We have tried the following steps

  1. Import the new MySQL GPG key. This is done using the following command

    rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
  2. Verify that the GPG key has been imported correctly. Run the following command again to verify that the new key is included in the list

    rpm -q gpg-pubkey --qf '%{NAME}-%{VERSION}-%{RELEASE}\t%{SUMMARY}\n'
  3. Run dnf update again. If a new GPG key is installed, the update process will have a better chance of success.

If this process still does not resolve the problem, you will need to review your system’s repository settings. In particular, pay attention to the MySQL-related repository configuration files in the /etc/yum.repos.d/ directory. In it, make sure that the gpgkey setting points to the latest key (2023 version). The execution results are as follows.

[root@instance-20221217-0000 ~]# rpm –import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
[root@instance-20221217-0000 ~]# rpm -q gpg-pubkey –qf ‘%{NAME}-%{VERSION}-%{RELEASE}\t%{SUMMARY}\n’
gpg-pubkey-8d8b756f-629e59ec Oracle Linux (release key 1) secalert_us@oracle.com public key
gpg-pubkey-8b4efbe6-629ec292 Oracle Linux (backup key 1) secalert_us@oracle.com public key
gpg-pubkey-3a79bd29-61b8bab7 MySQL Release Engineering mysql-build@oss.oracle.com public key
gpg-pubkey-a8d3785c-6536acda MySQL Release Engineering mysql-build@oss.oracle.com public key

It appears that the new MySQL GPG key (2023 version) has been successfully imported. This increases the likelihood that the GPG key issue you were experiencing when updating the MySQL package will be resolved. Proceeding next, we tried updating the package again.

  1. Re-run the package update, using the dnf update command to try to update it.

    dnf update
  2. Check for errors while performing the update. In particular, check for recurring GPG key problems with MySQL-related packages.
  3. Check that everything has completed successfully. If the update completes successfully, the problem should now be resolved.

I was able to solve the problem this way.

[root@instance-20221217-0000 ~]# dnf update
Last metadata expiration check: 0:47:34 ago on Mon 22 Jan 2024 07:26:42 AM JST.

Dependencies resolved.

Package Arch Version Repository Size

Installing: kernel-uek aarch
kernel-uek aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 1.8 M
kernel-uek-core aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 46 M
kernel-uek-devel aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 39 M
kernel-uek-modules aarch64 5.15.0-202.135.2.el9uek ol9_baseos_latest 52 M
Upgrading: mysql-community-client
mysql-community-client
aarch64 8.0.36-1.el9 mysql80-community 3.4 M
Upgrading: mysql-community-client-plugins
aarch64 8.0.36-1.el9 mysql80-community 1.3 M
mysql-community-common
aarch64 8.0.36-1.el9 mysql80-community 556 k
mysql-community-icu-data-files
aarch64 8.0.36-1.el9 mysql80-community 2.3 M
mysql-community-libs aarch64 8.0.36-1.el9 mysql80-community 1.4 M
mysql-community-server
aarch64 8.0.36-1.el9 mysql80-community 48 M
nspr aarch64 4.35.0-4.el9_3 ol9_appstream 135 k
nss aarch64 3.90.0-4.el9_3 ol9_appstream 692 k
nss-softokn aarch64 3.90.0-4.el9_3 ol9_appstream 382 k
nss-softokn-freebl aarch64 3.90.0-4.el9_3 ol9_appstream 323 k
nss-sysinit aarch64 3.90.0-4.el9_3 ol9_appstream 18 k
nss-util aarch64 3.90.0-4.el9_3 ol9_appstream 86 k
python3-cryptography aarch64 36.0.1-4.0.1.el9 ol9_oci_included 1.5 M
python39-oci-sdk aarch64 2.118.0-1.el9 ol9_oci_included 70 M
Removing: kernel-uek aarch64 2.118.0-1.el9
kernel-uek aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 0
kernel-uek-core aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 196 M
kernel-uek-devel aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 87 M
kernel-uek-modules aarch64 5.15.0-200.131.27.el9uek @ol9_baseos_latest 47 M

Transaction Summary

Install 4 Packages
Upgrade 14 Packages
Remove 4 Packages

Total size: 269 M
Is this ok [y/N]: y
Downloading Packages: y
[SKIPPED] kernel-uek-5.15.0-202.135.2.el9uek.aarch64.rpm: Already downloaded
[SKIPPED] kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64.rpm: Already downloaded
[SKIPPED] kernel-uek-devel-5.15.0-202.135.2.el9uek.aarch64.rpm: Already downloaded
[SKIPPED] kernel-uek-modules-5.15.0-202.135.2.el9uek.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-client-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-client-plugins-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-common-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-icu-data-files-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-libs-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] mysql-community-server-8.0.36-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] python3-cryptography-36.0.1-4.0.1.el9.aarch64.rpm: Already downloaded
[SKIPPED] python39-oci-sdk-2.118.0-1.el9.aarch64.rpm: Already downloaded
[SKIPPED] nspr-4.35.0-4.el9_3.aarch64.rpm: Already downloaded
[SKIPPED] nss-3.90.0-4.el9_3.aarch64.rpm: Already downloaded
[SKIPPED] nss-softokn-3.90.0-4.el9_3.aarch64.rpm: Already downloaded
[SKIPPED] nss-softokn-freebl-3.90.0-4.el9_3.aarch64.rpm: Already downloaded
[SKIPPED] nss-sysinit-3.90.0-4.el9_3.aarch64.rpm: Already downloaded
[SKIPPED] nss-util-3.90.0-4.el9_3.aarch64.rpm: Already downloaded
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Upgrading : nspr-4.35.0-4.el9_3.aarch64 1/36
Upgrading : nss-util-3.90.0-4.el9_3.aarch64 2/36
Upgrading : mysql-community-common-8.0.36-1.el9.aarch64 3/36
Upgrading : mysql-community-client-plugins-8.0.36-1.el9.aarch6 4/36
Running scriptlet: kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64 5/36
Installing : kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64 5/36
Running scriptlet: kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64 5/36
Installing : kernel-uek-modules-5.15.0-202.135.2.el9uek.aarch64 6/36
Running scriptlet: kernel-uek-modules-5.15.0-202.135.2.el9uek.aarch64 6/36
Upgrading : mysql-community-libs-8.0.36-1.el9.aarch64 7/36
Running scriptlet: mysql-community-libs-8.0.36-1.el9.aarch64 7/36
Upgrading : mysql-community-client-8.0.36-1.el9.aarch64 8/36
Upgrading : nss-softokn-freebl-3.90.0-4.el9_3.aarch64 9/36
Upgrading : nss-softokn-3.90.0-4.el9_3.aarch64 10/36
Upgrading : nss-3.90.0-4.el9_3.aarch64 11/36
Running scriptlet: nss-3.90.0-4.el9_3.aarch64 11/36
Upgrading : nss-sysinit-3.90.0-4.el9_3.aarch64 12/36
Upgrading : python3-cryptography-36.0.1-4.0.1.el9.aarch64 13/36
Upgrading : mysql-community-icu-data-files-8.0.36-1.el9.aarch6 14/36
Running scriptlet: mysql-community-server-8.0.36-1.el9.aarch64 15/36
Upgrading : mysql-community-server-8.0.36-1.el9.aarch64 15/36
Running scriptlet: mysql-community-server-8.0.36-1.el9.aarch64 15/36
Upgrading : python39-oci-sdk-2.118.0-1.el9.aarch64 16/36
Installing : kernel-uek-5.15.0-202.135.2.el9uek.aarch64 17/36
Installing : kernel-uek-devel-5.15.0-202.135.2.el9uek.aarch64 18/36
Running scriptlet: kernel-uek-devel-5.15.0-202.135.2.el9uek.aarch64 18/36
Cleanup : python39-oci-sdk-2.93.1-1.el9.aarch64 19/36
Cleanup : nss-3.90.0-3.el9_2.aarch64 20/36
Cleanup : nss-softokn-3.90.0-3.el9_2.aarch64 21/36
Cleanup : nss-sysinit-3.90.0-3.el9_2.aarch64 22/36
Running scriptlet: mysql-community-server-8.0.35-1.el9.aarch64 23/36
Cleanup : mysql-community-server-8.0.35-1.el9.aarch64 23/36
Running scriptlet: mysql-community-server-8.0.35-1.el9.aarch64 23/36
Erasing : kernel-uek-5.15.0-200.131.27.el9uek.aarch64 24/36
Running scriptlet: kernel-uek-5.15.0-200.131.27.el9uek.aarch64 24/36
Erasing : kernel-uek-modules-5.15.0-200.131.27.el9uek.aarch6 25/36
Running scriptlet: kernel-uek-modules-5.15.0-200.131.27.el9uek.aarch6 25/36
Running scriptlet: kernel-uek-core-5.15.0-200.131.27.el9uek.aarch64 26/36
Erasing : kernel-uek-core-5.15.0-200.131.27.el9uek.aarch64 26/36
Running scriptlet: kernel-uek-core-5.15.0-200.131.27.el9uek.aarch64 26/36
Cleanup : mysql-community-icu-data-files-8.0.35-1.el9.aarch6 27/36
Erasing : kernel-uek-devel-5.15.0-200.131.27.el9uek.aarch64 28/36
Cleanup : mysql-community-client-8.0.35-1.el9.aarch64 29/36
Cleanup : mysql-community-libs-8.0.35-1.el9.aarch64 30/36
Running scriptlet: mysql-community-libs-8.0.35-1.el9.aarch64 30/36
Cleanup : nss-softokn-freebl-3.90.0-3.el9_2.aarch64 31/36
Cleanup : mysql-community-common-8.0.35-1.el9.aarch64 32/36
Cleanup : nss-util-3.90.0-3.el9_2.aarch64 33/36
Cleanup : nspr-4.35.0-3.el9_2.aarch64 34/36
Cleanup : mysql-community-client-plugins-8.0.35-1.el9.aarch6 35/36
Cleanup : python3-cryptography-36.0.1-4.el9.aarch64 36/36
Running scriptlet: kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64 36/36
Running scriptlet: nss-3.90.0-4.el9_3.aarch64 36/36
Running scriptlet: python3-cryptography-36.0.1-4.el9.aarch64 36/36
Verifying : kernel-uek-5.15.0-202.135.2.el9uek.aarch64 1/36
Verifying : kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64 2/36
Verifying : kernel-uek-devel-5.15.0-202.135.2.el9uek.aarch64 3/36
Verifying : kernel-uek-modules-5.15.0-202.135.2.el9uek.aarch64 4/36
Verifying : mysql-community-client-8.0.36-1.el9.aarch64 5/36
Verifying : mysql-community-client-8.0.35-1.el9.aarch64 6/36
Verifying : mysql-community-client-plugins-8.0.36-1.el9.aarch6 7/36
Verifying : mysql-community-client-plugins-8.0.35-1.el9.aarch6 8/36
Verifying : mysql-community-common-8.0.36-1.el9.aarch64 9/36
Verifying : mysql-community-common-8.0.35-1.el9.aarch64 10/36
Verifying : mysql-community-icu-data-files-8.0.36-1.el9.aarch6 11/36
Verifying : mysql-community-icu-data-files-8.0.35-1.el9.aarch6 12/36
Verifying : mysql-community-libs-8.0.36-1.el9.aarch64 13/36
Verifying : mysql-community-libs-8.0.35-1.el9.aarch64 14/36
Verifying : mysql-community-server-8.0.36-1.el9.aarch64 15/36
Verifying : mysql-community-server-8.0.35-1.el9.aarch64 16/36
Verifying : python3-cryptography-36.0.1-4.0.1.el9.aarch64 17/36
Verifying : python3-cryptography-36.0.1-4.el9.aarch64 18/36
Verifying : python39-oci-sdk-2.118.0-1.el9.aarch64 19/36
Verifying : python39-oci-sdk-2.93.1-1.el9.aarch64 20/36
Verifying : nspr-4.35.0-4.el9_3.aarch64 21/36
Verifying : nspr-4.35.0-3.el9_2.aarch64 22/36
Verifying : nss-3.90.0-4.el9_3.aarch64 23/36
Verifying : nss-3.90.0-3.el9_2.aarch64 24/36
Verifying : nss-softokn-3.90.0-4.el9_3.aarch64 25/36
Verifying : nss-softokn-3.90.0-3.el9_2.aarch64 26/36
Verifying : nss-softokn-freebl-3.90.0-4.el9_3.aarch64 27/36
Verifying : nss-softokn-freebl-3.90.0-3.el9_2.aarch64 28/36
Verifying : nss-sysinit-3.90.0-4.el9_3.aarch64 29/36
Verifying : nss-sysinit-3.90.0-3.el9_2.aarch64 30/36
Verifying : nss-util-3.90.0-4.el9_3.aarch64 31/36
Verifying : nss-util-3.90.0-3.el9_2.aarch64 32/36
Verifying : kernel-uek-5.15.0-200.131.27.el9uek.aarch64 33/36
Verifying : kernel-uek-core-5.15.0-200.131.27.el9uek.aarch64 34/36
Verifying : kernel-uek-devel-5.15.0-200.131.27.el9uek.aarch64 35/36
Verifying : kernel-uek-modules-5.15.0-200.131.27.el9uek.aarch6 36/36

Upgraded: mysql-community-client
mysql-community-client-8.0.36-1.el9.aarch64
mysql-community-client-plugins-8.0.36-1.el9.aarch64
mysql-community-common-8.0.36-1.el9.aarch64
mysql-community-icu-data-files-8.0.36-1.el9.aarch64
mysql-community-libs-8.0.36-1.el9.aarch64
mysql-community-server-8.0.36-1.el9.aarch64
nspr-4.35.0-4.el9_3.aarch64
nss-3.90.0-4.el9_3.aarch64
nss-softokn-3.90.0-4.el9_3.aarch64
nss-softokn-freebl-3.90.0-4.el9_3.aarch64
nss-sysinit-3.90.0-4.el9_3.aarch64
nss-util-3.90.0-4.el9_3.aarch64
python3-cryptography-36.0.1-4.0.1.el9.aarch64
python39-oci-sdk-2.118.0-1.el9.aarch64
Installed: kernel-uek-5.0.1.el9.aarch64
kernel-uek-5.15.0-202.135.2.el9uek.aarch64
kernel-uek-core-5.15.0-202.135.2.el9uek.aarch64
kernel-uek-devel-5.15.0-202.135.2.el9uek.aarch64
kernel-uek-modules-5.15.0-202.135.2.el9uek.aarch64
Removed:
kernel-uek-5.15.0-200.131.27.el9uek.aarch64
kernel-uek-core-5.15.0-200.131.27.el9uek.aarch64
kernel-uek-devel-5.15.0-200-200.131.27.el9uek.aarch64
kernel-uek-modules-5.15.0-200.131.27.el9uek.aarch64

Complete!

education
Please share if you like it!
TOC