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