dnfでmysqlをアップデートできなくなった
いつものように、dnf updateと入力し、MySQL関連のパッケージのアップデータがあったので「y」を選択すると以下のエラーが発生しました。
[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 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
aarch64 8.0.36-1.el9 mysql80-community 3.4 M
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 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:
(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.aarc 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. Failing package is: mysql-community-client-plugins-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. Failing package is: mysql-community-common-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-icu-data-files-8.0.36-1.el9.aarch64.rpm is not installed. Failing package is: mysql-community-icu-data-files-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. Failing package is: mysql-community-server-8.0.36-1.el9.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
そこで指示通り「dnf clean packages」を入力しましたが、同じエラーが続きます。これを解決します。
エラーメッセージによると、MySQL 8.0 Community Server のパッケージを更新しようとしている際に GPG キーの不一致が発生しているようです。この問題を解決するためには、適切な GPG キーをインストールする必要があります。
ネット検索していると、新しい2023年のキーが利用可能であることがわかりました。この新しいキーをインポートして、問題を解決することができるかもしれません。以下の手順を試しました。
- 新しいMySQLのGPGキーをインポートします。これは、以下のコマンドを使用して行います。
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 - GPGキーが正しくインポートされたかを確認します。再び以下のコマンドを実行して、新しいキーがリストに含まれていることを確認します。
rpm -q gpg-pubkey --qf '%{NAME}-%{VERSION}-%{RELEASE}t%{SUMMARY}n' - 再度
dnf updateを実行します。新しいGPGキーがインストールされていれば、更新プロセスが成功する可能性が高まります。
もし、このプロセスを実行してもまだ問題が解決しない場合は、システムのリポジトリ設定を見直す必要があります。特に /etc/yum.repos.d/ ディレクトリ内のMySQL関連のリポジトリ設定ファイルに注目してください。その中で gpgkey の設定が最新のキー（2023年版）を指していることを確認してください。実行結果は以下になります。
[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
新しいMySQL GPGキー（2023年版）が正常にインポートされたようです。これで、MySQLパッケージのアップデート時に発生していたGPGキーの問題が解決される可能性が高まります。次に進んで、パッケージのアップデートを再度試みてみました。
- パッケージの更新を再実行します。
dnf updateコマンドを使用して、アップデートを試みてみます。dnf update - アップデートの実行中にエラーが発生しないかを確認します。特にMySQL関連のパッケージでGPGキーの問題が再発していないかをチェックしてくます。
- すべてが正常に完了したかを確認します。アップデートが無事に完了すれば、これで問題は解決されたはずです。
私は、この方法で解決できました。
[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 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
aarch64 8.0.36-1.el9 mysql80-community 3.4 M
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 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:
[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-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.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.131.27.el9uek.aarch64
kernel-uek-modules-5.15.0-200.131.27.el9uek.aarch64
Complete!