msk05
Enthusiast
Enthusiast

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

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
0 Kudos
1 Reply
msk05
Enthusiast
Enthusiast

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

0 Kudos