Re: PostgreSQL, NetBSD and NFS
Byron Servies <bservies@pacang.com>
From: Byron Servies <bservies@pacang.com>
To: Justin Clift <justin@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "D'Arcy J.M. Cain" <darcy@druid.net>, pgsql-hackers@postgresql.org, current-users@netbsd.org
Date: 2003-02-05T17:24:09Z
Lists: pgsql-hackers
On February 06, 2003 at 03:50, Justin Clift wrote: > 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. > > :-) > fsx. See also <http://www.connectathon.org> hth, Byron