IDPA vCenter 升级失败，并显示错误“vCSACliInstallLogger - ERROR - vCenter Server Data Export failed”（vCSACliInstallLogger — 错误 — vCenter Server 数据导出失败）

Summary: 此知识库文章介绍因 vcenter 数据库导出失败而造成的 vCenter 升级失败。这可能是由于 vcenter 数据库损坏所致。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms



在 ACM 上，您可能会注意到 vCenter 显示为“failed”。

查看“/data01/tmp/patch/logs/VCSA”目录下的 vCenter 升级日志，可在 vcsaclientinstaller 日志中看到以下错误：

Progress: 42% Exporting VMware vCenter Server Database data...
2020-03-26 03:41:00,145 - vCSACliInstallLogger - ERROR - vCenter Server Data Export failed.
2020-03-26 03:41:00,145 - vCSACliInstallLogger - ERROR - Upgrade failed:
Status: ERROR
Progress: 42% Exporting VMware vCenter Server Database data...
Error:
Problem Id: None
Component key: upgrade_framework
Detail:
Error while exporting source SET tables: pg_dump: Error message from server: ERROR:  invalid page in block 9 of relation base/16384/25164

Resolution: Read the log files and address the issues found in your source SET tables.
2020-03-26 03:41:00,145 - vCSACliInstallLogger - INFO - See /data01/tmp/patch/logs/vclogs/monitor-firstboot-progress-oczvL_.json file on local machine or /var/log/vmware/upgrade/export.json file on remote machine for details.


此外，在 vCenter Server 上，还可以验证“/var/log/vmware/upgrade”下的升级日志，它们可能会显示以下错误消息：

VMware License Service data...
2020-03-26 17:09:01,732 - vCSACliInstallLogger - INFO - vCenter Server Data Export: Progress: 42% Exporting VMware vCenter Server Database data...
2020-03-26 17:09:12,296 - vCSACliInstallLogger - ERROR - vCenter Server Data Export failed.
2020-03-26 17:09:12,296 - vCSACliInstallLogger - ERROR - Upgrade failed:
Status: ERROR
Progress: 42% Exporting VMware vCenter Server Database data...
Error:
Problem Id: None
Component key: upgrade_framework
Detail:
Error while exporting source SET tables: pg_dump: Error message from server: ERROR:  invalid page in block 9 of relation base/16384/25164

Resolution: Read the log files and address the issues found in your source SET tables.
2020-03-26 17:09:12,296 - vCSACliInstallLogger - INFO - See /data01/tmp/patch/logs/vclogs/monitor-firstboot-progress-tmcn2I.json file on local machine or /var/log/vmware/upgrade/export.json file on remote machine for details.
2020-03-26 17:09:12,305 - vCSACliInstallLogger - INFO - Gathering VC support log bundle. This can take a few minutes.
2020-03-26 17:09:12,583 - vCSACliInstallLogger - INFO - Uninstalling vmware-upgrade-requirements-* on 192.168.100.99.
2020-03-26 17:09:13,881 - vCSACliInstallLogger - ERROR - (u'Failed to uninstall %(rpm)s on %(host)s: %(error)s', {'host': u'192.168.100.99', 'rpm': u'vmware-upgrade-requirements-*', 'error': CommandError(u"Failed to run and wait for command in guest with error 'Command '/bin/rpm' exited with non-zero status 1'",)})


vcenter 上的 postgres.log 显示以下错误消息：

816 UTC 5e7ce0cc.7647 24294965  LOG: automatic analyze of table "VCDB.vc.vpx_event_arg" system usage: CPU 0.02s/1.53u sec elapsed 6.15 sec
2020-03-26 17:08:19.502 UTC 5e7ce180.2530 24295002  LOG: automatic analyze of table "VCDB.vc.vpx_event" system usage: CPU 0.00s/2.40u sec elapsed 2.79 sec
2020-03-26 17:08:58.326 UTC 5e7c377f.3892 0 VCDB vc LOG: unexpected EOF on client connection with an open transaction
2020-03-26 17:08:58.326 UTC 5e7c3796.3a7b 0 VCDB vc LOG: unexpected EOF on client connection with an open transaction
2020-03-26 17:08:58.327 UTC 5e7c3796.3a81 0 VCDB vc LOG: unexpected EOF on client connection with an open transaction
2020-03-26 17:09:09.530 UTC 5e7ce1b3.3c67 0 VCDB postgres ERROR: invalid page in block 9 of relation base/16384/25164
2020-03-26 17:09:09.530 UTC 5e7ce1b3.3c67 0 VCDB postgres STATEMENT: COPY vc.vpx_topn_past_month (counter_id, sample_time, integral_value) TO stdout;
SET zero_damaged_pages = on; select * from <corrupted table>; SET zero_damaged_pages = off;

VCDB=# select counter_id from vpx_topn_past_month;
ERROR: invalid page in block 9 of relation base/16384/25164

Cause

vCenter Postgres 数据库损坏导致 vCenter 升级在数据库导出任务期间失败。 

Resolution

步骤 1：登录到 IDPA vCenter UI。

步骤 2：克隆 vCenter 虚拟机。
  • 右键单击 VCSA 虚拟机，然后选择“Clone to Virtual Machine”。 
  • 选择克隆的名称和其他详细信息，然后单击“OK”。 

步骤 3：在 ACM UI 上对 vCenter 虚拟机执行回滚。 
  • 单击“Troubleshooting Options”复选框。单击“Rollback for vCenter Upgrade”。  

步骤4：通过 SSH 访问 vCenter 虚拟机，然后停止 vpxd 服务。
  • service-control --stop vpxd

步骤5：登录到 vCenter Postgres 数据库。
  • /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
步骤6：在 vCenter Postgres 数据库上运行以下查询/命令：
  • SET zero_damaged_pages = on;
  • VACUUM FULL ANALYSE VERBOSE;
  • REINDEX table vpx_topn_past_month;
  • select * from vpx_topn_past_month;
  • SET zero_damaged_pages = off;
步骤7：转至 ACM UI，单击“Retry for vCenter Upgrade”并监视它。 


    Additional Information

    如果在执行上述步骤后问题仍未解决，请与 VMware 支持人员联系。 

    Affected Products

    Integrated Data Protection Appliance Family

    Products

    PowerProtect DP4400, PowerProtect DP5300, PowerProtect DP5800, PowerProtect DP8300, PowerProtect DP8800, PowerProtect Data Protection Software, Integrated Data Protection Appliance Family, PowerProtect Data Protection Hardware , Integrated Data Protection Appliance Software ...
    Article Properties
    Article Number: 000173289
    Article Type: Solution
    Last Modified: 27 May 2025
    Version:  3
    Find answers to your questions from other Dell users
    Support Services
    Check if your device is covered by Support Services.