Health Monitor for Load Balancer returns error

Products

• VMware Cloud Director

Issue/Introduction

When opening the Health Monitor under Tenant Scope > Networking > Edge Gateways > Load Balancer > Health Monitor you get following error: 

[ XXXXXXXX ] Could not execute JDBC batch update; SQL [/* Method: unknown */ /* insert com.vmware.vcloud.common.model.net.GatewayLoadBalancerHealthMonitorModel */ insert into gateway_lb_health_monitor (description, gateway_lr_id, health_monitor_backing_id, health_monitor_scope, health_monitor_type, name, version_number, id) values (?, ?, ?, ?, ?, ?, ?, ?)]; constraint [uq_gat_lb_hea_mo_gat_lr_id_nam]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update - Batch entry 5 /* Method: unknown */ /* Method: unknown */ /* insert com.vmware.vcloud.common.model.net.GatewayLoadBalancerHealthMonitorModel */ insert into gateway_lb_health_monitor (description, gateway_lr_id, health_monitor_backing_id, health_monitor_scope, health_monitor_type, name, version_number, id) values ((NULL), ('XXXXXXXXXXXX'::uuid), ('healthmonitor-XXXXXXXXXXXX'), ('SYSTEM'), ('HTTP'), ('System-HTTP'), ('0'::int8), ('XXXXXXXXXX'::uuid)) was aborted: ERROR: duplicate key value violates unique constraint "uq_gat_lb_hea_mo_gat_lr_id_nam" Detail: Key (gateway_lr_id, name)=(XXXXXXXXXX, System-HTTP) already exists. Call getNextException to see other errors in the batch.

Environment

10.6.1

Cause

• When the number of Health Monitors in NSX ALB > 128, vCloud Director triggers the /api/healthMonitor? to NSX-ALB  with wrong pagination parameters
• This creates potential duplicate entries to be introduced in vCloud Director's database
• Due to existing constrain this duplication is not allowed, leading to the error in UI

Resolution

Workaround

• Reduce the number of Health monitors in NSX to a number lower than 128

Fix

• Open a Support request with Broadcom Support referring to this article 

Additional Information

The fix will be implemented in future versions