/common/logs/admin/app.log2025-11-27 12:54:25.461 UTC [InterconnectService_SvcThread-587, Ent: HybridityAdmin, , TxId: ####-####-####-9aae918858da] ERROR c.v.v.h.a.postgresdb.PostgresAdapter- Error executing query ERROR: duplicate key value violates unique constraint "HbrToHostConnectionAlerts_applianceId_1_hostId_1_vCenterId_1"
Detail: Key ((val ->> 'applianceId'::text), (val ->> 'hostId'::text), (val ->> 'vCenterId'::text))=(####-####-####-8f8e6ddfa19a, <IX-IP>, ) already exists.
VMware HCX
This is failing due to some stale entries for IX in HCX DB.
If you believe you have encountered this issue, please open a support case with Broadcom Support and refer to this KB article.
For more information, see Creating and managing Broadcom support cases.
Please collect HCX Logs [Select All] and upload to SR. Refer Gather Technical Support Logs
WORKAROUND:
If no migrations are currently in progress, you may deploy a new Service Mesh instance with IX. Please ensure that the new IX selects an IP address different from the one referenced in the error log.