News:

SMF - Just Installed!

Main Menu

mysql failed to start after upgrade

Started by kalpana, Oct 10, 2023, 04:29 AM

Previous topic - Next topic

kalpana

I upgraded mysql to 8 and now it fails to start.
I get this error in log file:
Code:
2023-07-27T13:28:04.630518Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33-0ubuntu0.22.04.4) starting as process 10696
2023-07-27T13:28:04.642604Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-27T13:28:04.955359Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-27T13:28:05.450531Z 4 [System] [MY-013381] [Server] Server upgrade from '80031' to '80033' started.
2023-07-27T13:28:55.534053Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'EXECUTE stmt; ' failed with error code = 1205, error message = 'Lock wait timeout exceeded; try restarting transaction'.
2023-07-27T13:28:55.535908Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2023-07-27T13:28:55.536059Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-07-27T13:28:56.710946Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.22.04.4)  (Ubuntu).

The hosting server is on digitalocean droplet (1GB ram, 1CPU)