Re: Detecting corrupted pages earlier

Kevin Brown <kevin@sysexperts.com>

From: Kevin Brown <kevin@sysexperts.com>
To: pgsql-hackers@postgreSQL.org
Date: 2003-02-18T09:40:49Z
Lists: 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