Subject: Re: [HACKERS] PostgreSQL, NetBSD and NFS
To: Tom Lane <tgl@sss.pgh.pa.us>
From: Justin Clift <justin@postgresql.org>
List: current-users
Date: 02/06/2003 03:50:48
Tom Lane wrote:
<snip>
> Hoo boy.  I was already suspecting data corruption in the index, and
> this looks like more of the same.  My thoughts are definitely straying
> in the direction of "the NFS server is dropping bits, somehow".
> 
> Both this and the (admittedly unproven) bt_moveright loop suggest
> corrupted values in the cross-page links that exist at the very end of
> each btree index page.  I wonder if it is possible that, every so often,
> you are losing just the last few bytes of an NFS transfer?

Hmmm... does anyone remember the name of that NFS testing tool the 
FreeBSD guys were using?  Think it came from Apple.  They used it to 
find and isolate bugs in the FreeBSD code a while ago.

Sounds like it might be useful here.

:-)

Regards and best wishes,

Justin Clift


> 			regards, tom lane


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi