Pivotal Knowledge Base

Follow

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

Environment

Pivotal Greenplum Database (GPDB) 4.3.x

Symptom

The analyzedb script fails as 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