Virtual Network Assurance (VNA) not starting fully as MySQL is not starting

Products

• CA Infrastructure Management
• CA Performance Management
• Network Observability
• Virtual Network Assurance

Issue/Introduction

VNA service not running on port 8080 after installation as the MySQL server is not running. When checking MySQL status/starting MySQL an error is seen:

]$ service mysql status

ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

 

]$ service mysql start

Starting MySQL. ERROR! The server quit without updating PID file (/opt/CA/MySql/data/<hostname>.pid).

Environment

Virtual Network Assurance (VNA) 3.6 or later

Cause

Need to remove MySQL lock file as it is stopping MySQL from running.

Resolution

Run the following commands on the VNA server:

service wildfly stop
service mysql stop
mv /var/lock/subsys/mysql /tmp
service mysql start
service wildfly start

Verify whether the issue persists.