From owner-freebsd-questions@FreeBSD.ORG Mon Jul 31 23:50:47 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4EB4B16A4DD for ; Mon, 31 Jul 2006 23:50:47 +0000 (UTC) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8854943D4C for ; Mon, 31 Jul 2006 23:50:46 +0000 (GMT) (envelope-from grog@lemis.com) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id 64BF39BD98; Tue, 1 Aug 2006 09:20:45 +0930 (CST) Date: Tue, 1 Aug 2006 09:20:45 +0930 From: Greg 'groggy' Lehey To: Erik Kristensen Message-ID: <20060731235045.GE48182@wantadilla.lemis.com> References: <87530d2a0b64cbc84fbfd1a19eecbc0d@66.18.46.88> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="B0nZA57HJSoPbsHY" Content-Disposition: inline In-Reply-To: <87530d2a0b64cbc84fbfd1a19eecbc0d@66.18.46.88> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 VoIP: sip:0871270137@sip.internode.on.net WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-questions@freebsd.org Subject: Re: MySQL Signal 10 on FreeBSD 6.0-RELEASE-P6 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 31 Jul 2006 23:50:47 -0000 --B0nZA57HJSoPbsHY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Monday, 31 July 2006 at 11:35:04 -0400, Erik Kristensen wrote: > > I have an interesting issue with FreeBSD 6.0 and MySQL 5.0. Part of > my problem has been discussed serveral times in the past on other > mailing lists and it seems there has been fixes for older versions of > MySQL. =46rom what you say here, there's no reason to believe that your problem has been mentioned at all. > The MySQL server is currently receiving a SIGNAL 10 about once an > hour, which is causing many problems with the innodb databases that > we have running on this server. Signal 10 is SIGBUS (bus error), an error detected by the hardware. The most frequent causes are bugs in the hardware and bugs in the software. The only way to find out what causes the problem is to investigate further. Never make the assumption that any two SIGBUS problems are related. Still, SIGBUS is interesting, because just about every such error in FreeBSD is reported as a SIGSEGV (signal 11). > I am running FreeBSD 6.0-RELEASE-p6 and MySQL 5.0.22. > > In all the lists I have read regarding FreeBSD, MySQL and signal 10, > it all seems to happen with version 6.0 and the 4.1.x series of > MySQL. I can't confirm that at all. I've been chasing a number of very specific problems for some time, and as far as I can tell, there are very few cases where the server crashes. One case that I'm investigating is BUG#12251 (http://bugs.mysql.com/bug.php?id=3D12251). If any of this looks familiar to you, please let me know. > Any help in this area would be greatly appreciate as this is our > production server having issues. We are a small company with limited > resources. A start would be the documented method to track down crashes: http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html gives details. In particular, the contents of the error log will give you some idea, though probably you'll need a debugger to get a usable backtrace. Greg -- When replying to this message, please copy the original recipients. If you don't, I may ignore the reply or reply to the original recipients. For more information, see http://www.lemis.com/questions.html See complete headers for address and phone numbers. --B0nZA57HJSoPbsHY Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (FreeBSD) iD8DBQFEzpdVIubykFB6QiMRAl0iAJ9NPIqxNJNBpiODRGXZ5FLdiTIpagCff6br 1Ql6S7N4Mbau/qoPEN9uanE= =hcXb -----END PGP SIGNATURE----- --B0nZA57HJSoPbsHY--