Re: page is uninitialized --- fixing

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: page is uninitialized --- fixing
Date: 2008-03-27 13:49:33
Message-ID: 1206625773.26138.42.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
> Brad Nicholson wrote:
> > On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> > > Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> writes:
> > > > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
>
> > > It would be easier to believe that if the uninitialized pages were all
> > > contiguous though. Do you know that this table was under heavy insert
> > > load at the time?
> >
> > It was. This table is an insert only log table that was being heavily
> > was being heavily written to at the time of the crash.
>
> Is it possible that there were *two* crashes?

There was only one crash. However, there were two separate SAN switches
that were pulled out from under the DB, not sure if that would matter.

Brad.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-03-27 14:05:08 Re: returned value from SQL statement
Previous Message Alvaro Herrera 2008-03-27 13:29:36 Re: page is uninitialized --- fixing