vpostgres-repl fails to start on Primary node in Aria Operations Manager

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• Aria Operations cluster HA is Enabled, or failed to disable.
• Attempting to start the vpostgres-repl service fails with an error similar to:
  

  Reset vRealize Operations vPostgres Replication Database...
  Test connection to ...
  Failed testing connection to

• The /storage/db/vcops/vpostgres/repl/serverlog file shows errors similar to:
  

  FATAL:  could not connect to the primary server: could not connect to server: Connection refused
                  Is the server running on host "###.###.###.###" and accepting
                  TCP/IP connections on port 5433?

• The /storage/vcops/log/analytics-UUID.log shows error similar to:
  

  2018-03-29 17:50:53,484 ERROR [Analytics Main Thread ]  com.integrien.analytics.AnalyticsMain.run - AnalyticsMain.run failed with error: CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.lang.reflect.UndeclaredThrowableException
  org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.lang.reflect.UndeclaredThrowableException

Environment

Aria Operations 8.x

Cause

A failed failover between a Primary and Primary Replica node can leave inconsistencies in the cluster.

Resolution

If you believe you are encountering this issue, please contact Broadcom Support