From owner-freebsd-ports@FreeBSD.ORG Thu Jul 13 07:32:41 2006 Return-Path: X-Original-To: freebsd-ports@freebsd.org Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4AFC716A4DA for ; Thu, 13 Jul 2006 07:32:41 +0000 (UTC) (envelope-from SRS0=KRrBTc99=A6=metro.cx=fbsd@sonologic.nl) Received: from mx1.sonologic.nl (mx1.sonologic.nl [82.94.245.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id AF01843D45 for ; Thu, 13 Jul 2006 07:32:40 +0000 (GMT) (envelope-from SRS0=KRrBTc99=A6=metro.cx=fbsd@sonologic.nl) Received: from [127.0.0.1] (mx1.sonologic.nl [82.94.245.21]) (authenticated bits=0) by mx1.sonologic.nl (8.13.6/8.13.6) with ESMTP id k6D7WO2H094289; Thu, 13 Jul 2006 07:32:35 GMT Message-ID: <44B5F74D.5000606@metro.cx> Date: Thu, 13 Jul 2006 09:33:33 +0200 From: Koen Martens Organization: Sonologic User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.4) Gecko/20060516 Thunderbird/1.5.0.4 Mnenhy/0.7.4.0 MIME-Version: 1.0 To: "Greg 'groggy' Lehey" References: <44B52695.5050700@metro.cx> <20060712170517.GA99030@icarus.home.lan> <20060713031646.GJ19708@wantadilla.lemis.com> In-Reply-To: <20060713031646.GJ19708@wantadilla.lemis.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Helo-Milter-Authen: gmc@sonologic.nl, fbsd@metro.cx, mx1 Received-SPF: pass (mx1.sonologic.nl: 82.94.245.21 is authenticated by a trusted mechanism) Cc: freebsd-ports@freebsd.org Subject: Re: mysql signal 11 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 13 Jul 2006 07:32:41 -0000 Greg 'groggy' Lehey wrote: > On Wednesday, 12 July 2006 at 10:05:17 -0700, Jeremy Chadwick wrote: >> On Wed, Jul 12, 2006 at 06:43:01PM +0200, Koen Martens wrote: >>> I tried mysql-5.0.22 as a freebsd package, tried the official mysql >>> binary for freebsd-6.x and tried a fresh compile from the mysql >>> source tarball, all with the same problem. >>> >>> I then tried the 4.1 binary from mysql.com, that worked fine, also >>> tried the 5.1 beta binary from mysql.com, and that was fine too. >>> >>> Not sure what to do with this info, i'll probably try to make a >>> test-case for it and submit it to the mysql bug system. > > (Koen) Yes, please do. > ........ > You might like to take a look at > http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html ; we can > certainly do with the information requested there. Note also > http://bugs.mysql.com/bug.php?id=19496 , which was caused by a bug in > the thread library. It was fixed by 5.5, I think, but potentially > it's Koen's problem. Ok, I did submit the bug (#21009), with the specific query that triggers the signal 11 and a gdb backtrace. Now, I cannot reproduce it yet without using the specific database i've seen this on (a wordpress database with some 300 articles), which i can't disclose. I will try to get it reproducible with a more generic example database later if i find the time, as well as see if i can get it to run with --with-debug. I did use CCFLAGS="-g" already for the backtrace.. Gr, Koen -- K.F.J. Martens, Sonologic, http://www.sonologic.nl/ Networking, hosting, embedded systems, unix, artificial intelligence. Public PGP key: http://www.metro.cx/pubkey-gmc.asc Wondering about the funny attachment your mail program can't read? Visit http://www.openpgp.org/