ERROR: duplicate key value violates unique constraint "uq_orgmemberid_identifiertoken"org.springframework.orm.ObjectOptimisticLockingFailureExceptionorg.hibernate.StaleStateExceptionVMware Cloud Director 10.6
This issue can occur when incoming API or monitoring traffic is persistently routed to a single Cloud Director cell by a load balancer.
Client IP–based persistence causes repeated API requests from monitoring or backup tools to be sent to the same cell.
The affected cell exhausts its database connection pool, resulting in HTTP 503 responses.
Other Cloud Director cells remain available but are not utilized due to load-balancer persistence behavior.
grep 'HTTP/1\.[01]" 503' /opt/vmware/vcloud-director/logs/*request.log | wc -l
Check for cells reporting significantly higher counts.From the load balancer configuration in front of Cloud Director:
Review the Persistence Profile applied to the VIP or pool.
NSX > Load Balancing > Virtual Services and click the '>' icon to expand the section.
Deactivate 'Persistence'
Validate Resolution
Re-run the HTTP 503 checks from Step 1 on all cells.
Confirm that database connections remain below per-cell limits.
Verify Cloud Director UI and API responsiveness during monitoring or backup activity.