Cannot start the container gateway

Products

• CA API Gateway

Issue/Introduction

The latest image the liquibase DB isn't starting and we keep getting the below in our logs :

Using MySQL database
SSG_DATABASE_WAIT_TIMEOUT set to 300 seconds.
SSG_JVM_HEAP will be 6g
SSG_CLUSTER_HOST will be <GatewayHostName>
SSG_GC_ARGS will be -Xlog:gc*:/opt/SecureSpan/Gateway/node/default/var/logs/ssg_gc.log
Waiting for one of the databases to come up...
Feb 06, 2024 5:14:46 PM liquibase.servicelocator
INFO: Cannot load service: liquibase.license.LicenseService: Provider liquibase.license.pro.DaticalTrueLicenseService could not be instantiated
Feb 06, 2024 5:14:49 PM liquibase.servicelocator
INFO: Cannot load service: liquibase.license.LicenseService: Provider liquibase.license.pro.DaticalTrueLicenseService could not be instantiated
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## Free schema change activity reports at ##
## https://hub.liquibase.com ##
## ##
####################################################
Starting Liquibase at 17:14:49 (version 4.5.0 #52 built at 2021-09-27 16:19+0000)

 

There's nothing after this, we want to check if there are any additional ports that we need to open for allowing the DB connection or if this is something else. Our gateway pods are not running and this is impacting our end customers that are using the gateway to reach the published APIs. 

Environment

CA API Gateway 11.x

Cause

The database was locked which was preventing the gateway from starting up.

Resolution

In the ssg database, run the following query:

mysql> select * from DATABASECHANGELOGLOCK;

It shows the DB is LOCKED (locked>0). 

It's possibly due to a killed process not releasing its lock on the DATABASECHANGELOGLOCK table.

To unlock the database you can execute the following:

UPDATE DATABASECHANGELOGLOCK SET locked=0;