Re: page is uninitialized --- fixing - Mailing list pgsql-general

From Brad Nicholson
Subject Re: page is uninitialized --- fixing
Date
Msg-id 1206625773.26138.42.camel@bnicholson-desktop
Whole thread Raw
In response to Re: page is uninitialized --- fixing  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: page is uninitialized --- fixing  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@ca.afilias.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.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: page is uninitialized --- fixing
Next
From: "Albe Laurenz"
Date:
Subject: Re: returned value from SQL statement