After Login to DPX the Dashboard shows error: Connection Refused

Symptoms

DPX Dashboard shows error:

Connect to rest:8095 [rest/10.0.1.13] failed: Connection refused (Connection refused)

dpx-rest.log shows following error:

Invocation of init method failed;nested exception is liquibase.exception.LockException: Could not acquire change log lock. 
01-06 11:06:35.574 1 INFO  --- [main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...

Resolution

1. Locate postgres SQL container ID by running the following command 

$ sudo docker container ls | grep postgres
2eccbc4ad15d      postgres:11    "docker-entrypoint.s…"   3 days 

check your ID and remember these
just one example for an ID:

2. Login into the postgres container to run CLI commands for releasing the lock:

$ sudo docker exec -it 2eccbc4ad15d bash

3. Start the postgres CLI to unlock the database 

psql -h localhost -U postgres

4. Run the command below to unlock the database 

UPDATE DATABASECHANGELOGLOCK SET LOCKED=FALSE, LOCKGRANTED=null, LOCKEDBY=null where ID=1;

5.  If the command is successful the following output is shown

UPDATE 1

6. Exit the postgres CLI postgres=#

 exit

7. Exit the postgres-sql container root@2eccbc4ad15d:/#

 exit

8. Login into the Management Console again and all dashboard information should be correctly visible