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

[ehowton]

Snapshot vCenter
SSH vCenter
# service-control --stop vmware-vpxd
# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
# select * from vpx_datastore;

Look for the affected datastore (DS) UUID and find the ID.
To confirm the correct ID as needed, run:

select * from vpx_entity where id=(ID found on previous step);

# delete from vpx_ds_assignment where ds_id=ID;
# delete from vpx_vm_ds_space where ds_id=ID;
# delete from vpx_datastore where id=ID;
# delete from vpx_entity where id=ID;

# quit
# service-control --start vmware-vpxd

#chronyc clients