cache lookup failed

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 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: <mailto:ptufenkji(at)usj(dot)edu(dot)lb> ptufenkji(at)usj(dot)edu(dot)lb

Responses

Browse pgsql-general by date

  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