Hi!

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