gpcheckcat reports ERROR: column "none" does not exist

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Following messages were seen in gpcheckcat logs:

Error Message:

Execution error: ERROR: column "none" does not exist
LINE 13: WHERE c.oid in (None)
 ^

 SELECT oid, relname, nspname, relkind, paroid
 FROM (
 SELECT oid, relname, nspname, relkind
 FROM (
 SELECT oid, relname, nspname, relkind, rank() over (partition by oid order by count(*) desc)
 FROM
 (
 SELECT c.oid, c.relname, c.relkind, n.nspname
 FROM pg_class c
 left outer join pg_namespace n
 on (c.relnamespace = n.oid)
 WHERE c.oid in (None)
 UNION ALL
 SELECT c.oid, c.relname, c.relkind, n.nspname
 FROM gp_dist_random('pg_class') c
 left outer join gp_dist_random('pg_namespace') n
 on (c.relnamespace = n.oid and c.gp_segment_id = n.gp_segment_id)
 WHERE c.oid in (None)
 ) allrelinfo
 GROUP BY oid, relname, nspname, relkind
 ) relinfo
 WHERE rank=1
 ) relinfo
LEFT OUTER JOIN
(
 SELECT reltoastrelid as childoid, oid as paroid
 FROM (
 SELECT reltoastrelid, oid, rank() over (partition by reltoastrelid order by count(*) desc)
 FROM
 ( SELECT reltoastrelid, oid FROM pg_class
 WHERE reltoastrelid in (None)
 UNION ALL
 SELECT reltoastrelid, oid FROM gp_dist_random('pg_class')
 WHERE reltoastrelid in (None)
 ) allpar_toast
 GROUP BY reltoastrelid, oid
 ) par_toast
 WHERE rank=1
UNION ALL
SELECT segrelid as childoid, relid as paroid
 FROM (
 SELECT segrelid, relid, rank() over (partition by segrelid order by count(*) desc)
 FROM
 ( SELECT segrelid, relid FROM pg_appendonly
 WHERE segrelid in (None)
 UNION ALL
 SELECT segrelid, relid FROM gp_dist_random('pg_appendonly')
 WHERE segrelid in (None)
 ) allpar_aoco
 GROUP BY segrelid, relid
 ) par_aoco
 WHERE rank=1
UNION ALL
SELECT indexrelid as childoid, indrelid as paroid
 FROM (
 SELECT indexrelid, indrelid, rank() over (partition by indexrelid order by count(*) desc)
 FROM
 ( SELECT indexrelid, indrelid FROM pg_index
 WHERE indexrelid in (None)
 UNION ALL
 SELECT indexrelid, indrelid FROM gp_dist_random('pg_index')
 WHERE indexrelid in (None)
 ) allpar_index
 GROUP BY indexrelid, indrelid
 ) par_index
 WHERE rank=1
 ) par ON childoid = oid 

Environment

Cause

It's a known issue and being worked on by the DEV team as of now. 

This error will show up sometimes when trying to generate a summary report and it will disappear right after catalog issues are fixed.

Resolution

It's not a real issue with gpcheckcat but a minor defect when generating the summary report. Try to fix all detected catalog issues first and this error will disappear.

Upgrade GPDB system when a release containing the fix is ready.