argh! NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0.

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: argh! NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0.
Date: 2000-09-13 23:28:04
Message-ID: 20000913162804.Y12231@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0.

This happens after a while. Then I try:

# select * into wdbak from webhit_details_formatted;
FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
# select * into wdbak from webhit_details_formatted;
FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

# vacuum verbose analyze webhit_details_formatted;
NOTICE: --Relation webhit_details_formatted--
NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0.

85605 pgsql -2 0 1138M 765M biofre 0 0:21 7.32% 7.32% postgres

Arrrrrrrrrgh!

kill -ABRT 85605

Unfortunatly the core file I wanted was nuked because afterwards
all backends cored. I've set up the system to dump to $name.$pid.core
I'll try to get a more meaningful bug report.

ung. :(

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul 2000-09-13 23:32:00 Replication of a small portion of data to another database
Previous Message Hiroshi Inoue 2000-09-13 21:17:32 RE: Fwd: Problems inserting data