MySQL Upgrade process failed - The GPG keys listed for the "MySQL 8.0 Community Server" repository are already installed but they are not correct for

Guile

Well-Known Member
Apr 25, 2003
85
3
158
Hi,

Using the MySQL/MariaDB Upgrade from 5.7 to 8.0 I get the error below:

Code:
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-devel-8.0.28-1.el7.x86_64
GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql
Full log:

Code:
Starting process with log file at /var/cpanel/logs/mysql_upgrade.20220117-124347/unattended_upgrade.log
Beginning “MySQL 8.0” upgrade...
Obtained version information from system.
Ensuring the “Mysql80” repository is available and working.
distro does not use package modules; ignoring request to disable mysql
distro does not use package modules; ignoring request to disable mariadb
checkyum version 22.3 (excludes: bind-chroot)
Ensuring that the package “coreutils” is available.
The package “coreutils” with version matching “” is already installed.
Ensuring that the package “grep” is available.
The package “grep” with version matching “” is already installed.
Ensuring that the package “mysql-community-devel” with version matching “8.0” is available.
Ensuring that the package “mysql-community-libs-compat” with version matching “8.0” is available.
Ensuring that the package “mysql-community-server” with version matching “8.0” is available.
Ensuring that the package “perl-DBI” is available.
The package “perl-DBI” with version matching “” is already installed.
Ensuring that the package “shadow-utils” is available.
The package “shadow-utils” with version matching “” is already installed.
The “Mysql80” repository is available and working.
Installing pre-known Mysql dependencies.
Installed pre-known Mysql dependencies.
Ensuring Mysql RPMs for version “8.0”.
Verifying that the system is in a state where Mysql packages can be installed.
Verifying that the Mysql packages can be installed by doing a test install.
checkyum version 22.3 (excludes: bind-chroot)
Loaded plugins: fastestmirror, universal-hooks
Loading mirror speeds from cached hostfile
* EA4: 208.100.0.204
* EA4-experimental: 208.100.0.204
* cpanel-plugins: 208.100.0.204
* base: nyc.mirrors.clouvider.net
* epel: epel.mirror.constant.com
* extras: centos.mirror.constant.com
* remi-safe: mirror.pit.teraswitch.com
* updates: ewr.edge.kernel.org
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-devel.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-devel.x86_64 0:8.0.28-1.el7 will be an update
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-devel-8.0.28-1.el7.x86_64
--> Processing Dependency: libmysqlclient.so.21()(64bit) for package: mysql-community-devel-8.0.28-1.el7.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-libs-compat.x86_64 0:8.0.28-1.el7 will be an update
---> Package mysql-community-server.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-server.x86_64 0:8.0.28-1.el7 will be an update
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-client.x86_64 0:8.0.28-1.el7 will be an update
--> Processing Dependency: mysql-community-client-plugins = 8.0.28-1.el7 for package: mysql-community-client-8.0.28-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-common.x86_64 0:8.0.28-1.el7 will be an update
---> Package mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-libs.x86_64 0:8.0.28-1.el7 will be an update
--> Running transaction check
---> Package mysql-community-client-plugins.x86_64 0:8.0.28-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
mysql-community-devel x86_64 8.0.28-1.el7 Mysql80-community 7.4 M
mysql-community-libs-compat x86_64 8.0.28-1.el7 Mysql80-community 1.2 M
mysql-community-server x86_64 8.0.28-1.el7 Mysql80-community 451 M
Installing for dependencies:
mysql-community-client-plugins x86_64 8.0.28-1.el7 Mysql80-community 5.7 M
mysql-community-icu-data-files x86_64 8.0.28-1.el7 Mysql80-community 2.1 M
Updating for dependencies:
mysql-community-client x86_64 8.0.28-1.el7 Mysql80-community 53 M
mysql-community-common x86_64 8.0.28-1.el7 Mysql80-community 630 k
mysql-community-libs x86_64 8.0.28-1.el7 Mysql80-community 4.7 M

Transaction Summary
================================================================================
Install ( 2 Dependent packages)
Upgrade 3 Packages (+3 Dependent packages)

Total download size: 526 M
Exiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /root/tmp/yum_save_tx.2022-01-17.12-45.pPPgcq.yumtx
Preinstall check passed.
Running: /usr/local/cpanel/scripts/check_cpanel_pkgs --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MySQL57,MySQL80,MariaDB100,MariaDB101,MariaDB102,MariaDB103,MariaDB105,MariaDB106 --fix --no-broken --no-digest
Installing Mysql from official repository.
distro does not use package modules; ignoring request to disable mysql
distro does not use package modules; ignoring request to disable mariadb
Hooks system enabled.
Checking for and running RPM::Versions 'pre' hooks for any Packages about to be installed
All required 'pre' hooks have been run
Looking for providers that will cause dependency problems: mysql-server
Uninstalling the following via “rpm” prior to “yum” to avoid dependency problems: mysql-community-server-5.7.36-1.el7.x86_64
Removing any of the following incompatible packages: mariadb-client mariadb-devel mariadb-embedded mariadb-embedded-devel mariadb-libs mariadb-libs-compat mariadb-release mariadb-server mariadb-test mysqlclient16 mysql-client mysql-devel mysql-embedded mysql-embedded-devel mysql-libs mysql-libs-compat mysql-release mysql-server mysql-test mysql55-mysql-bench mysql55-mysql-devel mysql55-mysql-libs mysql55-mysql-server mysql55-mysql-test rh-mysql56-mysql-bench rh-mysql56-mysql-common rh-mysql56-mysql-config rh-mysql56-mysql-devel rh-mysql56-mysql-errmsg rh-mysql56-mysql-server rh-mysql56-mysql-test rh-mysql57-mysql-common rh-mysql57-mysql-config rh-mysql57-mysql-devel rh-mysql57-mysql-errmsg rh-mysql57-mysql-server rh-mysql57-mysql-test
Loaded plugins: fastestmirror, universal-hooks
Loading mirror speeds from cached hostfile
* EA4: 208.100.0.204
* EA4-experimental: 208.100.0.204
* cpanel-plugins: 208.100.0.204
* base: nyc.mirrors.clouvider.net
* epel: epel.mirror.constant.com
* extras: centos.mirror.constant.com
* remi-safe: mirror.pit.teraswitch.com
* updates: ewr.edge.kernel.org
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-devel.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-devel.x86_64 0:8.0.28-1.el7 will be an update
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-devel-8.0.28-1.el7.x86_64
--> Processing Dependency: libmysqlclient.so.21()(64bit) for package: mysql-community-devel-8.0.28-1.el7.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-libs-compat.x86_64 0:8.0.28-1.el7 will be an update
---> Package mysql-community-server.x86_64 0:8.0.28-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.28-1.el7 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.28-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-client.x86_64 0:8.0.28-1.el7 will be an update
--> Processing Dependency: mysql-community-client-plugins = 8.0.28-1.el7 for package: mysql-community-client-8.0.28-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-common.x86_64 0:8.0.28-1.el7 will be an update
---> Package mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:5.7.36-1.el7 will be updated
---> Package mysql-community-libs.x86_64 0:8.0.28-1.el7 will be an update
--> Running transaction check
---> Package mysql-community-client-plugins.x86_64 0:8.0.28-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-server x86_64 8.0.28-1.el7 Mysql80-community 451 M
Updating:
mysql-community-devel x86_64 8.0.28-1.el7 Mysql80-community 7.4 M
mysql-community-libs-compat x86_64 8.0.28-1.el7 Mysql80-community 1.2 M
Installing for dependencies:
mysql-community-client-plugins x86_64 8.0.28-1.el7 Mysql80-community 5.7 M
mysql-community-icu-data-files x86_64 8.0.28-1.el7 Mysql80-community 2.1 M
Updating for dependencies:
mysql-community-client x86_64 8.0.28-1.el7 Mysql80-community 53 M
mysql-community-common x86_64 8.0.28-1.el7 Mysql80-community 630 k
mysql-community-libs x86_64 8.0.28-1.el7 Mysql80-community 4.7 M

Transaction Summary
================================================================================
Install 1 Package (+2 Dependent packages)
Upgrade 2 Packages (+3 Dependent packages)

Total download size: 526 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
warning: /var/cache/yum/x86_64/7/Mysql80-community/packages/mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Public key for mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm is not installed
--------------------------------------------------------------------------------
Total 91 MB/s | 526 MB 00:05
Retrieving key from http://repo.mysql.com/RPM-GPG-KEY-mysql


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-devel-8.0.28-1.el7.x86_64
GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql

Restarting mysql service.
(XID 399r47) The “mysql” service is disabled.
(XID xynnvx) “/usr/bin/yum” reported error code “1” when it ended:
Obtained version information from mysql data files.
Proceeding with MySQL/MariaDB upgrade despite the following:
Critical: MySQL enables "strict mode" by default as of version 5.7. Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MySQL are compatible before upgrading. More information about strict mode is available here.
 

Guile

Well-Known Member
Apr 25, 2003
85
3
158
For what it's worth, because the above upgrade process failed and the MySQL server was down, I upgraded to MariaDB 10.2 instead, and the MySQL server is back up.
 

cPAdminsMichael

Well-Known Member
Dec 19, 2016
184
66
153
Denmark
cPanel Access Level
Root Administrator
It's a known issue:

You can run the autorepair script or just import the new GPG key (rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022)
and then run /scripts/upcp again manually should complete without errors.

Alternatively, the autorepair will be automatically executed on next nightly update.
 
  • Like
Reactions: IndicHosts.net