HCX Site Pairing is down due to a large "RemotingOutBox" table

Products

• VMware HCX

Issue/Introduction

• From the HCX Source UI (Connector or Cloud), the site pairing status is Down.
• The dashboard shows a continuous attempt to connect, with the status remaining in a "pending" state.
• Following the steps to identify a possible network issue using the Broadcom KB: HCX Site Pairing Connectivity Diagnostics, it has been confirmed that network connectivity is not causing this issue.
• The HCX Connector or HCX Cloud Manager has an excessive number of entries in the RemotingOutBox table (typically exceeding one million), which is confirmed by running the following select psql command:
  
  • Log in via SSH to both the HCX Connector and the HCX Cloud manager using the admin credentials.
  • Access the HCX database by running the following command: psql -h localhost -U postgres hybridity
  • Run the select query: select count(val) from "RemotingOutbox";
    
    Example:
    

    hybridity=# select count(val) from "RemotingOutbox";
    count
    ---------
    1166523
    (1 row)

     

Note: This command should be run on both the HCX Connector and the HCX Cloud manager. If the resulting numbers are very large, as seen in the example on either the source or the target, please contact Broadcom Support.
Please do not perform any psql commands other than those specified in this KB. Only SELECT commands are allowed, and they should only be used to check this specific table.

Environment

VMware HCX 4.11.0

Resolution

This issue is resolved in VMware HCX 4.11.1, available at Broadcom downloads.

If you are having difficulty finding and downloading software, please review the Download Broadcom products and software KB.

Workaround:

If you have already encountered this issue on version HCX 4.11.0, and it persists after upgrading to HCX 4.11.1 or a later version, please open a support case with Broadcom Support and refer to this KB article.

For more information, see Creating and managing Broadcom support cases.

Additional Information

HCX Site Pairing Connectivity Diagnostics

If you are contacting Broadcom support about this issue, please provide the following:

• HCX Manager Connector logs (including the database).
• HCX Manager Cloud logs (including the database).