Re: ERROR: could not open relation with OID 22617039 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ERROR: could not open relation with OID 22617039
Date
Msg-id 2384.1434560159@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: could not open relation with OID 22617039  ("Adriano Sperandio" <adriano.sperandio@by7.com.br>)
List pgsql-bugs
"Adriano Sperandio" <adriano.sperandio@by7.com.br> writes:
> Hello, I'm experiencing a problem when I run a given query. the error does
> not occur when I run the same query again.

Hm ... the most obvious theory is that you have a corrupted TOAST pointer
in one of those tables, but I don't see why the failure wouldn't be
reproducible if so.  I wonder if you have got flaky hardware.  Is the
complained-of OID always the same?  Can you get a similar error when
doing just "select * from" one or the other of the input tables?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Dmitri Bourlatchkov
Date:
Subject: PostgreSQL 9.4.4 Solaris 10 i386 download links point to Sparc binaries
Next
From: Jeff Janes
Date:
Subject: Re: BUG #13443: master will remove dead rows when hot standby(use slot) disconnect