From owner-freebsd-current@FreeBSD.ORG Wed Aug 4 20:49:16 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 18CC816A4CE for ; Wed, 4 Aug 2004 20:49:16 +0000 (GMT) Received: from postal1.es.net (postal1.es.net [198.128.3.205]) by mx1.FreeBSD.org (Postfix) with ESMTP id 05ED943D67 for ; Wed, 4 Aug 2004 20:49:16 +0000 (GMT) (envelope-from oberman@es.net) Received: from ptavv.es.net ([198.128.4.29]) by postal1.es.net (Postal Node 1) with ESMTP (SSL) id IBA74465; Wed, 04 Aug 2004 13:49:15 -0700 Received: from ptavv (localhost [127.0.0.1]) by ptavv.es.net (Tachyon Server) with ESMTP id 8337A5D08; Wed, 4 Aug 2004 13:49:15 -0700 (PDT) To: Jeremy Chadwick In-reply-to: Your message of "Wed, 04 Aug 2004 13:34:56 PDT." <20040804203456.GA46377@parodius.com> Date: Wed, 04 Aug 2004 13:49:15 -0700 From: "Kevin Oberman" Message-Id: <20040804204915.8337A5D08@ptavv.es.net> cc: current@freebsd.org 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 20:49:16 -0000 > Date: Wed, 4 Aug 2004 13:34:56 -0700 > From: Jeremy Chadwick > Sender: owner-freebsd-current@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@es.net Phone: +1 510 486-8634