Thread: 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