ERROR: update or delete on table "certificate_library_item_consumer" violates foreign key constraint "fk_jetty2cert_lib" on table "cells" while uploading certificate on Public Addresses Tab of VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Uploading the Certificate on Public Addresses tab gives the following error-
  
  Error: [ ########-####-####-####-############ ] could not execute update query - ERROR: update or delete on table "certificate_library_item_consumer" violates foreign key constraint "fk_jetty2cert_lib" on table "cells" Detail: Key (id)=(########-####-####-####-############) is still referenced from table "cells".

Environment

VMware Cloud Director 10.5.1.1

Cause

If the public address certificate is shared with the cell endpoints configuration, the certificate cannot be updated because it fails with a foreign key constraint since the cell is also using the certificate.
When updating the certificate, the public address code attempts to delete the certificate even though it's not its only consumer in the certificate library.

Resolution

• Issue is fixed in VCD 10.6.
• The following workaround can be followed
  Reapply the certificates on the VCD cells again and then try to upload the certificate on the Public Addresses tab using the following document
  View and Manage Your VMware Cloud Director Cell Infrastructure