From owner-freebsd-stable@FreeBSD.ORG Tue Mar 29 08:54:55 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 382FB16A4CE for ; Tue, 29 Mar 2005 08:54:55 +0000 (GMT) Received: from mx.bmby.co.il (l192-114-46-204.broadband.actcom.net.il [192.114.46.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 70A4943D1D for ; Tue, 29 Mar 2005 08:54:50 +0000 (GMT) (envelope-from uzi@bmby.com) Received: from [10.0.0.3] (unknown [10.0.0.3]) by mx.bmby.co.il (Postfix) with ESMTP id 083E57A6A1; Tue, 29 Mar 2005 10:58:02 +0000 (UTC) Message-ID: <424917DC.8080805@bmby.com> Date: Tue, 29 Mar 2005 10:54:52 +0200 From: Uzi Klein User-Agent: Mozilla Thunderbird 1.0 (X11/20050111) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Young Lee References: <20050329141522.DD32.NCISOFT@163.com> <4248F797.1060509@bmby.com> <20050329153507.DD38.NCISOFT@163.com> In-Reply-To: <20050329153507.DD38.NCISOFT@163.com> Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 7bit 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 08:54:55 -0000 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 Features=0xbfebfbff Hyperthreading: 2 logical CPUs real memory = 2147430400 (2047 MB) avail memory = 2100178944 (2002 MB) FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 6 cpu3 (AP): APIC ID: 7 ioapic0 irqs 0-23 on motherboard ioapic1 irqs 24-47 on motherboard ... > > -------------------- dmesg with up below --------------------- > Copyright (c) 1992-2005 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.4-PRERELEASE #2: Thu Mar 24 19:16:17 CST 2005 > root@admin.smartdove.com:/usr/obj/usr/src/sys/GENERIC > Timecounter "i8254" frequency 1193182 Hz quality 0 > CPU: Intel(R) Xeon(TM) CPU 2.40GHz (2387.28-MHz 686-class CPU) > Origin = "GenuineIntel" Id = 0xf29 Stepping = 9 > Features=0xbfebfbff MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE> > real memory = 2147352576 (2047 MB) > avail memory = 2095882240 (1998 MB) > ACPI APIC Table: > ioapic0: Changing APIC ID to 8 > ioapic1: Changing APIC ID to 9 > ioapic2: Changing APIC ID to 10 > MADT: Forcing active-low polarity and level trigger for SCI > ioapic0 irqs 0-15 on motherboard > ioapic1 irqs 16-31 on motherboard > ioapic2 irqs 32-47 on motherboard > npx0: on motherboardusing > npx0: INT 16 interfaceusing > acpi0: on motherboard > acpi0: Power Button (fixed) > Timecounter "ACPI-safe" frequency 3579545 Hz quality 1000 > acpi_timer0: <32-bit timer at 3.579545MHz> port 0x808-0x80b on acpi0 > cpu0: on acpi0 > pcib0: port 0xcf8-0xcff on acpi0 > pci0: on pcib0 > pci0: at device 4.0 (no driver attached) > pci0: at device 4.1 (no driver attached) > pci0: at device 4.2 (no driver attached) > pci0: at device 14.0 (no driver attached) > atapci0: port 0x8b0-0x8bf,0x376,0x170-0x177,0x3f6,0x1f0-0x1f7 at device 1 > 5.1 on pci0 > ata0: channel #0 on atapci0 > ata1: channel #1 on atapci0 > ohci0: mem 0xfe100000-0xfe100fff irq 5 at device 15.2 on pci0 > usb0: OHCI version 1.0, legacy support > usb0: SMM does not respond, resetting > usb0: on ohci0 > usb0: USB revision 1.0 > uhub0: (0x1166) OHCI root hub, class 9/0, rev 1.00/1.00, addr 1 > uhub0: 4 ports with 4 removable, self powered > isab0: at device 15.3 on pci0 > isa0: on isab0 > pcib1: on acpi0 > pci4: on pcib1 > pcib2: at device 8.0 on pci4 > pci5: on pcib2 > aac0: mem 0xf8000000-0xfbffffff irq 30 at device 8.1 on pci4 > aac0: i960RX 100MHz, 54MB cache memory, optional battery present > aac0: Kernel 2.8-0, Build 6082, S/N a438d3 > aac0: Supported Options=275c > pcib3: on acpi0 > pci3: on pcib3 > bge0: mem 0xfcf10000-0xfcf1ffff irq 28 at device 6.0 on p > ci3 > miibus0: on bge0 > brgphy0: on miibus0 > brgphy0: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, 1000baseTX-FDX, auto > bge0: Ethernet address: 00:0d:56:ba:1f:6b > bge1: mem 0xfcf00000-0xfcf0ffff irq 29 at device 8.0 on p > ci3 > miibus1: on bge1 > brgphy1: on miibus1 > brgphy1: 10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, 1000baseTX, 1000baseTX-FDX, auto > bge1: Ethernet address: 00:0d:56:ba:1f:6c > pcib4: on acpi0 > pci2: on pcib4 > pcib5: on acpi0 > pci1: on pcib5 > fdc0: port 0x3f7,0x3f0-0x3f5 irq 6 drq 2 on acpi0 > fd0: <1440-KB 3.5" drive> on fdc0 drive 0 > atkbdc0: port 0x64,0x60 irq 1 on acpi0 > atkbd0: irq 1 on atkbdc0 > kbd0 at atkbd0 > sio0: <16550A-compatible COM port> port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0 > sio0: type 16550A > sio1: <16550A-compatible COM port> port 0x2f8-0x2ff irq 3 on acpi0 > orm0: at iomem 0xec000-0xeffff,0xc8000-0xcbfff,0xc0000-0xc7fff on isa0 > pmtimer0 on isa0 > ppc0: parallel port not found. > sc0: at flags 0x100 on isa0 > sc0: VGA <16 virtual consoles, flags=0x300> > vga0: at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0 > Timecounter "TSC" frequency 2387278408 Hz quality 800 > Timecounters tick every 10.000 msec > acd0: CDROM at ata0-master UDMA33 > aacd0: on aac0 > aacd0: 104137MB (213274368 sectors) > Mounting root from ufs:/dev/aacd0s1a > IP Filter: v3.4.35 initialized. Default = pass all, Logging = enabled > -------------------- dmesg end ------------------------------- > > -- Uzi Klein Software Development Manager BMBY Software Systems Ltd 2 Hataasia Street, Yokneam, Israel Email: uzi@bmby.com Phone: +972 4 959 79 89 Mobile: +972 52 374 53 34 Fax: +972 3 617 93 36 Web: http://www.bmby.com