Date: Sat, 19 May 2007 07:59:05 -0700 From: "Albert Wong" <ajwwong@gmail.com> To: "'Tom Judge'" <tom@tomjudge.com> Cc: freebsd-stable@freebsd.org Subject: RE: mysql frequently crash on 6.2 Message-ID: <464f10b4.4b4c3187.2623.ffffc2e7@mx.google.com> In-Reply-To: <464EC56F.5080302@tomjudge.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@tomjudge.com]
> Sent: Saturday, May 19, 2007 2:38 AM
> To: Albert Wong
> Cc: freebsd-stable@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?464f10b4.4b4c3187.2623.ffffc2e7>