From owner-freebsd-current@FreeBSD.ORG Wed Aug 4 21:22:07 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BCC8B16A4CE for ; Wed, 4 Aug 2004 21:22:07 +0000 (GMT) Received: from mail.parodius.com (mail.parodius.com [64.62.145.229]) by mx1.FreeBSD.org (Postfix) with ESMTP id 91B8443D31 for ; Wed, 4 Aug 2004 21:22:07 +0000 (GMT) (envelope-from jdc@pentarou.parodius.com) Received: from pentarou.parodius.com (jdc@localhost [127.0.0.1]) by mail.parodius.com (8.12.11/8.12.11) with ESMTP id i74LM7e1048115 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 4 Aug 2004 14:22:07 -0700 (PDT) (envelope-from jdc@pentarou.parodius.com) Received: (from jdc@localhost) by pentarou.parodius.com (8.12.11/8.12.11/Submit) id i74LM7HC048114 for current@freebsd.org; Wed, 4 Aug 2004 14:22:07 -0700 (PDT) (envelope-from jdc) Date: Wed, 4 Aug 2004 14:22:07 -0700 From: Jeremy Chadwick To: current@freebsd.org Message-ID: <20040804212207.GA48062@parodius.com> Mail-Followup-To: current@freebsd.org References: <1091649533.29481.42.camel@lanshark.dmv.com> <20040804203456.GA46377@parodius.com> <411152D8.2050305@alumni.rice.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <411152D8.2050305@alumni.rice.edu> User-Agent: Mutt/1.5.6i Subject: Re: Postgresql locks up server - no response at all X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Aug 2004 21:22:07 -0000 Revision 1.72 / (download) - annotate - [select for diffs], Sun Aug 1 14:31:45 2004 UTC (3 days, 6 hours ago) by scottl $ uname -a FreeBSD medusa.parodius.com 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Sun Aug 1 07:22:27 PDT 2004 root@medusa.parodius.com:/usr/obj/usr/src/sys/MEDUSA i386 Missed it by 7 hours. :-) I'll give things a shot with a newer src-all and world. -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. | On Wed, Aug 04, 2004 at 04:19:20PM -0500, Jon Noack wrote: > On 08/04/04 15:34, Jeremy Chadwick wrote: > >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). > > The one you didn't try most likely was the culprit. Robert Watson > showed that PREEMPTION and threading don't play well together right now: > http://lists.freebsd.org/pipermail/freebsd-current/2004-July/031211.html > > The thought is that PREEMPTION uncovers scheduler bugs, but nobody's > figured it out at the moment. > > >Wed Aug 4 13:28:35 PDT 2004 > >* -CURRENT box is still alive and well. > > PREEMPTION was turned off on August 1st, so if you've updated since then > things should have stabilized a bit: > http://www.freebsd.org/cgi/cvsweb.cgi/src/sys/i386/include/param.h#rev1.72 > > Jon