Date: Thu, 23 Mar 2006 09:16:01 -0600 From: Glenn Nielsen <glenn@mail.more.net> To: freebsd-database@freebsd.org Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 Message-ID: <20060323151601.GA13609@gkar.earthdome.org> In-Reply-To: <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ----------------------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060323151601.GA13609>