| 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.
| 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 |