MySQL Fails to Start After Installation/upgrade


Article ID: 142976


Updated On:


CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps


MySQL fails to start after automated installation of CAPC

MySql fails to start after upgrade 

MySql will not start after upgrade 

Performance Center Install fails with MySql error 

FATAL ERROR -     class FatalInstallException: Unable to open database connection: 

No mysql logs updated

Starting MySQL. ERROR! The server quit without updating PID file (opt/CA/MySql/data/


Missing libraries preventing mysql from starting 


Release : 19.1

Component : IM Reporting / Admin / Configuration


Check for missing libraries. If any show "not found" then these libraries need to be installed. Example below is the libaio library being missing but we have also seen this with numactl.

Cd /opt/CA/MySql/bin 

root#ldd mysqld => (0x00007ffe723e0000) => /lib64/ (0x00007f04ddb1f000) => not found => /lib64/ (0x00007f04dd914000) => /lib64/ (0x00007f04dd6dd000) => /lib64/ (0x00007f04dd4d9000) => /lib64/ (0x00007f04dd2d1000) => /lib64/ (0x00007f04dcfca000) => /lib64/ (0x00007f04dccc8000) => /lib64/ (0x00007f04dcab2000) => /lib64/ (0x00007f04dc6e4000)
/lib64/ (0x00007f04ddd3b000) => /lib64/ (0x00007f04dc4e1000)

This showed that was missing

You can install the package/library with yum 

yum install libaio