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:ptufen...@usj.edu.lb> ptufen...@usj.edu.lb
