Repairing bad table?

Поиск
Список
Период
Сортировка
От Steve Wampler
Тема Repairing bad table?
Дата
Msg-id 3AC8C422.58BD889F@noao.edu
обсуждение исходный текст
Ответы Re: Repairing bad table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@noao.edu

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

Предыдущее
От: "Nick T"
Дата:
Сообщение: memory leaks fixed?
Следующее
От: Joel Burton
Дата:
Сообщение: Re: Deploying psqlodbc to Win98