vCenter Server Upgrade Fails with pg_dump Error on vpx_proc_log Table

Products

• VMware SDDC Manager / VCF Installer
• VMware vCenter Server

Issue/Introduction

vCenter Server Appliance (vCSA). When attempting to manually upgrade the vCenter Server, the data export phase fails. The process halts and displays the following exact error message:

Error while exporting source core tables: pg_dump: error: Dumping the contents of table "vpx_proc_log" failed: PQgetResult() failed.

Environment

vCenter Server 9.1

Cause

PostgreSQL database corruption localized within the pg_toast chunks prevents the sequential data extraction of historical stored procedure logs.

Resolution

 

• Power off the source vCenter Server Appliance and take an offline virtual machine snapshot.

• Power on the vCenter Server Appliance.

• Authenticate to the source vCenter Server Appliance via SSH utilizing the root account.

• Access the vPostgres database shell by executing the following command: /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres

• Truncate the corrupted procedure log table to bypass the corrupted data blocks: TRUNCATE TABLE vpx_proc_log;

• Exit the vPostgres shell: \q

• Re-initiate the vCenter 9.1 upgrade process.

 

Additional Information

Postgres backup fails due to pg_toast error