"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-##.log (with ## being the day of the month) we can find the root cause. There will be a mismatch between the primary and secondaries causing the secondaries to fail.

Resolution

Depending on what is mis-matched from the secondary to the primaries different values may need to be fixed.

If it is CPU and Memory then 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.

If other values, such as max_connections, show as the issue please engage Broadcom VCF support referencing this knowledge article.