Redirection to the VMware Identity Manager login page from vRealize Automation 8.0 returns "Bad Gateway"

[msk05]

After clicking on the "GO TO LOGIN PAGE" button on the homepage of vRealize Automation 8.0 instance, the vRA appliance attempts to redirect to the vIDM login, but instead displays a blank page with the words "Bad Gateway".

`identity-service-app` POD is down with below error. Confirmed as below that there is no log lock in IDM database. Any help would be appreciated.

saas=# select * from saas.databasechangeloglock;

id | locked | lockgranted | lockedby

----+--------+-------------+----------

  1 | f      |             |

(1 row)

	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
	at org.springframework.boot.web.reactive.context.ReactiveWebServerApplicationContext.refresh(ReactiveWebServerApplicationContext.java:66) ~[spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:743) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:390) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1214) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1203) [spring-boot-2.1.7.RELEASE.jar!/:2.1.7.RELEASE]
	at com.vmware.identity.IdentityServiceApplication.main(IdentityServiceApplication.java:34) [classes!/:1.0.3]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_221]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_221]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_221]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_221]
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [identity-service-1.0.3.jar:1.0.3]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [identity-service-1.0.3.jar:1.0.3]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) [identity-service-1.0.3.jar:1.0.3]
	at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:578) [identity-service-1.0.3.jar:1.0.3]

Caused by: liquibase.exception.LockException: Could not acquire change log lock.  Currently locked by identity-service-app-569f75cf5c-mf8mt (10.244.0.88) since 3/26/20 8:00 PM

	at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:230) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.Liquibase.update(Liquibase.java:184) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.Liquibase.update(Liquibase.java:179) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:353) ~[liquibase-core-3.6.3.jar!/:na]
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:305) ~[liquibase-core-3.6.3.jar!/:na]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) ~[spring-beans-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) ~[spring-beans-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]
	... 26 common frames omitted

[msk05]

Container log has below execption

Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: The connection attempt failed.

        at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:307) ~[liquibase-core-3.6.3.jar!/:na]

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) ~[spring-beans-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) ~[spring-beans-5.1.9.RELEASE.jar!/:5.1.9.RELEASE]

        ... 26 common frames omitted

Caused by: org.postgresql.util.PSQLException: The connection attempt failed.

        at com.zaxxer.hikari.HikariDataSource$$EnhancerBySpringCGLIB$$9655c4f0.getConnection(<generated>) ~[HikariCP-3.2.0.jar!/:na]
        at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:302) ~[liquibase-core-3.6.3.jar!/:na]
        ... 28 common frames omitted
Caused by: java.net.UnknownHostException: pgpool
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) ~[na:1.8.0_221]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_221]
        at java.net.Socket.connect(Socket.java:589) ~[na:1.8.0_221]
        at org.postgresql.core.PGStream.<init>(PGStream.java:75) ~[postgresql-42.2.6.jar!/:42.2.6]
        at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91) ~[postgresql-42.2.6.jar!/:42.2.6]
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) ~[postgresql-42.2.6.jar!/:42.2.6]
        ... 58 common frames omitted