MySQL 8.0.37 upgrade never completes
Posted by: Mike Fox
Date: July 02, 2025 06:42AM
Date: July 02, 2025 06:42AM
I'm hoping someone can help me with this issue.
We have been tracking this issue for a couple of years now, and we were promised by the developer of this application that the latest release would fix the issue we have.
To allow us to investigate and not affect the production server, I have built a test system so we can investigate the issue.
I'm not a MySQL expert by a long stretch and so some of this may be obvious, but I'd really appreciate any pointers you could give me so we can get to the bottom of the issue.
We have an application which relies on MySQL to hold the data for that app. It is currently running on version 8.0.30.
Each new iteration of the app so versions 2023, 2024 and 2025 (now) requires the MySQL to be updated before we can update the app - the issue is that the MySQL upgrade always fails.
2023 versions updated from 8.0.30 to 8.0.32 which failed.
2024 version updated from 8.0.30 to 8.0.34 which failed
2025 version updates from 8.0.30 to 8.0.37 which also fails.
The log file pretty much shows this
Attempting to start service MySQL....
'--sync-relay-log-info' is deprecated and will be removed in a future release.
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 35188
--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
InnoDB initialization has started.......
InnoDB initialization has ended.............
MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
Ended configuration step: Starting the server and upgrading system tables (may take a long time)
Server upgrade from '80030' to '80037' started...
•.....
At some point later the upgrade will then go from 8.0.30 to 8.0.37 and then it sits for days attempting to start the MySQL service - the strange thing is the MySQL service is actually started.
In the error log I see the following
DateTime=2025-06-30T08:32:06.6780355Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T08:32:08.3971921Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T08:32:08.4821861Z
mysql-installer Information: 10 : Inherited permissions have been converted to explicit permissions.
DateTime=2025-06-30T09:37:37.3726739Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T10:01:35.2420464Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T10:25:17.9984920Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T10:48:04.4009846Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T11:10:29.6651468Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T11:52:33.2949879Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T11:52:33.3799881Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Service MySQL is stopped or paused, so it can be started.
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Attempting to start the MySQL service...
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Information: 10 : '--sync-relay-log-info' is deprecated and will be removed in a future release.
DateTime=2025-06-30T11:52:37.4450356Z
mysql-installer Information: 10 : 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
DateTime=2025-06-30T11:52:37.4600921Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 5380
DateTime=2025-06-30T11:52:37.4800559Z
mysql-installer Information: 10 : --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
DateTime=2025-06-30T11:52:37.5010332Z
mysql-installer Information: 10 : InnoDB initialization has started.
DateTime=2025-06-30T11:52:38.5493586Z
mysql-installer Error: 50 : Time out has expired and the operation has not been completed.
Thrown by: Logger.LogException
DateTime=2025-06-30T11:54:06.5268909Z
mysql-installer Information: 10 : MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
DateTime=2025-06-30T11:54:06.5518852Z
mysql-installer Error: 50 : A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
DateTime=2025-06-30T11:54:06.5738974Z
mysql-installer Information: 10 : Finished configuration of MySQL Server 8.0.37 with state ConfigurationError
DateTime=2025-06-30T11:54:06.5928970Z
mysql-installer Information: 10 : InnoDB initialization has ended.
DateTime=2025-06-30T11:54:23.9383026Z
mysql-installer Information: 10 : Beginning ConfigApplyPage.
DateTime=2025-06-30T11:57:55.1867137Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T11:57:55.2158585Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T11:57:55.2447130Z
mysql-installer Error: 50 : The trust relationship between this workstation and the primary domain failed.
Thrown by: Logger.LogException
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Error: 50 : Failed to obtain SID for the 'LocalSystem' NT account.
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' started.
DateTime=2025-06-30T12:02:10.4096607Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' completed.
DateTime=2025-06-30T12:04:34.9398147Z
mysql-installer Information: 10 : CA certificate ca.pem is self signed.
DateTime=2025-06-30T12:04:56.0419886Z
mysql-installer Information: 10 : Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
DateTime=2025-06-30T12:04:56.0539876Z
mysql-installer Information: 10 : X Plugin ready for connections. Bind-address: '::' port: 33060
DateTime=2025-06-30T12:04:57.1128137Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.37' socket: '' port: 3306 MySQL Community Server - GPL.
DateTime=2025-06-30T12:04:57.1278127Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T12:25:09.6747887Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T12:48:44.6175666Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T13:12:22.5709476Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T13:33:22.4361905Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T13:54:23.7668237Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T13:54:23.8088260Z
mysql-installer Verbose: 5 : 30/06/2025 14:54:23 - Service MySQL is running already.
DateTime=2025-06-30T13:54:23.8118256Z
mysql-installer Information: 10 : 2025-07-01T01:30:08.593804Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-01T01:30:09.6340342Z
mysql-installer Information: 10 : 2025-07-02T01:30:18.475350Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-02T01:30:18.8389154Z
It is almost like a timeout issue as about 30 seconds after the error message to state that MySQL cannot be started you can see that the service does start.
Any help or places to look would be really appreciated.
We have been tracking this issue for a couple of years now, and we were promised by the developer of this application that the latest release would fix the issue we have.
To allow us to investigate and not affect the production server, I have built a test system so we can investigate the issue.
I'm not a MySQL expert by a long stretch and so some of this may be obvious, but I'd really appreciate any pointers you could give me so we can get to the bottom of the issue.
We have an application which relies on MySQL to hold the data for that app. It is currently running on version 8.0.30.
Each new iteration of the app so versions 2023, 2024 and 2025 (now) requires the MySQL to be updated before we can update the app - the issue is that the MySQL upgrade always fails.
2023 versions updated from 8.0.30 to 8.0.32 which failed.
2024 version updated from 8.0.30 to 8.0.34 which failed
2025 version updates from 8.0.30 to 8.0.37 which also fails.
The log file pretty much shows this
Attempting to start service MySQL....
'--sync-relay-log-info' is deprecated and will be removed in a future release.
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 35188
--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
InnoDB initialization has started.......
InnoDB initialization has ended.............
MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
Ended configuration step: Starting the server and upgrading system tables (may take a long time)
Server upgrade from '80030' to '80037' started...
•.....
At some point later the upgrade will then go from 8.0.30 to 8.0.37 and then it sits for days attempting to start the MySQL service - the strange thing is the MySQL service is actually started.
In the error log I see the following
DateTime=2025-06-30T08:32:06.6780355Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T08:32:08.3971921Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T08:32:08.4821861Z
mysql-installer Information: 10 : Inherited permissions have been converted to explicit permissions.
DateTime=2025-06-30T09:37:37.3726739Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T10:01:35.2420464Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T10:25:17.9984920Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T10:48:04.4009846Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T11:10:29.6651468Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T11:52:33.2949879Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T11:52:33.3799881Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Service MySQL is stopped or paused, so it can be started.
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Verbose: 5 : 30/06/2025 12:52:33 - Attempting to start the MySQL service...
DateTime=2025-06-30T11:52:33.4069909Z
mysql-installer Information: 10 : '--sync-relay-log-info' is deprecated and will be removed in a future release.
DateTime=2025-06-30T11:52:37.4450356Z
mysql-installer Information: 10 : 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
DateTime=2025-06-30T11:52:37.4600921Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.37) starting as process 5380
DateTime=2025-06-30T11:52:37.4800559Z
mysql-installer Information: 10 : --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
DateTime=2025-06-30T11:52:37.5010332Z
mysql-installer Information: 10 : InnoDB initialization has started.
DateTime=2025-06-30T11:52:38.5493586Z
mysql-installer Error: 50 : Time out has expired and the operation has not been completed.
Thrown by: Logger.LogException
DateTime=2025-06-30T11:54:06.5268909Z
mysql-installer Information: 10 : MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
DateTime=2025-06-30T11:54:06.5518852Z
mysql-installer Error: 50 : A task may only be disposed if it is in a completion state (RanToCompletion, Faulted or Canceled).
DateTime=2025-06-30T11:54:06.5738974Z
mysql-installer Information: 10 : Finished configuration of MySQL Server 8.0.37 with state ConfigurationError
DateTime=2025-06-30T11:54:06.5928970Z
mysql-installer Information: 10 : InnoDB initialization has ended.
DateTime=2025-06-30T11:54:23.9383026Z
mysql-installer Information: 10 : Beginning ConfigApplyPage.
DateTime=2025-06-30T11:57:55.1867137Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.37
DateTime=2025-06-30T11:57:55.2158585Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2025-06-30T11:57:55.2447130Z
mysql-installer Error: 50 : The trust relationship between this workstation and the primary domain failed.
Thrown by: Logger.LogException
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Error: 50 : Failed to obtain SID for the 'LocalSystem' NT account.
DateTime=2025-06-30T11:57:55.2529234Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' started.
DateTime=2025-06-30T12:02:10.4096607Z
mysql-installer Information: 10 : Server upgrade from '80030' to '80037' completed.
DateTime=2025-06-30T12:04:34.9398147Z
mysql-installer Information: 10 : CA certificate ca.pem is self signed.
DateTime=2025-06-30T12:04:56.0419886Z
mysql-installer Information: 10 : Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
DateTime=2025-06-30T12:04:56.0539876Z
mysql-installer Information: 10 : X Plugin ready for connections. Bind-address: '::' port: 33060
DateTime=2025-06-30T12:04:57.1128137Z
mysql-installer Information: 10 : C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.37' socket: '' port: 3306 MySQL Community Server - GPL.
DateTime=2025-06-30T12:04:57.1278127Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2025-06-30T12:25:09.6747887Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2025-06-30T12:48:44.6175666Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2025-06-30T13:12:22.5709476Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2025-06-30T13:33:22.4361905Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2025-06-30T13:54:23.7668237Z
mysql-installer Information: 10 : Attempting to start service MySQL...
DateTime=2025-06-30T13:54:23.8088260Z
mysql-installer Verbose: 5 : 30/06/2025 14:54:23 - Service MySQL is running already.
DateTime=2025-06-30T13:54:23.8118256Z
mysql-installer Information: 10 : 2025-07-01T01:30:08.593804Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-01T01:30:09.6340342Z
mysql-installer Information: 10 : 2025-07-02T01:30:18.475350Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
DateTime=2025-07-02T01:30:18.8389154Z
It is almost like a timeout issue as about 30 seconds after the error message to state that MySQL cannot be started you can see that the service does start.
Any help or places to look would be really appreciated.
Subject
Views
Written By
Posted
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.