Startup Timout

[Jamie Howard]

Hi there - I'm trying to upgrade inplace from mysql5.7 to mysql8

I've used xtrabackup to move the files over and prepare them, however - whenever I start mysql - It always fails to upgrade after exactly 5 minutes (feels like a system timeout setting)

I've run the util.checkForServerUpgrade() and get only warnings and notices - it tells me its ready for upgrade.

There's around 300 databases - so I upped things like ulimits on max files and I also edited the systemd startup to

TimeoutSec=3600

It's a Redhat EL8.8 Server.

Running this command verifies the timeout value:

systemctl show mysqld.service -p TimeoutStartUSec
TimeoutStartUSec=1h

Yet the mysqld.log goes like this:
2023-06-30T12:01:32.755955Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-06-30T12:01:32.755990Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.32) starting as process 198071
2023-06-30T12:01:32.764137Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2023-06-30T12:01:32.764208Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-06-30T12:01:35.729153Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-06-30T12:04:21.227230Z 2 [ERROR] [MY-013140] [Server] Too many key parts specified; max 1 parts allowed
2023-06-30T12:05:08.130882Z 2 [Warning] [MY-013729] [InnoDB] Column coordinates 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.
2023-06-30T12:06:18.746110Z 2 [Warning] [MY-010778] [Server] Parsing 'mydbr_lifecarepro.sp_DBR_lifecarepro_client_contacts' routine body failed. Creating routine without parsing routine body
2023-06-30T12:06:19.421158Z 2 [Warning] [MY-010778] [Server] Parsing 'mydbr_reports.sp_DBR_lifecarepro_client_contacts' routine body failed. Creating routine without parsing routine body
2023-06-30T12:06:19.442389Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
2023-06-30T12:06:21.457175Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2023-06-30T12:06:21.457249Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-06-30T12:06:28.190207Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.32) Source distribution.

It's really weird - I've tried both

systemctl start mysqld.service

AND

runuser -u mysql -- mysqld

It makes no difference - it just times out after 5 minutes.

Please can you help?