• vCenter or VCSA Upgrade from 6.0 to 6.5 or 6.7 fails at 40% on the second stage.
• On the upgrade process you can error message similar to:

Error:

Encountered an internal error. see /var/log/firstboot/vpostgres-firstboot.py_13742_stderr.log
Resolution

This is an unrecoverable error, please retry install. If you encounter this error again, please search for these symptoms in the VMware Knowledge Base for any known issues and possible resolutions. If none can be found, collect a support bundle and open a support request.

• In the /var/log/vmware/vpostgres.logs of the destination appliance,  you see error message similar to:

yyyy-mm-dd HH:mm:ss.ms UTC 5c99db1c.4253 0 VCDB postgres ERROR: syntax error at or near "table" at character 54

yyyy-mm-dd HH:mm:ss.ms UTC 5c99db1c.4253 0 VCDB postgres STATEMENT: alter table vpx_hist_stat_tmp set tablespace

alter table vpx_alarm_action set tablespace alarm;

To solve this error you need to manually remove vpx_hist_stat_tmp table from source database. Follow the steps:
 

1. Open an ssh session to the source appliance. On the Windows vCenter open a remote desktop session.
2. Stop vpxd services:

# service vmware-vpxd stop

On windows vCenter, go to services and stop vCenter services. For more details, see How to stop, start, or restart vCenter Server services (1003895)

3. Delete vpx_hist_stat_tmp table:

# /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB -c "drop table vpx_hist_stat_tmp;"

On windows vCenter open a cmd console and run this command:

“\Program Files\VMware\vCenter Server\vPostgres\bin\psql.exe” -U postgres -d VCDB -c "drop table vpx_hist_stat_tmp;"

4. Start vpxd services:

# service vmware-vpxd start

5. Once all services are completely started on the source vCenter Server Appliance, start the upgrade process.