Insert fail: could not open relation with OID 3221204992

From: araza(at)esri(dot)com
To: "postgresql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Insert fail: could not open relation with OID 3221204992
Date: 2007-03-21 22:31:00
Message-ID: 7CAD6D9B7D16BC4A88795771E48650820532225C@pianowire.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am inserting 783159 records but the insert is failing after 634314
records. I am getting "ERROR: could not open relation with OID
3221204992" message. I am using

1- PostgreSQL: 8.2.3
2- OS: Red Hat Enterprise Linux AS release 3.
3- Logfile output:
ERROR: XX000: could not open relation with OID 3221204992
LOCATION: relation_open, heapam.c:700
STATEMENT: INSERT INTO parcel (OBJECTID, shape) VALUES ( $1, $2 )

This is happening only on Linux , on Windows (pg 8.2.1), I can insert
all data.

I have gone through all the hints on the list for this thread and tried
most of them, like
- reindex pg_class
- set enable_indexscan = off;
- increase shared_buffers /temp_buffers
- SELECT oid, relname, relkind FROM pg_catalog.pg_class WHERE oid <=
3221204992 ORDER BY oid DESC LIMIT 6;

There is no temporary table and no table is being dropped / created.

No record is returned for
select oid, * from pg_class where oid = 3221204992;

Wondering if somebody have some other hints to resolve this problem?

Thanks.
Ale Raza.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2007-03-21 22:31:56 Re: best way to kill long running query?
Previous Message Martijn van Oosterhout 2007-03-21 22:18:41 Re: can't trace error!!!