CNS volumes are lost after upgrade of vCenter server appliance to 9.0

Products

• VMware vCenter Server

Issue/Introduction

After vCenter Server is upgraded from v8.x to v9.0, volumes may be lost from CNS.

The volumes are actually present in the datastore, but they are missing from CNS DB.
These volumes are created by the vSphere CSI drivers.

Environment

vCenter Server 9.0

Resolution

1. Run fullSync on the datastore containing the volumes that can not be found in the CNS DB. Go to the MOB page of vCenter using below link,
   
   https://<VC_IP>/vslm/mob/?moid=StorageLifecycleManager&method=VslmSyncDatastore
   
   
2. Modify the fields as below
   
   datastoreUrl should follow the format, ds:///vmfs/volumes/UUID/.
   
   fullSync should be set to true.
   
   fcdId should be blank.
   
   
3. Select "Invoke Method"
4. Wait for 10 mins and check if volumes in datastore ds:///vmfs/volumes/UUID/ start showing in cns.volume_info table.
   1. ssh to the vCenter Server appliance
   2. Run the command,
      
      /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres -t -c "SELECT * from cns.volume_info";