Pivotal Knowledge Base

Follow

gpcrondump throws out warning message " WARNING: owner of table "<table-name>" appears to be invalid "

Environment

Product Version
Pivotal Greenplum (GPDB) 4.3.x
Others  

 

Symptom

gpcrondump displays the warning messages on its logs

[WARN]:-WARNING: owner of table "<table-name>" appears to be invalid

In this situation, the error message looks like:

20150105:18:39:45|gp_dump_agent-[WARN]:-WARNING: owner of table "dist_scheme" appears to be invalid
20150105:18:39:45|gp_dump_agent-[WARN]:-WARNING: owner of table "dist_table" appears to be invalid

Cause

The error message is seen on the logs when the owners of those complaining tables are no longer available on the database and those objects remain Orphan.

xx=# select relname,relnamespace,relowner from pg_class where relname like 'dist%';

relname 	| 	relnamespace 	| relowner
----------------+-----------------------+---------
dist_scheme	|	2200		|3976597
dist_table	|	2200		|3976597

Checking the owners' name in the database:

xx=# select oid,rolname from pg_roles where oid=3976597;
  oid  | rolname
-------+---------
(0 rows)

xx=# select oid,* from gp_dist_random('pg_roles') where oid=3976597;
  oid  | rolname
-------+---------
(0 rows)

Resolution

Alternate the table to provide a valid owner to the table using the below command

alter table <table-name>  owner to <role-name> ;

for example,

alter table dist_scheme owner to gpadmin ;
alter table dist_table owner to gpadmin ;

Comments

Powered by Zendesk