MySQL upgrade from 5.6 to 5.7 not working

Shirvo

• October 01, 2020 04:51

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.

• 

  ffeingol

  • October 01, 2020 11:46

  I'd suggest opening a cPanel support ticket. They should be able to help you.

  0
• 

  cPanelLauren

  • October 02, 2020 21:53

  This is most commonly the result of having duplicate packages on the system: 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:

  0

Please sign in to leave a comment.