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: cache lookup failed for relation 925244Can 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