| View previous topic :: View next topic |
| Author |
Message |
MickKi
Veteran
Joined: 08 Feb 2004
Posts: 1179
|
 Posted: Sat Mar 07, 2020 4:19 pm Post subject: Following mysql-8.0.19-r1 upgrade it won't start |
 |
|
Hi All,
Something went wrong following an upgrade of mysql on a standby server and mysql and consequently the boot process hangs until mysql times out:
| Code: | # rc-service -v mysql start
* Executing: /lib/rc/sh/openrc-run.sh /lib/rc/sh/openrc-run.sh /etc/init.d/mysql start
* Checking mysqld configuration for mysql ... [ ok ]
* Starting mysql ...
* start-stop-daemon: fopen `/var/run/mysqld/mysql.pid': No such file or directory
* Detaching to start `/usr/sbin/mysqld' ...
* Waiting for /var/run/mysqld/mysqld.sock ...
* timed out waiting for /var/run/mysqld/mysqld.sock [ !! ]
* ERROR: mysql failed to start |
The logs show:
| Code: | 2020-03-07T15:39:07.730308Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 5672
2020-03-07T15:39:07.755740Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2020-03-07T15:39:24.100336Z 0 [Warning] [MY-010727] [Server] System table 'plugin' is expected to be transactional.
2020-03-07T15:39:52.654023Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
2020-03-07T15:40:01.853604Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `event`" or dump/reload to fix it!
2020-03-07T15:40:53.205267Z 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)..
2020-03-07T15:40:53.212618Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_leap_second' is expected to be transactional.
2020-03-07T15:40:53.213304Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_name' is expected to be transactional.
2020-03-07T15:40:53.213917Z 0 [Warning] [MY-010727] [Server] System table 'time_zone' is expected to be transactional.
2020-03-07T15:40:53.214558Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_transition_type' is expected to be transactional.
2020-03-07T15:40:53.215201Z 0 [Warning] [MY-010727] [Server] System table 'time_zone_transition' is expected to be transactional.
2020-03-07T15:40:53.218399Z 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)..
2020-03-07T15:40:53.715045Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2020-03-07T15:40:53.716349Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-03-07T15:40:57.316658Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19) Gentoo Linux mysql-8.0.19-r1. |
Is there a fix to this problem to be able to restart the database?
_________________
Regards,
Mick |
|
| Back to top |
|
 |
Banana
Moderator
Joined: 21 May 2004
Posts: 2000
Location: Germany
|
|
| Back to top |
|
|
MickKi
Veteran
Joined: 08 Feb 2004
Posts: 1179
|
| Posted: Mon Mar 09, 2020 12:12 pm Post subject: |
|
|
Unfortunately, I didn't see any notice or warning offered by portage when upgrading from mysql-5.7.x to 8.0.19-r1 to NOT DO IT, unless and until I had followed some process to achieve this successfully.
I decided I didn't have time to start modifying tables one at a time to get the old installation working, so I had to ditch the old /var/lib/mysql directory and start afresh with emerge --config before I reimported a dozen or so hosted databases from backups. I'll restart the db tomorrow to see what gives, but hope all should be working fine afterwards.
_________________
Regards,
Mick |
|
| Back to top |
|
|
|
Portage & Programming
