Pivotal Knowledge Base

Follow

analyzedb:mdw:gpadmin-[CRITICAL]:-analyzedb failed

Environment

Pivotal Greenplum (GPDB) 4.3.x

Symptom

The analyzedb script fails with part of a table name as the reason.

Error Message:

analyzedb:mdw:gpadmin-[CRITICAL]:-analyzedb failed. (Reason=''XXXX'') exiting... 

Cause

The analyzedb script fails if there is a table with a " "(blank space) in the name.  

Resolution

Find any tables with spaces in the name:

select n.nspname || '.' || c.relname as name from pg_class c, pg_namespace n where n.oid=c.relnamespace and c.relname like '% %';

Rename the tables to remove the spaces:

ALTER TABLE "<table name>" RENAME TO "newName"; 

 

Comments

Powered by Zendesk