From owner-freebsd-database@FreeBSD.ORG Wed Oct 5 00:59:58 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 8BC7D16A41F for ; Wed, 5 Oct 2005 00:59:58 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: from web32910.mail.mud.yahoo.com (web32910.mail.mud.yahoo.com [68.142.206.57]) by mx1.FreeBSD.org (Postfix) with SMTP id 2E59943D46 for ; Wed, 5 Oct 2005 00:59:57 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 66800 invoked by uid 60001); 5 Oct 2005 00:59:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=aJMRBOv6a4Aa+kVVs8saB7dbknC1yMlVSHA14T0UZWR/LqbFc+qQ0NljyUllzixaUNQKGZ+x+t96nqlYfhkM7siwNutl6Jk3edQvM2toZ1mI1FSXk6UbzYdp53lpeezB3UP3D4Ew+97SKuN9zmJgFhUz9aDR6lDQFPUEzw9rWeI= ; Message-ID: <20051005005957.66798.qmail@web32910.mail.mud.yahoo.com> Received: from [67.112.21.27] by web32910.mail.mud.yahoo.com via HTTP; Tue, 04 Oct 2005 17:59:57 PDT Date: Tue, 4 Oct 2005 17:59:57 -0700 (PDT) From: NMH To: FreeBSD-DataBase MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: Mysql Dying at random times - points to a lib issue? 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: Wed, 05 Oct 2005 00:59:58 -0000 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! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com