Re: ERROR: cache lookup failed for type 14237017 - Mailing list pgsql-general

From Jens Wilke
Subject Re: ERROR: cache lookup failed for type 14237017
Date
Msg-id 201009212306.09737.jens@wilke.org
Whole thread Raw
In response to ERROR: cache lookup failed for type 14237017  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Responses Re: ERROR: cache lookup failed for type 14237017  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: versioned pl/pgsql functions
Next
From: Guillaume Lelarge
Date:
Subject: Re: 9.0 pg_database datconfig ?