Re: Corrupt data pages... - Mailing list pgsql-hackers

From Kevin Brown
Subject Re: Corrupt data pages...
Date
Msg-id 20060419000624.GH11892@filer
Whole thread Raw
In response to Re: Corrupt data pages...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> It's fairly hard to see how that could happen inside Postgres.  One can
> readily imagine bugs that might replace one whole page with another,
> but there aren't any operations that manipulate half-a-page.  On the
> other hand, if your kernel uses 4K blocksize, this could be explained
> as substitution of one buffer for another at the kernel level.  So my
> money is on a kernel bug.  As I mentioned, we've once or twice before
> seen reports that looked like similar substitutions of single pages by
> the kernel.

Yeah, I agree that's what's likely to have happened here.  The
kernel's page size is 4k, as is the default block size used by XFS.

Tracking this one down any further is going to be nigh unto
impossible, I think.

There have been a pile of fixes to XFS in 2.6.16, so I'll start using
that, at least...


Thanks for looking at this.


-- 
Kevin Brown                          kevin@sysexperts.com


pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: Google SoC--Idea Request
Next
From: Bruce Momjian
Date:
Subject: Re: Strange results from to_timestamp