Skip site navigation (1) Skip section navigation (2)

Re: BUG #4727: Unable to drop table for cache lookup failed for relation

From: Lorenzo Bolzani <l(dot)bolzani(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4727: Unable to drop table for cache lookup failed for relation
Date: 2009-03-24 17:10:02
Message-ID: ca9f7d100903241010x2ffa9337m8db5fbd4f3f5fd53@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
2009/3/24 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "lorenzo" <l(dot)bolzani(at)gmail(dot)com> writes:
>> I am unable to drop a table receiving this error
>> ERROR:  cache lookup failed for relation 925244
>
> Can you provide a self-contained test case that creates this problem?
> Something like "do these SQL commands over and over, and eventually
> it'll fail" would be enough.

No, I cannot, it happened about 5 times in 8 months. I am not able to
reproduce it at will.

I only have a zip containing the whole data directory when the problem
was present (27 mb).


Bye

Lorenzo

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-03-24 18:03:17
Subject: Re: BUG #4727: Unable to drop table for cache lookup failed for relation
Previous:From: Tom LaneDate: 2009-03-24 15:38:41
Subject: Re: BUG #4727: Unable to drop table for cache lookup failed for relation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group