MYSQL issue and failed MYSQL upgrade
Starting process with log file at /var/cpanel/logs/mysql_upgrade.20250123-071623/upgrade_mysql_with_status.log
Obtained version information from system.
Obtained version information from system.
(XID qrcnbz) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2))
Ensuring the “Mysql57” repository is available and working.
checkyum version 22.3 (excludes: bind-chroot ruby)
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 “5.7” is available.
Ensuring that the package “mysql-community-libs-compat” with version matching “5.7” is available.
Ensuring that the package “mysql-community-server” with version matching “5.7” 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 “Mysql57” repository is available and working.
Installing pre-known Mysql dependencies.
Installed pre-known Mysql dependencies.
Ensuring Mysql RPMs for version “5.7”.
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, security, universal-hooks
Setting up Install Process
Loading mirror speeds from cached hostfile
* EA4: 185.15.22.168
* cpanel-addons-production-feed: 185.15.22.168
* cpanel-plugins: 185.15.22.168
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-devel.x86_64 0:5.7.44-1.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-devel-5.7.44-1.el6.x86_64
--> Processing Dependency: libmysqlclient.so.20()(64bit) for package: mysql-community-devel-5.7.44-1.el6.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-server.x86_64 0:5.7.44-1.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.44-1.el6 for package: mysql-community-server-5.7.44-1.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.44-1.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-common.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-libs.x86_64 0:5.7.44-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-devel x86_64 5.7.44-1.el6 mysql57-community 4.7 M
mysql-community-libs-compat x86_64 5.7.44-1.el6 mysql57-community 1.7 M
mysql-community-server x86_64 5.7.44-1.el6 mysql57-community 172 M
Installing for dependencies:
mysql-community-client x86_64 5.7.44-1.el6 mysql57-community 30 M
mysql-community-common x86_64 5.7.44-1.el6 mysql57-community 373 k
mysql-community-libs x86_64 5.7.44-1.el6 mysql57-community 3.0 M
Transaction Summary
================================================================================
Install 6 Package(s)
Total size: 212 M
Installed size: 988 M
Exiting on user Command
Your transaction was saved, rerun it with:
yum load-transaction /root/tmp/yum_save_tx-2025-01-23-07-16gbWrSR.yumtx
Preinstall check passed.
Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MySQL57,MariaDB100,MariaDB101,MariaDB102,MariaDB103 --fix --no-broken --no-digest
Installing Mysql from official repository.
Hooks system enabled.
Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
All required 'pre' hooks have been run
Looking for providers that will cause dependency problems: mysql-server
Removing incompatible packages.
Loaded plugins: fastestmirror, security, universal-hooks
Setting up Install Process
Loading mirror speeds from cached hostfile
* EA4: 185.15.22.168
* cpanel-addons-production-feed: 185.15.22.168
* cpanel-plugins: 185.15.22.168
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-devel.x86_64 0:5.7.44-1.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-devel-5.7.44-1.el6.x86_64
--> Processing Dependency: libmysqlclient.so.20()(64bit) for package: mysql-community-devel-5.7.44-1.el6.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-server.x86_64 0:5.7.44-1.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.44-1.el6 for package: mysql-community-server-5.7.44-1.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.44-1.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-common.x86_64 0:5.7.44-1.el6 will be installed
---> Package mysql-community-libs.x86_64 0:5.7.44-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-devel x86_64 5.7.44-1.el6 mysql57-community 4.7 M
mysql-community-libs-compat x86_64 5.7.44-1.el6 mysql57-community 1.7 M
mysql-community-server x86_64 5.7.44-1.el6 mysql57-community 172 M
Installing for dependencies:
mysql-community-client x86_64 5.7.44-1.el6 mysql57-community 30 M
mysql-community-common x86_64 5.7.44-1.el6 mysql57-community 373 k
mysql-community-libs x86_64 5.7.44-1.el6 mysql57-community 3.0 M
Transaction Summary
================================================================================
Install 6 Package(s)
Total size: 212 M
Installed size: 988 M
Downloading Packages:
warning: rpmts_HdrFromFdno: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
The GPG keys listed for the "MySQL 5.7 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.
Restarting mysql service.
(XID rvma9h) The “mysql” service is disabled.
(XID 35z5wr) “/usr/bin/yum” reported error code “1” when it ended:
Obtained version information from system.
Proceeding with MySQL/MariaDB upgrade despite the following:
Critical: The system failed to query the MySQL server to check for the presence of pre-4.1-style MySQL passwords. ((XID g65kb8) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2))) This issue could also hinder mysql_upgrade's ability to run, which could potentially leave MySQL in an unusable state if you proceed.
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. Critical: The update could not reach the MySQL server to check for the existence of a database named 'sys'. This issue could also hinder mysql_upgrade's ability to run, which could potentially leave MySQL in an unusable state if you proceed.
-
I'm glad we were able to sort this out for you.
Andrew N. - cPanel Plesk VMWare Certified Professional
Do you need immediate assistance? 20 minutes response time!* Open a ticket
EmergencySupport - Professional Server Management and One-time Services0 -
Could you share what the fix was?
0 -
The GPG keys listed for the "MySQL 5.7 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.I have replaced the GPG keys with the new ones in the repos and the upgrade went through.
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
Andrew N. - cPanel Plesk VMWare Certified Professional
Do you need immediate assistance? 20 minutes response time!* Open a ticket
EmergencySupport - Professional Server Management and One-time Services1
Please sign in to leave a comment.
Comments
3 comments