MySQL Fails to Start After Installation/upgrade

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

• MySQL fails to start after automated installation of NetOps Performance Management 
• MySql fails to start after upgrade 
• MySql will not start after upgrade 
• Performance Center Install fails with MySql error 

FATAL ERROR -     class com.ca.im.installanywhere.action.MigrateDb FatalInstallException: Unable to open database connection: No mysql logs updated
Starting MySQL. ERROR! The server quit without updating PID file (opt/CA/MySql/data/system_name.itnet.local.pid).

Environment

Component : IM Reporting / Admin / Configuration

Cause

Missing libraries preventing mysql from starting 

Resolution

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.

root# cd /opt/CA/MySql/bin 

root# ldd mysqld
linux-vdso.so.1 => (0x00007ffe723e0000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f04ddb1f000)
libaio.so.1 => not found
libnuma.so.1 => /lib64/libnuma.so.1 (0x00007f04dd914000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f04dd6dd000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f04dd4d9000)
librt.so.1 => /lib64/librt.so.1 (0x00007f04dd2d1000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f04dcfca000)
libm.so.6 => /lib64/libm.so.6 (0x00007f04dccc8000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f04dcab2000)
libc.so.6 => /lib64/libc.so.6 (0x00007f04dc6e4000)
/lib64/ld-linux-x86-64.so.2 (0x00007f04ddd3b000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f04dc4e1000)

This showed that libaio.so.1 was missing 

You can install the package/library with yum :

root# yum install libaio