"Unable to upgrade the database: Could not run cleanup for running jobs!" when updating VMware Cloud Director database

Products

• VMware Cloud Director

Issue/Introduction

When upgrading the VMware Cloud Director database it exits with:
"Unable to upgrade the database: Could not run cleanup for running jobs!"

There are no failed tasks according to this knowledge article: "Unable to upgrade the database: Could not run cleanup for running jobs!" when upgrading VMware Cloud Director.

Environment

VMware Cloud Director 10.x

Cause

The vpostgres service is failing to run on the standby cells, and the service exits with each attempted startup. If we check /var/vmware/vpostgres/current/pgdata/log/postgresql-09.log we can find an error message related to worker processes on standbys not matching the primary. This is due to the resources of the primary being larger than the standby.

Resolution

Increase the CPU and memory of the standby cells to match the primary within vCenter. The following KB can be followed: Recommended Procedure for resizing Cloud Director Appliances. Afterwards the database upgrade script should be re-attempted.