From owner-freebsd-current@FreeBSD.ORG Sun Apr 4 18:44:46 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 377C416A4CE for ; Sun, 4 Apr 2004 18:44:46 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id A105B43D49 for ; Sun, 4 Apr 2004 18:44:44 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.30; FreeBSD) id 1BAK1h-000AkT-Nf; Mon, 05 Apr 2004 10:39:53 +0800 Message-Id: <6.0.3.0.2.20040405104252.02ad01c0@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Mon, 05 Apr 2004 10:49:50 +0900 To: chancedj@yahoo.com From: Ganbold In-Reply-To: <20040403034837.80399.qmail@web9601.mail.yahoo.com> References: <20040402190329.G46609@carver.gumbysoft.com> <20040403034837.80399.qmail@web9601.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: freebsd-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: Mon, 05 Apr 2004 01:44:46 -0000 Hi Daryl, I have exactly same problem as you. I have FreeBSD 5.2-CURRENT (did cvsup on March 23) with mysql-4.0.18 from ports collection. It is compiled with linuxthreads. Mysql is working fine, except it sometimes freezes, sometimes one or two tables get corrupted. Usually freezes once per day. Just freezes and I had to kill mysql process and start. Did you solve your problem? I also downloaded latest snapshot from mysql.com web site and installed, but nothing changes. Let me know if you find something. TIA, Ganbold At 12:48 PM 03.04.2004, you wrote: >ah! thanks :) > >It just happened again and I was able to collect the >data again. > >Before I did mysqladmin shutdown/killall -11 mysqld >http://sql.tribalwar.com/before-ps.txt > >a few times the 3 giant processes would show as -, but >then it got to the point where they weren't changing >one bit (staying at Giant) > >after I did mysqladmin shutdown/killall -11 mysqld >http://sql.tribalwar.com/after-ps.txt > >this eventually cleared up after a minute or so. > >I've given some serious thought to upgrading to >-CURRENT, but with the network stack commit comming >soon (or happening now), I don't want to get caught in >the middle of it and have severe problems. Perhaps I >should use a tag for the time right around the sysctl >change for the mp stack? > >The guy running the site just wants me to (have >someone at the colo) format the machine and go back to >4.9. > >Oh, I now have witness in the kernel...no deadlocks >from what I've seen. > >HTH, >Daryl > >--- Doug White wrote: > > On Fri, 2 Apr 2004, Daryl Chance wrote: > > > > > Thanks for your response. It just happened a few > > > minutes ago and i was able to capture all the > > output > > > into a text file. > > > > > > http://sql.tribalwar.com/ps.txt > > > > oops, sorry, I get those confused. You want 'ps > > axlwww'. WCHAN will be a > > string like "select". > > > > > I have WITNESS* options compiled into the kernel > > and > > > am going to reboot soon. Do you think it would > > help > > > in debugging this to see if there are any > > deadlocks? > > > > Potentially, although I get 100% cpu loops with kde > > that won't trigger any > > witness or invariants checks. > > > > -- > > Doug White | FreeBSD: The Power > > to Serve > > dwhite@gumbysoft.com | www.FreeBSD.org > > >__________________________________ >Do you Yahoo!? >Yahoo! Small Business $15K Web Design Giveaway >http://promotions.yahoo.com/design_giveaway/ >_______________________________________________ >freebsd-current@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-current >To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"