This issue seems to be very similar to the below bug http://bugs.mysql.com/bug.php?id=44538
that was raised at the time of integrating MySQL 5.1 within OpenSolaris Note: Newer version of MySQL is going to be available for OpenSolaris build 131 and supposedly should address this issue. Until then, - Sriram On 12/16/09 3:07 PM, Tim Cook - PAE wrote: > 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 >> >
