pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Can't drop tables ERROR: cache lookup failed for relation 411727 2+ messages / 2 participants [nested] [flat]
* Can't drop tables ERROR: cache lookup failed for relation 411727 @ 2007-05-24 09:43 Fuzzygoth <dav.phillips@ntlworld.com> 0 siblings, 1 reply; 2+ messages in thread From: Fuzzygoth @ 2007-05-24 09:43 UTC (permalink / raw) To: pgsql-admin Hello All, I have been attempting to move our database to our new database server but i have encountered a few problems along the way. One of the errors that I encountered was the error below when trying to drop a table so I could re-build it. ERROR: cache lookup failed for relation 411727 Never having seen this error I turned to Google to try and determine what the problem is and found this entry from our previous Web Dev/DBA about a slony issue. Unfortunatly for us he has moved on to better things which means i can't quiz him on what happened and what he done to resolve it if he indeed was able to. Having read through the thread it seems to be the same or a similar issue http://www.thescripts.com/forum/thread423390.html I need to be able to determine whats causing this, This will be the second time the Database has moved since and while the errors mentioned in the above thread where on a test Database we did have slony ver 1 running on our live database and I am wondering if this could be responsible for the errors esspecially as after the last DBA left company no one appears to know what happened with slony (I started as he left there was nothing in the handover as I'd never seen postgres before). So basically I need to find a way to figure out what the errors are and find a way to resolve them, I only noticed this when testing and over night build of our database tables and one that usually takes 35 mins took 2 hours 10 minutes which was unacceptable. DB: PostgreSQL 8.1.9 OS: Red Hat Enterprise 5 Thanks In advance David Phillips Cromwell Tools Ltd Leicester ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Can't drop tables ERROR: cache lookup failed for relation 411727 @ 2007-05-24 15:32 Tom Lane <tgl@sss.pgh.pa.us> parent: Fuzzygoth <dav.phillips@ntlworld.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-05-24 15:32 UTC (permalink / raw) To: Fuzzygoth <dav.phillips@ntlworld.com>; +Cc: pgsql-admin Fuzzygoth <dav.phillips@ntlworld.com> writes: > I have been attempting to move our database to our new database server > but i have encountered a few problems along the way. One of the errors > that I encountered was the error below when trying to drop a table so > I could re-build it. > ERROR: cache lookup failed for relation 411727 If this database has been a slony slave in the past, then this could indeed be slony's fault. You'd get better answers about that (and about how to deal with it) on the slony mail lists --- see http://lists.slony.info/mailman/listinfo regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-05-24 15:32 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-05-24 09:43 Can't drop tables ERROR: cache lookup failed for relation 411727 Fuzzygoth <dav.phillips@ntlworld.com> 2007-05-24 15:32 ` Re: Can't drop tables ERROR: cache lookup failed for relation 411727 Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox