From owner-freebsd-database@FreeBSD.ORG Mon Oct 10 23:46:11 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A47A616A420 for ; Mon, 10 Oct 2005 23:46:11 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: from web32907.mail.mud.yahoo.com (web32907.mail.mud.yahoo.com [68.142.206.54]) by mx1.FreeBSD.org (Postfix) with SMTP id 8986743D48 for ; Mon, 10 Oct 2005 23:46:10 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 71652 invoked by uid 60001); 10 Oct 2005 23:46:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=LJVT/6h7sSf3wMR2sqkQD0GMd6Lloofw2I9983bnwfJSBC/+1iRwfW+e4wHALml7RdqJ0RWX2KxIQePLWqFyiyPGo30zAr94aZtCO2UMoi4+cnnmz4L8geQAaZyIRKC/sOx9GejX2EVG1oSdivXv+9ZCvhu5a5BseO3ZVgppg5E= ; Message-ID: <20051010234610.71650.qmail@web32907.mail.mud.yahoo.com> Received: from [67.112.21.27] by web32907.mail.mud.yahoo.com via HTTP; Mon, 10 Oct 2005 16:46:10 PDT Date: Mon, 10 Oct 2005 16:46:10 -0700 (PDT) From: NMH To: questions , FreeBSD-DataBase In-Reply-To: <20051005005957.66798.qmail@web32910.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: Subject: Re: Mysql Dying at random times - points to a lib issue? - sollved Sortof X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 10 Oct 2005 23:46:11 -0000 Just to follow up to my own post (and adding FreeBSD Questions)- I wanted to share that oddly enough, going backwards and installing FreeBSD 4.11 with Mysql 4.11 With LinuxThreads solved the problem of the database dying! I would love any opinions on why this could be. It seems to have found a possible SCSI issue, but so far MYSQL hasn't died in 36 hrs. it usualy was at least once every 8-12. Thanks NMH The hardware.. Tyan S2882 MB with one Opteron 248 - 4 gigs of ram Was FreeBSD 5.4-RELEASE-p6 i386 Now FreeBSD 4.11-STABLE i386 Infortrend RAID unit with 4 channels. 3 channels of RAID 1 storage with heavy databases tables on seperate arrays. (symlinked) and one channel for binlogs. --- NMH wrote: > > Hello.. > > Currently, our mysql database is crashing at random > intervals though out the day during heavy load. A > mysql support engineer traced the problem to > libthr. > > > #0 0x28619dfe in mutex_self_lock (mutex=0x0, > noblock=0) at > /usr/src/lib/libthr/thread/thr_mutex.c:615 > 615 PANIC("Shouldn't resume here?\n"); > > The Database server is running i386 FreeBSD 5.4 > Release-P6, with 4 gigs of ram, on an > AMD Opteron(tm) Processor 248 (2191.84-MHz 686-class > CPU). W/ infotrend raiding solution. > > Apparently, there have been some updates (beyond my > ability to understand) to the libthr package, which > have not yet been backported to the 5.4 > release...?? (changes in 6.0 that seem pertinant) > > We have attempted to use KSE, and pthreads Binary > from MYSQL, but we encountered even WORSE problems > with those packages. > The mysqld would consistantly crash in those > threading > packages, usually within a minute or so of > testing... > Usually with a message > that a junk pointer was being released. (Error came > from malloc.c). > > We were able to reproduce the memory problem on a > seperate machine with a different hardware > configuration, but same OS. And on other machines > with the same hardware configuration. > > > A mysql support engineer is currently checking > around > to see if there are any solutions, but meanwhile... > I > thought many heads are better than one. > > All of these problems started when we migrated to > this new server, which hardware wise was very > similiar > to the old one. However the old one was running > Mysql > 4.0.18 and FreeBSD 5.1-Release-P11. > According to /usr/src/UPDATING some lib changes > occured after this time. > > Currenly, on their suggestion, we are using > /etc/libmap.conf entry of > libpthread.so libthr.so > libpthread.co.1 libthr.so.1 > > Which seems backwards to what people on here have > recommended. But seemed to help but we are still > crashing at least once a day sometimes more. > > > Any pointers, tips etc quite welcomed. > > Thanks! > The Large Print Giveth And The Small Print Taketh Away -- Anon __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/