Обсуждение: BUG #4727: Unable to drop table for cache lookup failed for relation

The following bug has been logged online:

Bug reference:      4727
Logged by:          lorenzo
Email address:      l.bolzani@gmail.com
PostgreSQL version: 8.3.6
Operating system:   Windows Server 2003 R2 SP2
Description:        Unable to drop table for cache lookup failed for
relation
Details:

Hi,
I am unable to drop a table receiving this error

ERROR:  cache lookup failed for relation 925244

This also blocks the schema drop so the only solution is to drop the whole
database. This is not the first time it happened.
We are working with hibernate in drop-create mode, so the tables are dropped
and recreated several times a day, from 4 different workstations (one
hundred times a day or more).

I have a saved copy of the database. Please let me know how I can provide
help to fix this problem.

Thanks, bye

Lorenzo

"lorenzo" <l.bolzani@gmail.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.

            regards, tom lane

2009/3/24 Tom Lane <tgl@sss.pgh.pa.us>:
> "lorenzo" <l.bolzani@gmail.com> writes:
>> I am unable to drop a table receiving this error
>> ERROR: =A0cache 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

Lorenzo Bolzani <l.bolzani@gmail.com> writes:
> I only have a zip containing the whole data directory when the problem
> was present (27 mb).

Well, that may or may not provide any useful evidence, but if you want
to send it to me (off-list) I'll take a look.  Which database and table
shows the problem?

            regards, tom lane