VNA 22.2.8 Upgrade Failure: failed to restart MySQL; aborting the upgrade procedure

Products

• Network Observability
• Virtual Network Assurance

Issue/Introduction

Please enter the existing password for root@localhost account in MySQL>
Please re-enter the existing password for root@localhost account in MySQL>
Checking for VNA DB status
Extracting MySQL
Comparing existing MySQL version with new MySQL version
MySQL upgrade required, starting MySQL upgrade process
Stopping MySQL Service
Shutting down MySQL.... SUCCESS! 
chown: invalid group: ‘mysql:mysql’
Configuring MySQL startup
MySQL Config Updated
Starting MySQL Service
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Upgrading MySQL data
Restarting MySQL to commit changes
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Failed to restart MySQL; aborting the upgrade procedure
Failed to upgrade MySQL
Restoring the wildfly config
A problem occurred during installation (install directory not deleted). Backing up to /tmp/netops/CA_VNA_Install_bak

Environment

Release: 22.2.x

Cause

• grep /etc/group mysql - No mysql group was present

Resolution

Run the following commands to fix the issue with MySQL group permissions:

• groupadd mysql
• usermod -g mysql mysql
• chown mysql:mysql -R /CA/MySql
• Re-run VNA Installation\Upgrade