Urka,
You have a SEGV happening in your server, which would be a bug. This is
the interpretation of "mysqld got signal 11" as reported on line 807 of
your mysql.err file.
On line 790 of your mysql.err file, the first "real" routine prior to
the signal handling is:
void best_access_path(JOIN*,st_join_table*,THD*,unsigned long
long,unsigned,double,double)
and it looks like this is in the optimizer.
You can (should) log a bug regarding this, along with details of your
SQL statement, mysql.err, etc.
You can also try modifying your SQL to see if that does avoids waking up
this specific bug.
Regards,
Tim
On 12/16/09 14:14, Allan Packer wrote:
> Hi,
>
> I'm on vacation the rest of this week and am about to head out of town,
> so won't be able to take a look at this. Anyone care to respond?
>
> Thanks,
> Allan
>
>
>
> Begin forwarded message:
>
>> *From: *Urka Gurka <urkagurka at yahoo.co.uk <mailto:urkagurka at
>> yahoo.co.uk>>
>> *Date: *17 December 2009 5:01:32 AM ACDT
>> *To: *databases-discuss at opensolaris.org
>> <mailto:databases-discuss at opensolaris.org>
>> *Subject: **[databases-discuss] MySQL dies on some quirries*
>>
>> Hi,
>>
>> I have just started to use open soliars and installed MySQL 5.1 from
>> the IPS. But it seems like something is wrong, when I run a query that
>> I have run before on a XP machine the server gets a fatal error and
>> ends the connection. Does anyone have an idee?
>>
>> Here is the mysql.err file
>>
>> http://pastebin.ca/1717219 <http://pastebin..ca/1717219>
>>
>> Any help is very welcome ;)
>>
>> Regards
>> JMAN
>>
>>
>>
>> _______________________________________________
>> databases-discuss mailing list
>> databases-discuss at opensolaris.org
>> <mailto:databases-discuss at opensolaris.org>
>> http://mail.opensolaris.org/mailman/listinfo/databases-discuss
>
--
Tim Cook
Performance and Applications Engineering
<> Sun Microsystems
