From owner-freebsd-stable@FreeBSD.ORG Sat May 19 15:17:37 2007 Return-Path: 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 E7B2916A4D8 for ; Sat, 19 May 2007 15:17:37 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.249]) by mx1.freebsd.org (Postfix) with ESMTP id 7212013CC53 for ; Sat, 19 May 2007 14:59:02 +0000 (UTC) (envelope-from ajwwong@gmail.com) Received: by an-out-0708.google.com with SMTP id d23so289231and for ; Sat, 19 May 2007 07:59:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:cc:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=ZUnIJ3M4Zzlj2g8EOisMHCXJy8WCkIwqJaArVhTc+hXq+ScnBopciAnsuwgDZFu6MAZjQt2F1bfl+QhaCEqjUvX8QgMtKa97/QG7Hn1Hf80HHk6JfBWKEam0Hn6Tsa6XSy2ygBrk14tPnBLtnHKBEpkNCGTsDvBInh8WGHgidlg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:cc:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=Wjh4Ek3/esXGGVG0vcPYKIceVAeYy/7nXQhqxvxrSgkscNadZ5nuprnAii4DIWGBkZbdMkcOMyBvBvlsOFf8Z+QpIi+WnSBX6+DYNGEbA/ky1CFLbr7ihjIw27qFK7BZWuSMBDKSFmXqezeK6Die+8LFrtfqiT4bB+pgVVdd+O4= Received: by 10.100.91.6 with SMTP id o6mr1878842anb.1179586741561; Sat, 19 May 2007 07:59:01 -0700 (PDT) Received: from LettingGo ( [68.183.91.198]) by mx.google.com with ESMTP id b37sm6716337ana.2007.05.19.07.59.00; Sat, 19 May 2007 07:59:00 -0700 (PDT) From: "Albert Wong" To: "'Tom Judge'" Date: Sat, 19 May 2007 07:59:05 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <464EC56F.5080302@tomjudge.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AceZ+SiTVJ9+YEzGRueWVVI9VTmBNgALLG0g Message-ID: <464f10b4.4b4c3187.2623.ffffc2e7@mx.google.com> 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 19 May 2007 15:17:38 -0000 Thanks for this tip, Tom. I think [fingers crossed] that things are stable now... :-) ldd /usr/local/libexec/mysqld yields: /usr/local/libexec/mysqld: libz.so.3 => /lib/libz.so.3 (0x28452000) libwrap.so.4 => /usr/lib/libwrap.so.4 (0x28463000) libcrypt.so.3 => /lib/libcrypt.so.3 (0x2846a000) libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x28482000) libm.so.4 => /lib/libm.so.4 (0x2854d000) libpthread.so.2 => /usr/lib/libthr.so.2 (0x28563000) libc.so.6 => /lib/libc.so.6 (0x28575000) ... though in the end, I'm not quite sure which tweak I did from above in this thread fixed it. Anyhow, thanks to you guys for all your help. Blessings, Albert > -----Original Message----- > From: Tom Judge [mailto:tom@tomjudge.com] > Sent: Saturday, May 19, 2007 2:38 AM > To: Albert Wong > Cc: freebsd-stable@freebsd.org > Subject: Re: mysql frequently crash on 6.2 > > Albert Wong wrote: > > > [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. > > > > > 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