ERROR: could not open relation with OID - Mailing list pgsql-general

From Steve Crawford
Subject ERROR: could not open relation with OID
Date
Msg-id 5537EB02.3060806@pinpointresearch.com
Whole thread Raw
Responses Re: ERROR: could not open relation with OID  (Andomar <andomar@aule.net>)
Re: ERROR: could not open relation with OID  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
This morning we got the following error from a daily script that
produces a simple largest-table report:
ERROR: could not open relation with OID 597597503

I reran the script and it completed without error.

Our server is running 9.1.15 from PgDg Ubuntu repos and the query run by
the script is:

SELECT
     relname AS TABLE,
     lpad ( pg_size_pretty ( pg_relation_size ( oid ) ), 9 ) AS SIZE,
     ( 100 * pg_relation_size ( oid ) /
             ( SELECT
                 sum ( pg_relation_size ( oid ) )
             FROM
                 pg_class
             WHERE
                 relkind = 'r' ) ) ::numeric ( 4, 1 ) AS percent
FROM
     pg_class
WHERE
     relkind = 'r'
ORDER BY
     relpages DESC
LIMIT 60;

My research hasn't led to a definitive conclusion on how to trace this
issue and how much I should be concerned about this error.

If it is of importance, it appears that a temporary table and temporary
index were being created within the same second that the query was run.

Any advice?

Cheers,
Steve


pgsql-general by date:

Previous
From: Joseph Kregloh
Date:
Subject: LDAP Authentication
Next
From: Andomar
Date:
Subject: Re: ERROR: could not open relation with OID