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 |
