MySQL Fails to Start After Installation/upgrade

Products

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

Issue/Introduction

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 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).

Cause

Missing libraries preventing mysql from starting 

Environment

Release : 19.1

Component : IM Reporting / Admin / Configuration

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.

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 

yum install libaio