From: | "Susy Ham" <sham(at)ncircle(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: could not open relation with OID |
Date: | 2007-08-22 22:55:25 |
Message-ID: | 8A72E69E1F79004B82F76F228B3F2923086EF150@corp-mail01.ncircle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We are trying to perform a 'reindex database' and it will fail at
varying points with a message like:
ERROR: could not open relation with OID 587495058
or
ERROR: could not open relation with OID 587603875
When we queried pg_class we got no rows returned:
select oid,* from pg_class where oid in (587603875, 587495058);
oid | relname | relnamespace | reltype | relowner | relam | relfilenode
| reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers
| relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules
| relhassubclass | relacl
-----+---------+--------------+---------+----------+-------+------------
-+---------------+----------+-----------+---------------+---------------
+-------------+-------------+---------+----------+-----------+----------
---+----------+----------+---------+------------+------------+----------
---+----------------+--------
(0 rows)
select oid,* from pg_class where oid>587603875;
oid | relname | relnamespace | reltype |
relowner | relam | relfilenode | reltablespace | relpages | reltuples |
reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind |
relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs |
relhasoids | relhaspkey | relhasrules | relhassubclass | relacl
-----------+------------------------------+--------------+-----------+--
--------+-------+-------------+---------------+----------+-----------+--
-------------+---------------+-------------+-------------+---------+----
------+-----------+-------------+----------+----------+---------+-------
-----+------------+-------------+----------------+--------
587656467 | reindex_audit_network_id_idx | 2200 | 0 |
10 | 403 | 587656467 | 0 | 2 | 65 |
0 | 0 | f | f | i | 1 |
0 | 0 | 0 | 0 | 0 | f | f
| f | f |
587656343 | reindex_audit | 2200 | 587656344 |
10 | 0 | 587656343 | 0 | 1 | 65 |
0 | 0 | t | f | r | 8 |
0 | 0 | 0 | 0 | 0 | f | f
| f | f |
587656468 | reindex_audit_audit_id_idx | 2200 | 0 |
10 | 403 | 587656468 | 0 | 2 | 65 |
0 | 0 | f | f | i | 1 |
0 | 0 | 0 | 0 | 0 | f | f
| f | f |
(3 rows)
There were no reindex processes running in pg_stat_activity and
stopping/restarting postgres did not clear up these entries.
What could be causing these errors?
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2007-08-22 22:57:29 | reporting tools |
Previous Message | Dmitry Koterov | 2007-08-22 22:45:23 | Re: Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery |