ERROR: could not open relation with OID 22617039

Started by Adriano Sperandioalmost 11 years ago2 messagesbugs
Jump to latest
#1Adriano Sperandio
adriano.sperandio@by7.com.br

Hello, I'm experiencing a problem when I run a given query. the error does
not occur when I run the same query again.

I tried to search the object by OID, but have not found.

My Version:

----------------------------------------------------------------------------
----------------------------

PostgreSQL 9.1.15 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit

(1 row)

Command:

create temporary table qfabs as (select f.*

from

fabs as f,

(select

setor, ramo, comunidade

from

comunidades

where

setor = 177

) as c

where

( (f.ano> 2014) or (f.ano = 2014 and
f.mes>= 6) ) and

( (f.ano< 2015) or (f.ano = 2015 and
f.mes<= 5) ) and

( f.setor = c.setor and f.ramo = c.ramo and
f.comunidade = c.comunidade )

)

PostgreSql Error:

ERROR: could not open relation with OID 22617039

pastcri-dev=> SELECT oid FROM pg_class where oid=22617039;

oid

-----

(0 rows)

pastcri-dev=> select relname, relkind from pg_class where relfilenode
=22617039;

relname | relkind

---------+---------

(0 rows)

Adriano Sperandio

Diretor de Serviços e Projetos

E-mail: <mailto:adriano.sperandio@by7.com.br> adriano.sperandio@by7.com.br

<tel:%2B55%2047%203432-9000> +55 47 3432-9000 / 47 92225010
---
Microsoft Certified Professional

Microsoft Certified Technology Specialist

Oracle Database 11g Administrator Certified Associate

Attachments:

image001.pngimage/png; name=image001.pngDownload+0-2
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Adriano Sperandio (#1)
Re: ERROR: could not open relation with OID 22617039

"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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs