API Gateway: MySQL DB Not Running

book

Article ID: 185808

calendar_today

Updated On:

Products

CA API Gateway API SECURITY STARTER PACK-7

Issue/Introduction

On one of our processing nodes, when we check the status of the MySQL DB, it shows the database isn't running.

Environment

API Gateway: 9.3

Resolution

First, check the following:

1. the ssg log for any outstanding MySQL errors
2. the /var/log/mysqld.log for any outstanding MySQL errors
3. make sure the /var/lib/mysql directory isn't full 
4. make sure the permissions on the /var/lib/mysql directory, files and sub-directories are set properly

If everything above checks out, run the following command:

mysqld_safe --user=root &

After a few seconds, you can hit CTRL +C to break out of the command and check the status of the MySQL DB.