From owner-freebsd-current@FreeBSD.ORG Wed Aug 4 20:51:56 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 70C7116A4CE for ; Wed, 4 Aug 2004 20:51:56 +0000 (GMT) Received: from mail.parodius.com (mail.parodius.com [64.62.145.229]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3515443D58 for ; Wed, 4 Aug 2004 20:51:56 +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 i74KptsA047191 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 4 Aug 2004 13:51:55 -0700 (PDT) (envelope-from jdc@pentarou.parodius.com) Received: (from jdc@localhost) by pentarou.parodius.com (8.12.11/8.12.11/Submit) id i74Kpt9A047190 for current@freebsd.org; Wed, 4 Aug 2004 13:51:55 -0700 (PDT) (envelope-from jdc) Date: Wed, 4 Aug 2004 13:51:55 -0700 From: Jeremy Chadwick To: current@freebsd.org Message-ID: <20040804205155.GA47128@parodius.com> Mail-Followup-To: current@freebsd.org References: <20040804203456.GA46377@parodius.com> <20040804204915.8337A5D08@ptavv.es.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040804204915.8337A5D08@ptavv.es.net> 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 20:51:56 -0000 Thanks for the heads up, Kevin. I'll revert system settings (BIOS and the like -- we use a combo of BIOS-level serial console and FreeBSD serial console in boot0/boot2/kernel) and give things a shot again. I'm likely going to keep HTT/SMP off, however, since it's just a UP box anyways. I'll report back my findings (here in this thread) in a few days. Again, thanks! -- | 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 01:49:15PM -0700, Kevin Oberman wrote: > > 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