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