"vCSACliInstallLogger - ERROR - vCenter Server Data Export failed" 오류와 함께 IDPA vCenter 업그레이드 실패
Summary: 이 KB 문서는 vCenter DB 내보내기 실패로 인해 발생한 vCenter 업그레이드 실패에 대해 안내합니다. vCenter DB 손상이 원인일 수 있습니다.
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.
Symptoms
ACM에서 vCenter가 실패한 것으로 표시될 수 있습니다.
"/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 데이터베이스 손상으로 인해 DB 내보내기 작업 중에 vCenter 업그레이드가 실패했습니다.
Resolution
1단계: IDPA vCenter UI에 로그인합니다.
2단계: vCenter VM의 클론을 생성합니다.
3단계: ACM UI에서 vCenter VM에 대한 롤백을 수행합니다.
4단계: vCenter VM에 SSH로 연결하고 vpxd 서비스를 중지합니다.
5단계: vCenter Postgres DB에 로그인합니다.
2단계: vCenter VM의 클론을 생성합니다.
- VCSA VM --> Clone to Virtual Machine을 마우스 오른쪽 버튼으로 클릭합니다.
- 클론 이름과 기타 세부 정보를 선택하고 OK를 클릭합니다.
3단계: ACM UI에서 vCenter VM에 대한 롤백을 수행합니다.
- Troubleshooting Options 확인란을 클릭합니다. Rollback for vCenter Upgrade를 클릭합니다.
4단계: vCenter VM에 SSH로 연결하고 vpxd 서비스를 중지합니다.
- service-control --stop vpxd
5단계: vCenter Postgres DB에 로그인합니다.
- /opt/vmware/vpostgres/current/bin/psql -d VCDB -U 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;
Additional Information
위의 단계를 수행한 후 문제가 해결되지 않으면 VMware 지원 부서에 문의하십시오.
Affected Products
Integrated Data Protection Appliance FamilyProducts
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.