Insert fail: could not open relation with OID 3221204992

Поиск
Список
Период
Сортировка
От araza@esri.com
Тема Insert fail: could not open relation with OID 3221204992
Дата
Msg-id 7CAD6D9B7D16BC4A88795771E48650820532225C@pianowire.esri.com
обсуждение исходный текст
Ответ на Re: deleting a foreign key that has no references  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Insert fail: could not open relation with OID 3221204992  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: can't trace error!!!
Следующее
От: "Martin Gainty"
Дата:
Сообщение: Re: best way to kill long running query?