Repairing bad table?

From: Steve Wampler <swampler(at)noao(dot)edu>
To: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Repairing bad table?
Date: 2001-04-02 18:25:38
Message-ID: 3AC8C422.58BD889F@noao.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I need help - I've had a system crash that has left a table with some
invalid OIDs. How do I clean this up? If I try a vacuum analyze,
I get:

configdb=# vacuum analyze;
NOTICE: Rel attributes_table: TID 3304/23: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/28: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/31: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/33: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/40: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/41: OID IS INVALID. TUPGONE 1.
NOTICE: Rel attributes_table: TID 3304/77: OID IS INVALID. TUPGONE 1.
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.
configdb=#

Note: I have a Linux box with 1GB ram and another 480MB swap, process
resources are:

->ulimit -a
cpu time (seconds) unlimited
file size (blocks) unlimited
data seg size (kbytes) unlimited
stack size (kbytes) 8192
core file size (blocks) 1000000
resident set size (kbytes) unlimited
processes 32766
file descriptors 1024
locked-in-memory size (kb) unlimited
virtual memory size (kb) unlimited

and shared memory is 128MB, so I'm reasonably confident that the FAQ on
"Memory exhausted in AllocSetAlloc()" doesn't apply. Table only has 257000
(more or less) rows.

Any guidelines on how to repair the problem are *most* welcome!

Thanks,
Steve
--
Steve Wampler- SOLIS Project, National Solar Observatory
swampler(at)noao(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-02 18:55:46 Re: What could be the reason for EXTREMELY slow INSERTs?
Previous Message Daniel ?erud 2001-04-02 18:23:35 What could be the reason for EXTREMELY slow INSERTs?