Description:
I am upgrading MySQL to 8.0.32 (from 8.0.27). The upgrade is successful, however, the Installer (which is version 1.6.5.0) hangs forever on the 'Apply Configuration' step at the point where 'Starting the server and upgrading the system tables (may take a long time)'.
The MySQL80 service starts correctly, however the log continuously adds periods where the process still thinks it is trying to start the service. Nothing at this point is written in to the logs except it states that the service started successfully, until I cancel the configuration step. End part of log:
mysql-installer Information: 10 : Controller Settings - Load Installed - InstallDir
DateTime=2023-02-14T10:09:54.5550447Z
mysql-installer Information: 10 : Beginning ConfigOverviewPage.
DateTime=2023-02-14T10:09:54.6019226Z
mysql-installer Information: 10 : Setting up product configuration controller for upgrade.
DateTime=2023-02-14T10:09:56.6577727Z
mysql-installer Information: 10 : Beginning ServerConfigUpgradePage.
DateTime=2023-02-14T10:09:56.7046420Z
mysql-installer Information: 10 : Beginning ServerConfigSecurityPage.
DateTime=2023-02-14T10:10:00.5220436Z
mysql-installer Information: 10 : Beginning ConfigApplyPage.
DateTime=2023-02-14T10:10:08.7485730Z
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.32
DateTime=2023-02-14T10:10:11.7000628Z
mysql-installer Information: 10 : Attempting to update the permissions for the data folder and related server files...
DateTime=2023-02-14T10:10:11.7313184Z
mysql-installer Information: 10 : Inherited permissions have been converted to explicit permissions.
DateTime=2023-02-14T10:10:11.9656881Z
mysql-installer Information: 10 : Full control permissions granted to: NETWORK SERVICE.
DateTime=2023-02-14T10:10:12.3250678Z
mysql-installer Information: 10 : Full control permissions granted to: Administrators.
DateTime=2023-02-14T10:10:12.7156990Z
mysql-installer Information: 10 : Full control permissions granted to: CREATOR OWNER.
DateTime=2023-02-14T10:10:13.0594494Z
mysql-installer Information: 10 : Full control permissions granted to: SYSTEM.
DateTime=2023-02-14T10:10:13.4031959Z
mysql-installer Information: 10 : Access to the data directory is removed for the users group.
DateTime=2023-02-14T10:10:13.5438255Z
mysql-installer Information: 10 : Permissions for the data folder and related server files are updated correctly.
DateTime=2023-02-14T10:10:13.9657036Z
mysql-installer Information: 10 : Attempting to start service MySQL80...
DateTime=2023-02-14T10:10:13.9969534Z
mysql-installer Verbose: 5 : 14/02/2023 10:10:13 - Service MySQL80 is stopped or paused, so it can be started.
DateTime=2023-02-14T10:10:13.9969534Z
mysql-installer Verbose: 5 : 14/02/2023 10:10:13 - Attempting to start the MySQL80 service...
DateTime=2023-02-14T10:10:13.9969534Z
mysql-installer Verbose: 5 : 14/02/2023 10:10:33 - MySQL80 service was started successfully.
DateTime=2023-02-14T10:10:33.7158550Z
mysql-installer Information: 10 : Installer exit
DateTime=2023-02-14T13:43:27.7282990Z
Ports are open. Tried the upgrade on our TEST and DEV boxes, and get the same behavior.
How to repeat:
This hanging behavior is happening on all our instances of 8.0.27. I tried to replicate the issue with a fresh instance on 8.0.27 and then upgrade to 8.0.32, but was unable to as it worked without any issue. The only difference in this instance was Visual C++ redistributable was latest and the installer was also newer.