Re: Detecting corrupted pages earlier

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Detecting corrupted pages earlier
Date: 2003-02-18 09:40:49
Message-ID: 20030218094049.GP1833@filer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)sysexperts(dot)com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Haller 2003-02-18 10:18:05 Re: Group by, count, order by and limit
Previous Message Curt Sampson 2003-02-18 06:14:08 Re: Detecting corrupted pages earlier