Re: Help - corruption issue?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: Help - corruption issue?
Date: 2011-04-25 19:10:15
Message-ID: 18686.1303758615@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> writes:
> I did a COPY FROM and populated the entire table. In my hard disk, the
> space consumption went up by 64GB.

> Yet, when I do a "SELECT * FROM mytable LIMIT 1" the entire DB
> crashes. There is no visible record.

There should certainly be a "visible record" somewhere, ie, the
postmaster log. It might also be productive to look in the kernel log
for events around the same time --- OOM kills would be recorded there,
and if the true story here is hardware problems there might also be
kernel log messages about that.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-04-25 19:14:32 Re: Help - corruption issue?
Previous Message Tomas Vondra 2011-04-25 19:08:28 Re: Help - corruption issue?