Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Following mysql-8.0.19-r1 upgrade it won't start
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
MickKi
Veteran
Veteran


Joined: 08 Feb 2004
Posts: 1162

PostPosted: Sat Mar 07, 2020 4:19 pm    Post subject: Following mysql-8.0.19-r1 upgrade it won't start Reply with quote

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
View user's profile Send private message
Banana
l33t
l33t


Joined: 21 May 2004
Posts: 857
Location: Germany

PostPosted: Mon Mar 09, 2020 9:43 am    Post subject: Reply with quote

Hello MickKi,

did you run as root
Quote:
mysql_upgrade --user=root -p
?
_________________
My personal space
Back to top
View user's profile Send private message
MickKi
Veteran
Veteran


Joined: 08 Feb 2004
Posts: 1162

PostPosted: Mon Mar 09, 2020 12:12 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum