Upgrade fails for CA API Developer Portal

Products

• CA API Developer Portal

Issue/Introduction

CA API Developer portal upgrade from 4.2.9.x to various other versions such
as 4.3 and 4.5 hangs when attempting to start the portal.

During the portal startup things will hang while checking
if a db schema update is needed.

 

Environment

Release : 4.2.9.x 

Component : API PORTAL

Cause

The stack trace shows issue during database upgrade
Upgrade freezes on DB upgrade step with errors:
INFO 9/27/19 9:57 AM: liquibase: Successfully released change log lock
liquibase.exception.ValidationFailedException: Validation Failed:
     10 change sets check sum

       at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:266)
       at liquibase.Liquibase.update(Liquibase.java:210)
       at liquibase.Liquibase.update(Liquibase.java:192)
       at liquibase.integration.commandline.Main.doMigration(Main.java:1126)
       at liquibase.integration.commandline.Main.run(Main.java:184)
       at liquibase.integration.commandline.Main.main(Main.java:103)


For more information, use the --logLevel flag
ERROR: Running the portal-data liquibase scripts failed, see above for details; exiting
/opt/start.sh: line 25:     8 Killed                  socat TCP4-LISTEN:$LISTEN_PORT,fork EXEC:cat > /dev/null 2>&1
09:57:25, Stopping simple server on :8080... done

Resolution

First back up Database if you have Database container/stack up then run below update command(step 2) then restart portal. If not, start portal(i.e run ./portal.sh) so database container will be up then follow below steps.
1. Backup database using: mysqldump -u<USERNAME> -p<PASSWORD> -h<HOST> portal > portal.sql
2. Execute the "update DATABASECHANGELOG set MD5SUM=null;" 
3. Restart portal