7 messages in com.mysql.lists.bugsRe: Bug in mysql 3.23.36 on FreeBSD 4.2
FromSent OnAttachments
Andrei Cojocaru15 Apr 2001 19:24 
Michael Widenius16 Apr 2001 01:54 
Andrei Cojocaru16 Apr 2001 05:33 
Andrei Cojocaru16 Apr 2001 05:58 
Andrei Cojocaru16 Apr 2001 06:28 
Andrei Cojocaru16 Apr 2001 06:40 
Michael Widenius16 Apr 2001 14:47 
Subject:Re: Bug in mysql 3.23.36 on FreeBSD 4.2
From:Andrei Cojocaru (acoj@hotmail.com)
Date:04/16/2001 06:28:46 AM
List:com.mysql.lists.bugs

I applied the patch you gave me and now it gets a broken pipe signal along with the segmentation fault. I will reply with a stack backtrace of the broken pipe. Fun eh? :)

-Andrei Cojocaru

From: Michael Widenius <mon@mysql.com>

Reply-To: mon@mysql.com To: "Andrei Cojocaru" <acoj@hotmail.com> CC: bu@lists.mysql.com Subject: Bug in mysql 3.23.36 on FreeBSD 4.2 Date: Mon, 16 Apr 2001 11:54:54 +0300 (EEST) MIME-Version: 1.0 Received: from [195.255.166.130] by hotmail.com (3.2) with ESMTP id MHotMailBCA40026002040043149C3FFA68294890; Mon Apr 16 02:02:31 2001 Received: (from monty@localhost)by narttu.mysql.fi (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) id f3G8ssL23390;Mon, 16 Apr 2001 11:54:54 +0300 From mon@narttu.mysql.com Mon Apr 16 02:04:26 2001 Message-ID: <1506@narttu.mysql.fi> In-Reply-To: <F212@hotmail.com> References: <F212@hotmail.com> X-Mailer: VM 6.75 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid

Hi!

"Andrei" == Andrei Cojocaru <acoj@hotmail.com> writes:

Andrei> I know I am supposed to post a reproducible bug, but I belive this is not, Andrei> but I can give the developers access to my machine and data and all through Andrei> ssh, here is the original post I made at mys@lists.mysql.com:

Andrei> Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am Andrei> running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the Andrei> same problem, I upgraded to 3.23.36 today and it had the same problem. I Andrei> have recompiled mysql in full debug and done a stack trace and it keeps on Andrei> crashing in mysql_select(), here they are:

Andrei> trace #1:

Andrei> www# cd /usr/local/mysql/libexec Andrei> www# gdb mysqld

<cut>

Thanks for providing a lot of information about the problem.

A couple of questions:

- How did you compile MySQL ? (What compiler are you using...) Most important: Did you compile with the gcc option: -fno-exceptions If not, can you please recompile MySQL with this option and try again!

- Does MySQL always die if you run the query: select distinct pfs.shiptypeid, s.shipname from planetfleetships pfs, shiptypes s where s.shiptypeid=pfs.shiptypeid and pfs.planetid=3647 - If no, have you come up with any way to reproduce this crash. I would like to be able to get into a gdb session identically to the one you are

Yes, I would like to login and take a look at this.

I will send my connection details directly to you in a separate email.

Regards, Monty

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.