MySQL Wont Start after Upgrading to CustomBuild 2.0

P

Panos Georgakop

Verified User
Joined
Dec 5, 2018
Messages
8
Hello,
After the upgrade to CustomBuild 2.0 the service of mysqld will not start. I tried to upgrade it from 5.7 to 8 with no result. Can someone help me fix this?
 
My log right now is this.
[root@gweb5 log]# tail -40 /var/lib/mysql/`hostname -f`.err
2022-02-13T21:45:47.332964Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_users`" or dump/reload to fix it!
2022-02-13T21:45:47.684709Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_posts`" or dump/reload to fix it!
2022-02-13T21:45:47.770667Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_links`" or dump/reload to fix it!
2022-02-13T21:45:48.156712Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_irecommendthis_votes`" or dump/reload to fix it!
2022-02-13T21:45:48.156823Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_em_themes`" or dump/reload to fix it!
2022-02-13T21:45:48.183620Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_em_modals`" or dump/reload to fix it!
2022-02-13T21:45:48.215580Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `ypwp_comments`" or dump/reload to fix it!
2022-02-13T21:46:00.020316Z 2 [Warning] [MY-013729] [InnoDB] Column cornerA of type GEOMETRY is in old (5.6) format which could be deprecated in the future. To change the format to latest, please consider rebuilding the table after the upgrade.
2022-02-13T21:46:00.020383Z 2 [Warning] [MY-013729] [InnoDB] Column cornerB of type GEOMETRY is in old (5.6) format which could be deprecated in the future. To change the format to latest, please consider rebuilding the table after the upgrade.
2022-02-13T21:46:00.205173Z 2 [Warning] [MY-013729] [InnoDB] Column center of type GEOMETRY is in old (5.6) format which could be deprecated in the future. To change the format to latest, please consider rebuilding the table after the upgrade.
2022-02-13T21:46:00.249212Z 2 [Warning] [MY-013729] [InnoDB] Column latlng of type GEOMETRY is in old (5.6) format which could be deprecated in the future. To change the format to latest, please consider rebuilding the table after the upgrade.
2022-02-13T21:46:05.265925Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `proxies_priv`" or dump/reload to fix it!
2022-02-13T21:46:06.290098Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_wfSNIPCache`" or dump/reload to fix it!
2022-02-13T21:46:07.109639Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_users`" or dump/reload to fix it!
2022-02-13T21:46:07.317655Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_posts`" or dump/reload to fix it!
2022-02-13T21:46:07.676796Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_links`" or dump/reload to fix it!
2022-02-13T21:46:08.078890Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_itsec_log`" or dump/reload to fix it!
2022-02-13T21:46:08.289397Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_translation_status`" or dump/reload to fix it!
2022-02-13T21:46:08.289508Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_translation_batches`" or dump/reload to fix it!
2022-02-13T21:46:08.289611Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_translate_job`" or dump/reload to fix it!
2022-02-13T21:46:08.289706Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_translate`" or dump/reload to fix it!
2022-02-13T21:46:08.357518Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_string_translations`" or dump/reload to fix it!
2022-02-13T21:46:08.357630Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_string_status`" or dump/reload to fix it!
2022-02-13T21:46:08.489795Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_message_status`" or dump/reload to fix it!
2022-02-13T21:46:08.822765Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_icl_content_status`" or dump/reload to fix it!
2022-02-13T21:46:08.827379Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pfwp_comments`" or dump/reload to fix it!
2022-02-13T21:46:12.128213Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pma__userconfig`" or dump/reload to fix it!
2022-02-13T21:46:12.128421Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pma__tracking`" or dump/reload to fix it!
2022-02-13T21:46:12.128587Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pma__table_uiprefs`" or dump/reload to fix it!
2022-02-13T21:46:12.361081Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `pma__history`" or dump/reload to fix it!
2022-02-13T21:46:12.584615Z 2 [ERROR] [MY-011060] [Server] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(93), found type char(77)..
2022-02-13T21:46:12.591446Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_leap_second' is expected to be transactional.
2022-02-13T21:46:12.604395Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_name' is expected to be transactional.
2022-02-13T21:46:12.619391Z 0 [Warning] [MY-010727] [Server] System table 'time_zone' is expected to be transactional.
2022-02-13T21:46:12.634221Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_transition_type' is expected to be transactional.
2022-02-13T21:46:12.634254Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_transition' is expected to be transactional.
2022-02-13T21:46:12.635592Z 2 [ERROR] [MY-011060] [Server] Incorrect definition of table mysql.proc: expected column 'definer' at position 11 to have type char(93), found type char(77)..
2022-02-13T21:46:12.691215Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2022-02-13T21:46:12.694835Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-02-13T21:46:18.520902Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28) MySQL Community Server - GPL.
 
I tried to run mysql_upgrade but with no luck. I Am getting the message:
The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.

Is there anyone that has any suggestion solving this?
 
Its an big leap 5.7 to 8, repair your tables first before update or as suggested dump/restore.
Try to make upgrade with steps like 5.6 -> 5.7 -> 5.8 and backup first !
 
Hello,
how do i repair the tables without the mysqld running? I have all the DBs backed up but i cannot get mysqld to run.
 
The problem was solved after DA Ticket. The solution was to downgrade from mysql 8.0 to 5.7 and then run mysql_upgrade.
 
You must log in or register to reply here.
Back
Top