List:General Discussion« Previous MessageNext Message »
From:yur Date:March 9 2005 2:40pm
Subject:[MySQLd got signal 11 on query with UNION of SELECTs]
View as plain text  
>Description:
	

Mysqld got signal 11.

HardWare:	HP Proliant DL380G4 (5G RAM + 2 * Xeon 3.4GHz)
SoftWare:	SunOS noc-db.simtel.ru 5.9 Generic_117172-17 i86pc i386 i86pc

In error log: 
=====Start Log==========>
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=33554432
read_buffer_size=2093056
max_used_connections=3
max_connections=100
threads_connected=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 105636
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

050309 13:05:09  mysqld restarted
050309 13:05:10  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
=====End Log==========>

>How-To-Repeat:
	

   It is appeared always when execute next SQL-query with "UNION" keyword:

(SELECT SQL_BIG_RESULT `UserName` AS RA_UserName,`CalledStationId` AS
RA_Line,DATE_FORMAT(`AcctStartTime`,'%d.%m %T') AS
RA_LogOn,SEC_TO_TIME(`AcctSessionTime`) AS RA_Time,DATE_FORMAT(`AcctStopTime`,'%d.%m %T')
AS RA_LogOff,`AcctInputOctets` AS RA_InByte,`AcctOutputOctets` AS
RA_OutByte,`AcctTerminateCause` AS RA_Reason FROM radacct where AcctStartTime BETWEEN
'20050309000000' AND '20050309235959' ORDER BY `AcctStartTime` ASC LIMIT 0,300) UNION
(SELECT SQL_BIG_RESULT `UserName` AS RA_UserName,`CalledStationId` AS
RA_Line,DATE_FORMAT(`AcctStartTime`,'%d.%m %T') AS
RA_LogOn,SEC_TO_TIME(`AcctSessionTime`) AS RA_Time,DATE_FORMAT(`AcctStopTime`,'%d.%m %T')
AS RA_LogOff,`AcctInputOctets` AS RA_InByte,`AcctOutputOctets` AS
RA_OutByte,`AcctTerminateCause` AS RA_Reason FROM radacct where AcctStopTime BETWEEN
'20050309000000' AND '20050309235959' ORDER BY `AcctStartTime` ASC LIMIT 0,300) LIMIT
0,300

   The SQL-query without "UNION" keyword such as:

SELECT SQL_BIG_RESULT `UserName` AS RA_UserName,`CalledStationId` AS
RA_Line,DATE_FORMAT(`AcctStartTime`,'%d.%m %T') AS
RA_LogOn,SEC_TO_TIME(`AcctSessionTime`) AS RA_Time,DATE_FORMAT(`AcctStopTime`,'%d.%m %T')
AS RA_LogOff,`AcctInputOctets` AS RA_InByte,`AcctOutputOctets` AS
RA_OutByte,`AcctTerminateCause` AS RA_Reason FROM radacct where AcctStartTime BETWEEN
'20050309000000' AND '20050309235959' ORDER BY `AcctStartTime` ASC LIMIT 0,300)

   is successfull always 

>Fix:   Fix by using of MySQL 4.0.20

	

>Submitter-Id:	<submitter ID>
>Originator:	Yury B.Razbegin
>Organization:  Technical Center of ElectroCommunication - Ulyanovsk Branch
		of the VolgaTeleCom JSV
 
>MySQL support: none
>Synopsis:	 mysqld crash
>Severity:	 critical
>Priority:	 high
>Category:	mysql
>Class:		 sw-bug
>Release:	mysql-4.1.10-max (MySQL Community Edition - Experimental (GPL))

>C compiler:    
>C++ compiler:  
>Environment:
	
System: SunOS noc-db.simtel.ru 5.9 Generic_117172-17 i86pc i386 i86pc
Architecture: i86pc

Some paths:  //bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /opt/local/bin/../lib/gcc/i386-pc-solaris2.9/3.4.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld
--disable-nls
Thread model: posix
gcc version 3.4.2
Compilation info: CC='cc'  CFLAGS='-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore
-xbuiltin=%all -xlibmil -xlibmopt -xtarget=native'  CXX='CC'  CXXFLAGS='-DBIG_TABLES -xO3
-mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' 
LDFLAGS=''  ASFLAGS=''
LIBC: 
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=MySQL Community Edition - Experimental (GPL)'
'--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client'
'--enable-local-infile' '--with-named-curses=-lcurses' '--disable-shared'
'--with-berkeley-db' '--with-readline' '--with-embedded-server'
'--with-archive-storage-engine' '--with-ndbcluster' '--with-innodb' 'CC=cc'
'CFLAGS=-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil
-xlibmopt -xtarget=native' 'CXXFLAGS=-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none
-nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' 'CXX=CC'

Thread
[MySQLd got signal 11 on query with UNION of SELECTs]yur9 Mar