"Error getting cluster database nodes..." error when promoting a replica to primary in vRA

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Symptoms:
While you manually promote replica database node to primary, you see the error message similar to:

Error getting cluster database nodes: "StatementCallback;
uncategorized SQLException for SQL [SELECT pg_current_xlog_location() as master_loc];
SQL state [55000];
ERROR: recovery is in progress

Environment

VMware vRealize Automation 6.2
VMware vRealize Automation 7.0.x
VMware vRealize Automation 7.x
VMware vRealize Automation Desktop 6.2
VMware vRealize Automation 6.2.x
VMware vRealize Automation 7.3.x
VMware vRealize Automation 7.2.x
VMware vRealize Automation Desktop 6.2.x
VMware vRealize Automation 6.x
VMware vRealize Automation 7.4.x
VMware vRealize Automation 7.1.x

Resolution

This issue is resolved in VMware vRealize Automation 7.4, available at VMware Downloads.

To work around the issue, restart the haproxy service on the replica vRA node:

1. Log in to replica vRA using root through SSH.
2. Restart the haproxy service by running the command:
   
   service haproxy restart
    
3. Promote the replica to primary again.

Additional Information

To be alerted when this document is updated, click the Subscribe to Article link in the Actions box..