Unable to remove an Array Pair from VLSR Recovery UI

Products

• VMware Live Recovery

Issue/Introduction

Symptoms:

• Powering off a storage/replication array before disabling the Array Pairs in SRM/VLSR, doesn't allow the pair to then be disabled and removed.
  
  
• Disable option for array pair in Site Recovery UI (under 'Array Pairs' tab) is grayed out.
  
  
• SRM server logs report the stale array pairs with "not found" logging.
  
  YYYY-MM-DDTHH:MM:SS.715+10:00 warning vmware-dr[#####] [SRM@6876 sub=Storage opID=########-####-####-####-############-findArrayManager:2c11] [52e21] Array Manager for SRA '########-####-####-####-############' and Array '<array_pair_name>' was not found.

Environment

• Site Recovery Manager 8.x
  
  
• VMware Live Site Recovery 9.0.x

Cause

• These stale array pair entries still show up in Site Recovery UI as SRM database is still enlisting these array pairs.
  
  
• Running following commands in SRM/VLSR database enlists the entres of stale array pairs:

1. 1. Login to SRM/VLSR database
      /opt/vmware/vpostgres/current/bin/psql -d srmdb -U srmdb
      
      
   2. Query following tables to enlist the array pairs:
      select * from pdsa_arraypeer;

Resolution

1. Manually use SrmDbTool utility /opt/vmware/srm/dbtool/SrmDbTool.py to identify and delete the array pair.
   
   - SSH to SRM/VLSR appliance as root and query using SrmDbTool:
   
   
   1. List array pairs:
python /opt/vmware/srm/dbtool/SrmDbTool.py query ArrayPair
      
      
   2. Delete stale array pair using populated list above:
python /opt/vmware/srm/dbtool/SrmDbTool.py delete ArrayPair <array_pair>

      
      
2. If SrmDbTool does not populate stale array pair or delete command fails to run, follow steps below to manually cleanup SRM/VLSR database:
   
   
   1. Take snapshots of both SRM/VLSR appliances.
      
      
   2. Stop SRM server service:
      systemctl stop srm-server
      
      
   3. Login to SRM/VLSR database
      /opt/vmware/vpostgres/current/bin/psql -d srmdb -U srmdb
      
      
   4. List entries of stale array pair from table pdsa_arraypeer and note down their db_id :
      select * from pdsa_arraypeer;
      
      
   5. Delete entries of stale array pair from following two tables using commands:
      delete from pdsa_arraypair where db_id = <db_id_from_step-d>;
delete from g_do_array where db_id = <db_id_from_step-d>;


   6. Start SRM service:
      systemctl start srm-server

Additional Information

• At time of KB creation, there is NO SrmDbTool.py in new converged VLSR 9.0.3, 9.0.4 & 9.0.5