Postgresql locks up server - no response at all

[Kevin Oberman]

> Date: Wed, 4 Aug 2004 13:34:56 -0700
> From: Jeremy Chadwick <freebsd at jdc.parodius.com>
> Sender: owner-freebsd-current at freebsd.org
> 
> I've seen this with our SuperMicro SuperServer 5013C-T, running mysqld.
> Please note that the server is "heavily loaded" (note the quotes); usually
> a load of around 0.50 to 1.00 at all times, with mysqld being the top
> process.  Server runs all latest -CURRENT builds.
> 
> Many people over in freebsd-threads mentioned this problem, and recommended
> all sorts-of different workarounds.  I tried every one available to me,
> except mucking with PREEMPTION (as I did not feel comfortable tinkering
> with a random .h file on the box; seemed to be a kernel-related thing,
> so I'd rather have just an "options" line for it -- I'm conditionally
> lazy).

Please note that PREEMPTION is now NOT enabled in CURRENT. scottl
changed that a day or two ago because of all of these lock-ups. He and
Julian are listed as working to isolate the problem. Scott believes it's
in the scheduler. It's not specific to either ULE or 4BSD.

So cvsup, rebuild the kernel and you should be fine.At least for a while.
-- 
R. Kevin Oberman, Network Engineer
Energy Sciences Network (ESnet)
Ernest O. Lawrence Berkeley National Laboratory (Berkeley Lab)
E-mail: oberman at es.net			Phone: +1 510 486-8634