Error: "org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend" during upgrade of VMware Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

• Upgrading Cloud Director fails at the database schema upgrade phase
• When running the Database upgrade command, /opt/vmware/vcloud-director/bin/upgrade, the following error is noticed:

  2024-03-13 23:01:12,636 | ERROR | main | UpgradeAgent | Could not retrieve database schema version: could not inspect JDBC autocommit mode | org.hibernate.exception.JDBCConnectionException: could not inspect JDBC autocommit mode. Unable to upgrade the database: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.

Environment

VMware Cloud Director 10.4.x

VMware Cloud Director 10.5.x

VMware Cloud Director 10.6.x

Cause

This issue can occur when the Cloud Director database is a large size

Resolution

Database modifications are required to reduce the size of database. For assistance, contact Broadcom Support and note this Article ID (368562) in the problem description. For more information see Creating and managing Broadcom support cases.