Re: Detecting corrupted pages earlier - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: Detecting corrupted pages earlier
Date
Msg-id 20030218094049.GP1833@filer
Whole thread Raw
In response to Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Detecting corrupted pages earlier
List pgsql-hackers
Tom Lane wrote:
> The cases I've been able to study look like the header and a lot of the
> following page data have been overwritten with garbage --- when it made
> any sense at all, it looked like the contents of non-Postgres files (eg,
> plain text), which is why I mentioned the possibility of disks writing
> data to the wrong sector.

That also sounds suspiciously like the behavior of certain filesystems
(Reiserfs, for one) after a crash when the filesystem prior to the
crash was highly active with writes.  Had the sites that reported this
experienced OS crashes or power interruptions?


-- 
Kevin Brown                          kevin@sysexperts.com


pgsql-hackers by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Detecting corrupted pages earlier
Next
From: Christoph Haller
Date:
Subject: Re: Group by, count, order by and limit