Thread: Fixable? cache lookup failed for type

Fixable? cache lookup failed for type

From
Michael Guerin
Date:
db.DbException: select * into temp table t from fnGetCompositeIds2(7164980592);
...
Caused by: org.postgresql.util.PSQLException: ERROR: cache lookup failed for type 2720001893


I'm getting this error in my database and I'm trying to resolve it.  So far, I've re-indexed all tables, clustered all
tables,and recreated all user types and functions.  I'm in the process of doing a pg_dump/restore, although I'd prefer
notto do this since this is going to take most of the day. 

-michael