Dear Tom, Thank you very much for your prompt reply... I deleted this oid from pg_depend from both objid and refobjid The problem disappeared I also increased the following specs to avoid having this problem again: - kernel.shmall - kernel.shmmax - shared_buffers - max_fsm_pages - max_fsm_relations - effective_cache_size Thanks again Pascal TUFENKJI Service de Technologie de l'Information Université Saint-Joseph - Rectorat Tel: +961 1 421 132 Email: ptufenkji@xxxxxxxxxx -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Tuesday, January 22, 2013 5:53 AM To: Pascal Tufenkji Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: cache lookup failed "Pascal Tufenkji" <ptufenkji@xxxxxxxxxx> writes: > Everything was working fine until a couple of days ago, the database > is starting to display the following error more and more cache lookup > failed for relation 1852615815 Hm, what PG version is that? Is 1852615815 anywhere near the range of existing OIDs in pg_class? > If I look up for this oid in pg_class I don?t find it, but I do find > it in pg_depend. Is that normal ? No --- at least not when the classid says it's a pg_class OID, as it does here. Do you find any pg_depend rows with refobjid = 1852615815? What about other rows mentioning OID 111893? Is that OID present in pg_namespace? (The 2615 says it's a pg_namespace OID.) We have seen some previous reports suggesting that once in awhile not all the catalog entries associated with temp tables get cleaned out at backend exit. I'm not sure the cause has ever been conclusively identified, though if memory serves we have fixed a bug or two that *might* explain it. If 1852615815 doesn't seem to be a legitimate OID, it's also possible that this is just data corruption in pg_depend. If you can't find any evidence of other issues, it might be reasonable to conclude that the pg_depend row is leftover junk and delete it manually. But you should make real sure nothing is linked to it first. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
