Error: 'could not execute update query - ERROR: update or delete table "logical_network" violates foreign key constraint "fk_net_interface2logical_net" on table "network_interface" ...)' when deleting Org VDC

Products

• VMware Cloud Director

Issue/Introduction

• You are unable to remove Org VDC networks from an Organization VDC.
• You are unable to delete Organization VDC.
• Multiple Org VDC network deletion fails.
• The vApp originally associated with the network has already been removed, but the network remains in a "stale" state.
• When you try to delete either the Org VDC or its network from the VMware Cloud Director (VCD) UI fails, and you see a message similar to:

Error: [ #######-####-####-####-########### ] could not execute update query - ERROR: update or delete on table "logical_network" violates foreign key constraint "fk_net_interface2logical_net" on table "network_interface" Detail: Key (id)=(#######-####-####-####-###########) is still referenced from table "network_interface".

Environment

VMware Cloud Director 10.6.x

Cause

There are NICs listed in the network_interface table as connected to a logical network in this Org VDC.

These NICs are preventing deletion of the Org VDC as they are not connected to any VM which still exists.

Resolution

The workaround for this issue requires modification of the Cloud Director database.

For assistance, contact Broadcom Support and note this Article ID (375420) in the problem description. For more information, see this article:

• Creating and managing Broadcom support cases