ERROR: could not open relation with OID 22617039
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
"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