From owner-freebsd-current@FreeBSD.ORG Thu Apr 1 19:38:27 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 110DF16A4CE for ; Thu, 1 Apr 2004 19:38:27 -0800 (PST) Received: from carver.gumbysoft.com (carver.gumbysoft.com [66.220.23.50]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0586D43D31 for ; Thu, 1 Apr 2004 19:38:27 -0800 (PST) (envelope-from dwhite@gumbysoft.com) Received: by carver.gumbysoft.com (Postfix, from userid 1000) id ECC0D72DCA; Thu, 1 Apr 2004 19:38:26 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by carver.gumbysoft.com (Postfix) with ESMTP id E7E0372DBF; Thu, 1 Apr 2004 19:38:26 -0800 (PST) Date: Thu, 1 Apr 2004 19:38:26 -0800 (PST) From: Doug White To: Daryl Chance In-Reply-To: <20040401031036.77156.qmail@web9602.mail.yahoo.com> Message-ID: <20040401193656.S35367@carver.gumbysoft.com> References: <20040401031036.77156.qmail@web9602.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: current@freebsd.org Subject: Re: FBSD 5.2.1-p4 and mysqld problems 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: Fri, 02 Apr 2004 03:38:27 -0000 > one of the problems we are having is that there is 1 > specific table in the db (and it's only 1 database too > that this happens) is getting corrupted and forcing us > to have to repair it. This one could just be a > problem with mysql and it's just accelerated w/ using > it on FreeBSD 5.x. We haven't nailed any specific > time that this happens nor any specific > insert/select/update that could cause it. Is there > any way to verify (through FreeBSD userland commands > or ports that you may know of) that this isn't a drive > problem? Is there something I can run on FBSD that > will help me to track this problem down (perhaps some > sort of GEOM logging)? How about moving the table file out of the way and recreating it? If theres some sort of uncorrected error showing up in the file, that should lock it away. > the other problem we are having is that mysql will > lock up. 1 of the mysqld processes freezes (uses up > all the cpu) and it won't allow anymore queries > against it until we shutdown. Is there any way for me > to debug this and find out where it is hanging? Is > there a working alternative to truss? Or should I > just compile option PROCFS in and use it next time it > locks? ps auxwwww | grep mysql and look at WCHAN. That will say what is blocked in. -- Doug White | FreeBSD: The Power to Serve dwhite@gumbysoft.com | www.FreeBSD.org