MySQL upgrade from 5.6 to 5.7 not working

Shirvo

Registered
Mar 25, 2015
4
0
51
Australia
cPanel Access Level
Root Administrator
Hi All,

I have been trying to update the MySQL server from 5.6 to 5.7 and the upgrade fails.

I have tried several things that I have seen in these forums and other online forums with no success.

Anyone that would be able to point out the Error in this upgrade output would be amazing.
I have checked the MySQL error log and there didn't seem to be anything in there telling me the problem either.



Starting process with log file at /var/cpanel/logs/mysql_upgrade.20201001-193749/upgrade_mysql_with_status.log
Obtained version information from system.
Ensuring the “Mysql57” repository is available and working.
checkyum version 22.3 (excludes: bind-chroot ruby)
Restarting mysql service.
Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

Service Status
mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 35110 (systemd+/proc check method).

Startup Log
Oct 01 19:37:52 ****************************** systemd[1]: Started MySQL Server.
Oct 01 19:37:52 ****************************** mysqld_safe[35110]: 201001 19:37:52 mysqld_safe Logging to '/var/lib/mysql/***************************.err'.
Oct 01 19:37:52 ****************************** mysqld_safe[35110]: 201001 19:37:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Log Messages
2020-10-01 19:37:53 35250 [Note] /usr/sbin/mysqld: ready for connections.
201001 19:37:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
201001 19:37:52 mysqld_safe Logging to '/var/lib/mysql/******************************.err'.
201001 19:37:52 mysqld_safe mysqld from pid file /var/lib/mysql/****************************.pid ended
2020-10-01 19:37:52 34012 [Note] /usr/sbin/mysqld: Shutdown complete
2020-10-01 19:37:50 34012 [Note] /usr/sbin/mysqld: Normal shutdown
2020-10-01 19:23:41 34012 [Note] /usr/sbin/mysqld: ready for connections.

mysql restarted successfully.
Multiple versions of the coreutils are installed: coreutils 8.22-23.el7
coreutils 8.22-24.el7
grep 2.20-3.el7
package mysql-community-devel is not installed
package mysql-community-libs-compat is not installed
package mysql-community-server is not installed
perl-DBI 1.627-4.el7
shadow-utils 4.1.5.1-25.el7_6.1
shadow-utils 4.6-5.el7 at /usr/local/cpanel/Cpanel/SysPkgs/YUM.pm line 594.
Obtained version information from system.
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.
 
Last edited:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,268
313
Houston
This is most commonly the result of having duplicate packages on the system:

Code:
Multiple versions of the coreutils are installed: coreutils 8.22-23.el7
coreutils 8.22-24.el7
grep 2.20-3.el7
package mysql-community-devel is not installed
package mysql-community-libs-compat is not installed
package mysql-community-server is not installed
perl-DBI 1.627-4.el7
shadow-utils 4.1.5.1-25.el7_6.1
shadow-utils 4.6-5.el7 at /usr/local/cpanel/Cpanel/SysPkgs/YUM.pm line 594.

The thread here goes over this as well:

The following should remove duplicate RPM's
Code:
package-cleanup --cleandupes
But you can check once that is run to ensure that you don't have any remaining:

Code:
rpm -qa |grep coreutils