On Tue, Sep 21, 2010 at 3:10 PM, Jens Wilke wrote:
> On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
>
>> So PostgreSQL was trying to lookup a row in a system table and
>> did not find it in a cache.
>
> yes,
> select * from pg_type where oid =14237017
Thank you.
>>> Did you alter
On Dienstag, 21. September 2010, Aleksey Tsalolikhin wrote:
Hi Aleksey,
> So PostgreSQL was trying to lookup a row in a system table and
> did not find it in a cache.
yes,
select * from pg_type where oid =14237017
>> Did you alter a type before?
> No. I don't even know how to alter a type.
On Tue, Sep 21, 2010 at 2:06 PM, Jens Wilke 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 understa
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, tha
Yesterday, I had twelve thousand "cache lookup failed for type N"
messages, like this:
2010-09-20 00:00:00 PDT ERROR: cache lookup failed for type 14237017
2010-09-20 00:00:00 PDT CONTEXT: SQL statement "INSERT INTO
mycluster.sl_log_2 (log_origin, log_xid, log_tableid, log_actionseq,
log_cmdtyp
