从 vCenter Server 6.0 迁移到 VCSA 6.5 失败并显示错误：在数据中找到不带引号的回车符 (unquoted carriage return found in data)
search cancel

从 vCenter Server 6.0 迁移到 VCSA 6.5 失败并显示错误：在数据中找到不带引号的回车符 (unquoted carriage return found in data)

book

Article ID: 301337

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

Symptoms:
免责声明：本文为 Migrating from vCenter Server 6.0 to VCSA 6.5 fails with the error: unquoted carriage return found in data (2148219) 的翻译版本。尽管我们会不断努力为本文提供最佳翻译版本，但本地化的内容可能会过时。有关最新内容，请参见英文版本。
  • 从 vCenter Server 6.0 迁移到 VCSA 6.5 失败，并显示以下错误：

    Encountered an internal error. see /var/log/firstboot/vpostgres-firstboot.py_11871_stderr.log
    Resolution:
    This is an unrecoverable error, please retry install. If you run into this error again, please collect a support bundle and open a support request.
     
  • 在 /var/log/firstboot/vpostgres-firstboot.py_xxx_stderr.log 文件中，您会看到类似以下内容的条目：

    2016-12-08T16:54:02.674Z Upgrade import step failed
    2016-12-08T16:54:02.674Z vPostgres firstboot(action=firstboot) failed
  • 在 /var/log/vmware/vpxd/vcdb_import.err 文件中，您会看到类似以下内容的条目：

    NOTICE: drop cascades to constraint vdc_entity_lock_metadata_fk on table vdc_entity_lock_metadata
    NOTICE: constraint "vdc_entity_lock_metadata_fk" of relation "vdc_entity_lock_metadata" does not exist, skipping
    ERROR: unquoted carriage return found in data
    HINT: Use quoted CSV field to represent carriage return.
    CONTEXT: COPY vpx_event_arg, line 1164679
     
  • 在 /var/log/vmware/vpostgres/postgresql-80.log 文件中，您会看到类似以下内容的条目：

    VCDB postgres ERROR: unquoted carriage return found in data
    2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres HINT: Use quoted CSV field to represent carriage return.
    2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres CONTEXT: COPY vpx_event_arg, line 1164679
    2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres STATEMENT: COPY VPX_EVENT_ARG FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';
    2016-12-08 16:49:49.752 UTC 58498f2a.4bf3 0 VCDB postgres LOG: duration: 3182.597 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';
    2016-12-08 16:49:50.844 UTC 58498f2b.4bf9 0 VCDB postgres LOG: duration: 3805.675 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';
    2016-12-08 16:49:51.860 UTC 58498f2c.4c08 0 VCDB postgres LOG: duration: 3111.694 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';
    2016-12-08 16:49:52.323 UTC 58498f2d.4c0c 0 VCDB postgres LOG: duration: 2560.249 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';
    2016-12-08 16:49:54.209 UTC 58498eba.4872 0 LOG: Updating instance status...

    注意：上述日志摘录仅为示例。日期、时间和环境变量可能会因环境而有所不同。


Environment

VMware vCenter Server 6.0.x
VMware vCenter Server Appliance 6.5.x

Resolution

这是一个影响 vCenter Server 6.0 的已知问题。


在 vcdb_import.err 日志文件中，找到失败的表：

例如：


ERROR: unquoted carriage return found in data
HINT: Use quoted CSV field to represent carriage return.
CONTEXT: COPY vpx_event_arg, line 1164679

要解决此问题，请执行以下操作之一：

Powered by Wolken Software