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

Products

• CA API Gateway

Issue/Introduction

This is for CA API Gateway, I was able to raise support cases here before, but somehow I can't see it from the dropdown today. Version is 10.1 running in Kubernetes.

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

Could not acquire change log lock.

 

Environment

Release :

Resolution

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 lock:

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