MySQL 4.1 SIGBUS failiure with FreeBSD 6.0

[Glenn Nielsen]

Thanks for the reply.

I had already found the below in a Google search.

Today I am going to try and reproduce the bug on test box.
If I can reproduce the bug I will first try building mysql
with linux threads to see if that solves the problem.

Glenn

On Thu, Mar 23, 2006 at 12:19:07AM -0800, Justin Bastedo wrote:
> There was also this thread on ther freebsd-database list a while back.
> 
> http://www.daemonnews.org/mailinglists/FreeBSD/freebsd-database/msg01178.html
> 
> couldn't search through the actual freebsd site for some reason but
> google found it.
> 
> There the author said dropping back down to 4.11 seemed to solve the
> problem. I am running a MySQL 5 server on a dual, dualcore amd 64
> system with a max queries persecond i think we hit was in the 200 -
> 300 range. If I remember back to the conversations then, I think the
> problem started to surface at about 500 or so queries persecond. I
> haven't had any problems with MySQL 5 and I really think its worth the
> step up. It seems some people at MySQL looked into the problem for
> that thread I linked to but i don't know if any type of solution was
> found on the MySQL side. It just seems the 4.x doesn't like the high
> loads on FreeBSD for some reason.
> 
> 
> 
> On 3/22/06, Kurt Jaeger <lists at complx.lf.net> wrote:
> > Hi!
> 
> --
> Justin Bastedo At Gmail Dot Com
> --------------------------------------------------
> http://www.thebastedo.com
> 
> 
> >
> > On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote:
> > > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0
> > [...]
> > > (gdb) bt
> > > #0  0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2
> > > #1  0x285190a2 in sigaction () from /usr/lib/libpthread.so.2
> > > #2  0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2
> > [...]
> > > We are using mysql-server-4.1.18_2 from ports with native threads.
> >
----------------------------------------------------------------------
Glenn Nielsen             glenn at more.net | /* Spelin donut madder    |
MOREnet System Programming               |  * if iz ina coment.      |
Missouri Research and Education Network  |  */                       |
----------------------------------------------------------------------