From: | "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | cache lookup failed |
Date: | 2013-01-21 17:46:18 |
Message-ID: | 00d601cdf7ff$3a3d7600$aeb86200$@usj.edu.lb |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have an application that creates temp tables to speed up the fetching of
the data
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
I noticed that this error keeps displaying when several users access the
system simultaneously
If I look up for this oid in pg_class I dont find it, but I do find it in
pg_depend. Is that normal ?
dragon=# SELECT * from pg_class where oid = 1852615815;
relname | relnamespace | reltype | relowner | relam | relfilenode |
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers |
relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules |
relhassubclass | relfrozenxid | relacl | reloptions
---------+--------------+---------+----------+-------+-------------+--------
-------+----------+-----------+---------------+---------------+-------------
+-------------+---------+----------+-----------+-------------+----------+---
-------+---------+------------+------------+-------------+----------------+-
-------------+--------+------------
(0 rows)
dragon=# SELECT * from pg_depend where objid = 1852615815;
classid | objid | objsubid | refclassid | refobjid | refobjsubid |
deptype
---------+------------+----------+------------+----------+-------------+----
-----
1259 | 1852615815 | 0 | 2615 | 111893 | 0 | n
(1 row)
dragon=# SELECT pg_table_is_visible(1852615815);
ERROR: cache lookup failed for relation 1852615815
Can anyone help please ?
What do I have to do to solve this issue ?
Thanks in advance
Pascal TUFENKJI
Service de Technologie de l'Information
Université Saint-Joseph - Rectorat
Tel: +961 1 421 132
Email: <mailto:ptufenkji(at)usj(dot)edu(dot)lb> ptufenkji(at)usj(dot)edu(dot)lb
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-01-21 18:04:14 | Re: proposal: fix corner use case of variadic fuctions usage |
Previous Message | Adrian Klaver | 2013-01-21 17:17:04 | Re: pg_Restore |