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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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