| 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: | Whole Thread | Raw Message | 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!!! |