Pivotal Knowledge Base

Follow

gpcheckcat reports ERROR: column "none" does not exist

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
OS RHEL 6.x
Others  

Symptom

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 

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.

 

 

Comments

Powered by Zendesk