Re: ERROR: cache lookup failed for type 14237017

On Tue, Sep 21, 2010 at 2:06 PM, Jens Wilke <jens@wilke.org> wrote:
> On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
>> Yesterday, I had twelve thousand  "cache lookup failed for type N"
>> messages, like this:
>
>> What does "type 14237017" mean?
>
> pg_type oid

Dear Jens,

  I am trying to understand your reply.

  pg_type is a catalog of data types:
http://www.postgresql.org/docs/8.4/static/catalog-pg-type.html

  An OID is a key to system table:
http://www.postgresql.org/docs/8.4/static/datatype-oid.html
I guess it's used to identify a row in a system table.

  So PostgreSQL was trying to lookup a row in a system table and did
not find it in a cache.


>> What cache are we talking about?
>
> Did you alter a type before?

No.  I don't even know how to alter a type.

> There's a bug in postgres, that prevents the plan cache to be
> invalidated on type changes. We ran into this bug as well on 8.4.4.

Is there a bug id or a URL for the bug, please?  I'd like to study the
bug description to
understand it better.

Sincerely,
Aleksey