Re: Corrupt data pages...

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Corrupt data pages...
Date: 2006-04-19 00:06:24
Message-ID: 20060419000624.GH11892@filer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sysexperts(dot)com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-04-19 03:11:26 Re: Strange results from to_timestamp
Previous Message Mark Wong 2006-04-18 20:59:20 Re: Google SoC--Idea Request