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 don’t 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: ptufenkji@usj.edu.lb