Subject: Re: [HACKERS] PostgreSQL, NetBSD and NFS
To: D'Arcy J.M. Cain <darcy@druid.net>
From: Tom Lane <tgl@sss.pgh.pa.us>
List: current-users
Date: 02/01/2003 13:09:43
"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> 100Mb instead of 100Mb -->1000Mb. I tried mounting with and without the TCP
> option and it seemed to act the same but it was better than before. Now it
> doesn't crash but trying to load a large table hangs. It gets to a point
> where it is calling semop over and over getting a 0 return. It does that 81
> times in 0.989004 seconds and then hangs in the PostgreSQL code. It must be
> in some sort of busy loop because there are no further system calls after the
> last semop return and the CPU usage continues to climb.
Very bizarre. Looks like the last page it read was block 104
(851968/8192) in file "/source/data/cert/base/16556/17063". Could you
provide a formatted dump of that page? I'm partial to pg_filedump which
you can get from http://sources.redhat.com/rhdb/tools.html. Use
switches -f -i to get a reasonably complete dump.
regards, tom lane