Pivotal Knowledge Base

Follow

Query failing with error message: "ERROR: Unable to detoast datum"

Environment

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

Symptom

When running a query, the query is failing with the following error:

ERROR: Unable to detoast datum (tuptoaster.c:260) (seg29 slice3 sdw8.gphd.local:1026 pid=530277) (cdbdisp.c:1326)

Resolution

When there is no statistics on a table, a query can fail with this error message. Check pg_class table to verify if there are stats on the table.

To fix this issue all the tables in the query need to be analyzed.

To analyze a table you need to run the following on all the tables:

analyze table_name;

Comments

Powered by Zendesk