From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 15:18:54 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 31FFF16A510 for ; Thu, 23 Mar 2006 15:18:54 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id C0A4F43D64 for ; Thu, 23 Mar 2006 15:18:53 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (76.mnetw.more.net [207.160.138.76]) by libby.lpmo.org (Postfix) with ESMTP id E4C042841B for ; Thu, 23 Mar 2006 09:18:18 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id AB445564668; Thu, 23 Mar 2006 09:16:01 -0600 (CST) Date: Thu, 23 Mar 2006 09:16:01 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060323151601.GA13609@gkar.earthdome.org> References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 15:18:54 -0000 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 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 | */ | ----------------------------------------------------------------------