MySQL Forums
Forum List  »  General

Re: Error upgrading from 5.7.28 to 8.0.17
Posted by: Mike Danchanko
Date: June 26, 2020 07:41AM

I am having the same issue, how did you resolve this?

The upgrade fails with MYSQL not restarting.


Waiting for “mysql” to start ………Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …failed.

Cpanel::Exception::Services::StartError Service Status
undefined status from Cpanel::ServiceManager::Services::Mysql

Service Error
(XID ytdjmd) The “mysql” service failed to start.

Startup Log
Jun 26 09:35:54 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:35:54.412110Z 2 [ERROR] [MY-012064] [InnoDB] Column datatype mismatch for col: center
Jun 26 09:35:54 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:35:54.413027Z 2 [ERROR] [MY-012070] [InnoDB] Column center for table: `wchaonli_mysql1`.`wp1_wpgmza_circles` mismatches with InnoDB Dictionary
Jun 26 09:35:54 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:35:54.413933Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for wchaonli_mysql1.wp1_wpgmza_circles
Jun 26 09:36:05 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:36:05.140476Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
Jun 26 09:36:05 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:36:05.143944Z 0 [ERROR] [MY-010119] [Server] Aborting
Jun 26 09:36:06 dml1.digitaliwayhost.net mysqld[48443]: 2020-06-26T13:36:06.528400Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
Jun 26 09:36:06 dml1.digitaliwayhost.net systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Jun 26 09:36:06 dml1.digitaliwayhost.net systemd[1]: Failed to start MySQL Server.
Jun 26 09:36:06 dml1.digitaliwayhost.net systemd[1]: Unit mysqld.service entered failed state.
Jun 26 09:36:06 dml1.digitaliwayhost.net systemd[1]: mysqld.service failed.

Log Messages
Jun 26 09:36:06 dml1 mysqld: 2020-06-26T13:36:06.528400Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
180509 07:30:44 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
2018-05-09 07:30:43 1254 [Note] /usr/sbin/mysqld: Shutdown complete
2018-05-09 07:30:40 1254 [Note] /usr/sbin/mysqld: Normal shutdown
2018-05-09 07:23:15 1254 [Note] /usr/sbin/mysqld: ready for connections.
180509 07:23:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180509 07:23:14 mysqld_safe Logging to '/var/lib/mysql/dml1.digitaliwayhost.net.err'.
180509 07:20:36 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
2018-05-09 07:20:36 15517 [Note] /usr/sbin/mysqld: Shutdown complete

mysql has failed. Contact your system administrator if the service does not automagically recover.

Options: ReplyQuote


Subject
Written By
Posted
Re: Error upgrading from 5.7.28 to 8.0.17
June 26, 2020 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.