Re: ERROR: could not open relation with OID

From: Andomar <andomar(at)aule(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not open relation with OID
Date: 2015-04-22 20:01:27
Message-ID: 5537FE17.8040309@aule.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>
From a bit of Googling, it seems that Postgres was unable to open the
physical file that contains the relation.

Is it possible that there was an error accessing the disk? How is the
filesystem that contains your PGDATA directory mounted?

Kind regards,
Andomar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Ferguson 2015-04-22 20:09:59 Streaming-SQL Database PipelineDB (Based on PostgreSQL 9.4) - Available in Beta
Previous Message Steve Crawford 2015-04-22 18:40:02 ERROR: could not open relation with OID