Portal upgrade failed

Products

• CA API Developer Portal

Issue/Introduction

Upgraded Portal docker swarm from v5.2.3 to v5.3.1 after applying the patch portal is stuck at "portal_db-upgrade-rbac"

 

Environment

Portal 5.2.3

 

Cause

This environment had over 130k applications

The portal was executing a query (expiry time for each application) in the portal.APPLICATION table which was taking an excessive time to execute this prevented the portal fully starting up.  

 

Resolution

Fixed and tested in version 5.3.2

Upgraded from 5.2.3 to 5.3.2 and execution time took < 15 Sec which is well within expectations.