gprestore fails with pq: could not parse commandTag: strconv.ParseInt

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:
When attempting to restore a table from backup using gprestore in Greenplum Database v4.3.25.0 or v5.8.0, the task fails with the following error message: 

[CRITICAL]:-pq: could not parse commandTag: strconv.ParseInt: parsing "18446744072664883584": value out of range: Error loading data into table MyTest.table

Environment

Cause

This issue is caused by a limitation of COPY. The error is caused by row count validation.

Resolution

The resolution to this issue is to upgrade to GPDB 4.3.26.0 or v5.9.0.