Re: ERROR: cache lookup failed for type 14237017

From: Jens Wilke <jens(at)wilke(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: cache lookup failed for type 14237017
Date: 2010-09-21 21:06:08
Message-ID: 201009212306.09737.jens@wilke.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

> What cache are we talking about?

Did you alter a type before?
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.

HTH, Jens

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-09-21 21:12:26 Re: versioned pl/pgsql functions
Previous Message Tony Caduto 2010-09-21 21:04:52 9.0 pg_database datconfig ?