Task 'Configuring the NSX Managers Backup' hung in SDDC Manager

Products

• VMware SDDC Manager

Issue/Introduction

The 'Configuring the NSX Managers Backup' task is stuck and will not clear out, even after rebooting the SDDC Manager appliance

Environment

VMware Cloud Foundation 5.2

Cause

There is an outstanding lock on the deployment resource.

When running the following psql command from the shell of the SDDC Manage appliance we see an existing lock.

psql -h localhost -U postgres -d platform -c "select * from lock;"

Resolution

The deployment lock can be manually removed by following these steps:

Important: Always take a snapshot of the SDDC Manager appliance before performing any database-level modifications.

1. SSH into the SDDC Manager appliance as the root user.
2. Validate a lock exists. 
   • psql -h localhost -U postgres -d platform -c "select * from lock;"
3. Delete the DB lock entry:
   • psql -h localhost -U postgres -d platform -c "delete from lock where resource_type='deployment';"

Next you will need to follow Broadcom KB article 343400 to clear the failed task.