Portal analytics server container does not start after upgrade

Products

• CA API Developer Portal

Issue/Introduction

The portal_analytics-server container not starting after portal upgrade to 5.3.1 .

portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [system-portal.log] [2025-07-22 08:09:47,077] [INFO ] [c.c.a.p.a.c.DatabaseConfiguration] [main] [|] [|||] analytics DB connection: jdbc:mysql://address=(protocol=tcp)(type=master)(host=xxx.xxx.xxx.xxx)(port=3306),address=(protocol=tcp)(type=master)(host=xxx.xxx.xxx.xxx)(port=3306)/analytics?characterEncoding=utf8&createDatabaseIfNotExist=true&useSSL=false&failOverReadOnly=false as devportal 
portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [QueryServer.log] [2025-07-22 08:09:47,723] [INFO ] [l.lockservice] [main] [|] [|||] Waiting for changelog lock.... 
portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [QueryServer.log] [2025-07-22 08:09:56,892] [INFO ] [o.s.a.r.c.CachingConnectionFactory] [pool-1-thread-1] [|] [|||] Attempting to connect to: rabbitmq:5672 
portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [QueryServer.log] [2025-07-22 08:09:56,935] [INFO ] [o.s.a.r.c.CachingConnectionFactory] [pool-1-thread-1] [|] [|||] Created new connection: initialiseFactory#7e38a7fe:0/SimpleConnection@26bec619 [delegate=amqp://[email protected]:5672/, localPort= 51352] 
portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [QueryServer.log] [2025-07-22 08:09:57,725] [INFO ] [l.lockservice] [main] [|] [|||] Waiting for changelog lock.... 
portal_analytics-server.0.xxxxxxxxxxxxx@xxxxxxxxxxxxxxxx    | [QueryServer.log] [2025-07-22 08:10:07,728] [INFO ] [l.lockservice] [main] [|] [|||] Waiting for changelog lock.... 

Environment

All Supported version of API Portal.

Cause

There is a lock in analytics database "DATABASECHANGELOGLOCK" table that has to be removed.

 mysql> SELECT * FROM analytics.DATABASECHANGELOGLOCK;

+----+----------------+---------------------+----------------------------------------------------------+
| ID | LOCKED         | LOCKGRANTED         | LOCKEDBY                                                 |
+----+----------------+---------------------+----------------------------------------------------------+
|  1 | 0x01           | 2025-07-14 11:58:49 | api-gw-prod-xxxx(xxx.xxx.xxx.xxx) |
+----+----------------+---------------------+----------------------------------------------------------+
1 row in set (0.00 sec)

Resolution

Unlock the following table.

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