Upgrade of NSX manager fails with "Error:stalesegmentportgprrrectificationTask found at least 1000 stale gprr entries."

Products

• VMware NSX

Issue/Introduction

• NSX Manager upgrade is failing at Data Migration Dry Run with the following error:
• The option "Resolve" is not available next to the error.

 

Environment

VMware NSX 4.x

Cause

The upgrade is failing because pre-upgrade data consistency check script detected that there are stale GPRR (Generic Policy Realized Resource) entries in the database. These stale entries are preventing NSX manager to be upgraded.

Resolution

This is a known issue impacting VMware NSX.

Workaround:

As a workaround, a data-consistency-checker.py script can be uploaded to one of the NSX Managers and can be used to clean up the stale GPRR entries:

NOTE: The script should be to run only on one of the NSX Managers.

1. Make sure that there is a valid backup of NSX Manager and the password is known for the backup.
2. Download the data-consistency-checker-24302016.tar.gz file that is attached to this KB.
3. Upload the file to root (/) directory of NSX Manager. (you can use WinSCP with SCP protocol as root)
4. Login to NSX Manager over SSH as root
5. Navigate to root directory: 
   
   

   cd /

6. Extract the file with:
   
   

   tar -xvf data-consistency-checker-24302016.tar.gz

7. Navigate to the extracted directory. for example:
   
   

   cd /data-consistency-checker-24302016

8. Run the script without adding extra parameters as a dry run, this should identify the stale entries:
   
   

   python data-consistency-checker.py

9. Run the script with the following parameter to start the cleanup of the stale GPRR entries:
   
   

   python data-consistency-checker.py --cleanup true

10. Once the script cleaned up stale GPRR entries, you can proceed with NSX Manager upgrade.