MySQL mysql-installer-community-8.0.32.0 Server 2019
Posted by: Aqeel Mohammad
Date: February 22, 2023 04:21PM

Hi,

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. Tried to replicating the issue on another TEST Server. Installed 8.0.27, setup config to mimic problematic servers, and carried out the upgrade to 8.0.32 successfully without any issues. All servers are setup identically and have the same policies. I suspected a bug in the installer, however, it worked successfully in the last test.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL mysql-installer-community-8.0.32.0 Server 2019
415
February 22, 2023 04:21PM


Sorry, you can't reply to this topic. It has been closed.

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.