FreeBSD 5.3 SMP freezes with MySQL 4.1

[Young Lee]

I have try linuxthreads, it crashed, never try any optimzation option.

-- 
Young Lee


On Tue, 29 Mar 2005 17:05:54 +0800
Young Lee <ncisoft at 163.com> wrote:
> 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 <uzi at bmby.com> 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:
> > 
> > <snip>
> > ...
> > 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 at localhost.localdomain:/usr/obj/usr/src/sys/GENERIC
> > ACPI APIC Table: <HP     00000083>
> > 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
>