Datastore conflicts with an existing datastore in the datacenter that has the same URL

[TicywebSAGL]

Hi all
I have vcsa version 7.0.2 build 17694817 with two hosts. I've updated the first one to the latest version 7.0u2 build 17630552 and I cannot reconnect to vcenter: the error is the same as in kb here https://kb.vmware.com/s/article/79623

but following the guide I've got error:

6.Run the query select * from vpx_datastore_info;
ERROR: relation "vpx_datastore_info" does not exist

8.Delete the entry from vpx_ds_assignment, vpx_datastore and vpx_entity using query delete from vpx_ds_assignment where DS_id=XXXX;  :

VCDB=# delete from vpx_datastore where id=27;
ERROR: update or delete on table "vpx_datastore" violates foreign key constraint "fk_vpx_vm_ds_space2" on table "vpx_vm_ds_space"
DETAIL: Key (id)=(27) is still referenced from table "vpx_vm_ds_space".

VCDB=# delete from vpx_entity where id=27;
ERROR: update or delete on table "vpx_datastore" violates foreign key constraint "fk_vpx_vm_ds_space2" on table "vpx_vm_ds_space"
DETAIL: Key (id)=(27) is still referenced from table "vpx_vm_ds_space".

after vpxd service restart the host cannot be reconnected. 

[Mario91]

Hi,

I have the same problem. I submitted a request to VMware Technical Support, but the problem has not been resolved yet. One of the technical support answers says to check if there are any templates or snapshots referring to the problem with a given datastor, because you cannot remove the bindings with the commands:

delete from vpx_datastore where id = xxx;

delete from vpx_entity where id = xxx;

My solution turned out to be to turn off the host, connect it to iSCSI, start it up, add it to vCenter, turn it off again, connect iSCSI and start it up.

last post, same solution :

https://communities.vmware.com/t5/vCenter-Server-Discussions/Cannot-add-host-to-vCenter-server-becau...