mysql frequently crash on 6.2

[Tom Judge]

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