From owner-freebsd-stable@FreeBSD.ORG  Sat May 19 10:03:00 2007
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: freebsd-stable@freebsd.org
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id B732016A403
	for <freebsd-stable@freebsd.org>; Sat, 19 May 2007 10:03:00 +0000 (UTC)
	(envelope-from tom@tomjudge.com)
Received: from smtp807.mail.ird.yahoo.com (smtp807.mail.ird.yahoo.com
	[217.146.188.67])
	by mx1.freebsd.org (Postfix) with SMTP id 1C7F713C4C2
	for <freebsd-stable@freebsd.org>; Sat, 19 May 2007 10:02:59 +0000 (UTC)
	(envelope-from tom@tomjudge.com)
Received: (qmail 71147 invoked from network); 19 May 2007 09:36:19 -0000
Received: from unknown (HELO ?192.168.1.2?)
	(thomasjudge@btinternet.com@86.140.150.175 with plain)
	by smtp807.mail.ird.yahoo.com with SMTP; 19 May 2007 09:36:19 -0000
X-YMail-OSG: Z7FfmpwVM1nzuQ_NiZaPYTBdNTsMlzC1X3UapNdv06TKLdCFHw6Qu4Q6luCpkBo2GuVOArpcQKAC0oKfmAY25ms-
Message-ID: <464EC56F.5080302@tomjudge.com>
Date: Sat, 19 May 2007 10:37:51 +0100
From: Tom Judge <tom@tomjudge.com>
User-Agent: Thunderbird 1.5.0.10 (X11/20070306)
MIME-Version: 1.0
To: Albert Wong <ajwwong@gmail.com>
References: <464cb7ee.47aeb6f6.546d.7849@mx.google.com>
In-Reply-To: <464cb7ee.47aeb6f6.546d.7849@mx.google.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-stable@freebsd.org
Subject: Re: mysql frequently crash on 6.2
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 19 May 2007 10:03:00 -0000

Albert Wong wrote:
<SNIP>
> [Usually it only shows about three or four of these repeated errors.] 
> 
> I am using FreeBSD 6.2 and MySQL 4.1. I am trying to use the libthr
> threading mechanism through the libmap.conf setting, as to earlier in this
> thread post, as a possible fix. [Though, I don't know if I have in fact been
> successful in switching to libthr or not... because I'm not sure if I need
> to recompile / reboot?  I don't know if mysql was install from a port or
> not.]
> 
> In any event, my libmap.conf settings are now [located in /etc/libmap.conf]:
> 
> 
> [mysqld]
> libc_r.so libthr.so
> libc_r.so.6 libthr.so.2
> libthr.so.2 libthr.so.2
> libpthread.so libthr.so
> libpthread.so.2 libthr.so.2
> 
> and I also added ...
> WITH_LIBMAP= yes
> 
> to my make.conf file. 
> 
> Is there something else I need to do [e.g., recompile? / reboot?] in order
> to activate libthr?  The problem remains even with these adjustments.
> 
<SNIP>

You can validate the settings in libmap.conf with ldd. Here is the 
output you should see if libmap.conf is correct.

 > $ ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
         libz.so.3 => /lib/libz.so.3 (0x6849c000)
         libwrap.so.4 => /usr/lib/libwrap.so.4 (0x684ac000)
         libcrypt.so.3 => /lib/libcrypt.so.3 (0x684b3000)
         libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x684cc000)
         libm.so.4 => /lib/libm.so.4 (0x6859b000)
         libpthread.so.2 => /usr/lib/libthr.so.2 (0x685b1000)
         libc.so.6 => /lib/libc.so.6 (0x685c4000)


Tom