When attempting to upgrade CABI JasperServer 6.3 to 7.1.1, it fails with a "Cannot connect to the database server" message

Products

• CA Spectrum
• CA Performance Management - Usage and Administration

Issue/Introduction

When attempting to upgrade CABI JasperServer 6.3 to 7.1.1, it fails with a "Cannot connect to the database server" message:

Environment

CABI JasperServer 6.x 

Red Hat Linux 7.x, 8.x

Cause

The Postgres processes were all running, however, found in the DB log (~/postgressql/logs/log.txt) the following errors repeated;

FATAL:the database system is shutting down

This means that the DB processes are in a hung state and not responding.

Resolution

Stopped the JasperServer and then had to manually stop the Postgres DB using the 'fast' option:

cd <CABI_JASPER_INSTALL_DIR>/postgresql/bin

Then

su $POSTGRES_USER -c "./pg_ctl -D ../data -l ../logs/log.txt stop -m fast"

This immediately stops the Postgres DB processes by cutting any hung client connections.

Then restart the Postgres DB:

su $POSTGRES_USER -c "./pg_ctl -D ../data -l ../logs/log.txt start"

After this, the GUI install proceeds as normal: