From owner-freebsd-stable@FreeBSD.ORG Tue Mar 29 09:06:16 2005 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1A83C16A4CE for ; Tue, 29 Mar 2005 09:06:16 +0000 (GMT) Received: from 163.com (smtp.163.com [202.108.44.212]) by mx1.FreeBSD.org (Postfix) with SMTP id AD33E43D39 for ; Tue, 29 Mar 2005 09:06:14 +0000 (GMT) (envelope-from ncisoft@163.com) Received: from [192.168.1.15] (unknown [61.49.183.219]) by smtp4 (Coremail) with SMTP id EwC4bWcaSULGO4sC.2 for ; Tue, 29 Mar 2005 17:05:48 +0800 (CST) X-Originating-IP: [61.49.183.219] Date: Tue, 29 Mar 2005 17:05:54 +0800 From: Young Lee To: Uzi Klein In-Reply-To: <424917DC.8080805@bmby.com> References: <20050329153507.DD38.NCISOFT@163.com> <424917DC.8080805@bmby.com> Message-Id: <20050329165741.DD3B.NCISOFT@163.com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver. 2.11.02 [en] cc: ncisoft@163.com cc: freebsd-stable@freebsd.org Subject: Re: FreeBSD 5.3 SMP freezes with MySQL 4.1 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Mar 2005 09:06:16 -0000 as I said , I build mysql41-server from port without any parameters, so you can see libwrap, and i will --without it next time. the smp kernel should be crashed in 2 minutes, so my server is running with UP configuration, and the SMP dmesg wasn't saved. I wonder ADAPTIVE_MUTEXES options is suitable for SMP? I am very likely to see your kernel conf file and mysql build options, they will be very useful, thanks. -- Young Lee On Tue, 29 Mar 2005 10:54:52 +0200 Uzi Klein wrote: > Young Lee wrote: > > the system is hang and throw a fatal 12 pannic. > > > > I build mysql41-server from port without any parameters, and the > > thread lib use libpthread.so.1, use ldd to look details as below > > > > admin# ldd /usr/local/libexec/mysqld > > /usr/local/libexec/mysqld: > > libz.so.2 => /lib/libz.so.2 (0x28422000) > > libwrap.so.3 => /usr/lib/libwrap.so.3 (0x28432000) > > libcrypt.so.2 => /lib/libcrypt.so.2 (0x2843a000) > > libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x28452000) > > libm.so.3 => /lib/libm.so.3 (0x28524000) > > libpthread.so.1 => /usr/lib/libpthread.so.1 (0x2853f000) > > libc.so.5 => /lib/libc.so.5 (0x28563000) > > > > i wonder why should it uses libwrap and libstdc++... > > did you try compiling it optimized? or with linuxthreads? > > > > I use the original SMP kernel configuration file: > > > > admin# cat /usr/src/sys/i386/conf/SMP > > include GENERIC > > ident SMP-GENERIC > > options SMP > > > did you add "options SMP" in your kernel conf? > I can see the kernel loading 1 CPU > > should look like that: > > > ... > Copyright (c) 1992-2004 The FreeBSD Project. > Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 > The Regents of the University of California. All rights reserved. > FreeBSD 5.3-RELEASE-p5 #2: Tue Feb 22 16:47:08 UTC 2005 > root@localhost.localdomain:/usr/obj/usr/src/sys/GENERIC > ACPI APIC Table: > Timecounter "i8254" frequency 1193182 Hz quality 0 > CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.13-MHz 686-class CPU) > Origin = "GenuineIntel" Id = 0xf34 Stepping = 4