gpcheckcat fails with : ERROR: column "oid" does not exist

Products

• VMware Tanzu Greenplum

Issue/Introduction

The gpcheckcat utility fails with the following output:

$ gpcheckcat -O -p 5432 db_name
Truncated batch size to number of primaries: 113
Connected as user 'gpadmin' to database 'archive', port '5432', gpdb version '6.25'
-------------------------------------------------------------------
Batch size: 113
Performing test 'unique_index_violation'
Total runtime for test 'unique_index_violation': 0:00:01.38
Performing test 'duplicate'
Total runtime for test 'duplicate': 0:00:22.11
Performing test 'missing_extraneous'
  Execution error: ERROR:  column "oid" does not exist
LINE 4:                 SELECT oid FROM pg_description
                               ^


          SELECT oid
          FROM (
                SELECT oid FROM pg_description
                WHERE classoid='1247' and objsubid='0' and objoid='25'
                UNION ALL
                SELECT oid FROM gp_dist_random('pg_description')
                WHERE classoid='1247' and objsubid='0' and objoid='25'
          ) alloids
          GROUP BY oid
          ORDER BY count(*) desc, oid

   :
   :

Environment

Product Version: 6.25

Resolution

Fixed in Greenplum version 6.25.2 and above.

From Release Notes :

32987
Resolves an issue where gpcheckcat was erroring out and exiting because an underlying query was referencing an incorrect column in the pg_description table.