Error: "Deletion of edge gateway EDGE_NAME failed" when attempting to modify or delete an Org vDC Network in Cloud Director. Isolated network can't be deleted

Products

• VMware Cloud Director

Issue/Introduction

Trying to delete an isolated network from within a VDC, but it fails with the following error:

[ ########-####-####-############ ] Cannot delete organization VDC network Network-Name (urn:uuid:########-####-####-############)
 - Deletion of edge gateway Network-Name failed.
 - java.util.concurrent.ExecutionException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: 2; expected: 1

Deletion of edge gateway  failed.
java.util.concurrent.ExecutionException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: ; expected: .
com.vmware.vcloud.dl.net.orgvdcnetwork.impl.OrgVdcNetworkManagerImpl.handleGatewayUpdateForIndependentNetwork(OrgVdcNetworkManagerImpl.java:806)
Caused by: com.vmware.vcloud.dl.net.exception.NetworkInternalServerException: Deletion of edge gateway failed.
java.util.concurrent.ExecutionException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row count: ; expected: 
 at com.vmware.vcloud.dl.net.gateway.impl.FabricGatewayManagerImpl.undeployGateway(FabricGatewayManagerImpl.java:274)
 at com.vmware.vcloud.dl.net.gateway.impl.FabricGatewayManagerImpl.undeployAndDeleteGateway(FabricGatewayManagerImpl.java:257)

 

In the vcloud-container-debug.log you see the message

Could not release IP/MAC while undeploying gateway <edge>

Environment

VMware Cloud Director 10.x

Cause

This issue occurs during the database lookup for the gateway_assigned_mac in the database.

Cloud Director expects a unique MAC entry per Interface and will complain if there are more than 1 returned.

Resolution

This issue will require Database Manipulation to remove the duplicates.

Please open a case with Broadcom Support.