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.
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!!! |