CA API Gateway: Could not acquire change log lock in Gateway Pods

Products

• CA API Gateway

Issue/Introduction

We were trying to increase the replica count of our gateway pods and ran into the issue below. The new pods won't spin up.

Could not acquire change log lock.

 

Environment

All supported versions of the CA API Gateway

Resolution

We executed the following mysql query to determine there was an existing lock on the databasechangeloglock table

use ssg ;
SELECT * FROM DATABASECHANGELOGLOCK;

Assuming there is a locked entry i.e. locked=1 from above select then remove the lock if its no longer valid.

To remove the lock execute the following query:

UPDATE DATABASECHANGELOGLOCK SET locked=0, lockgranted=null, lockedby=null WHERE id=1;