mysql frequently crash on 6.2

[Albert Wong]

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 at tomjudge.com]
> Sent: Saturday, May 19, 2007 2:38 AM
> To: Albert Wong
> Cc: freebsd-stable at freebsd.org
> Subject: Re: mysql frequently crash on 6.2
> 
> 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