>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:
-rw-r--r-- 1 root bin 1908016 ξΟΡ 22 00:56 /lib/libc.a
lrwxrwxrwx 1 root root 11 ζΕΧ 1 14:50 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 805364 ξΟΡ 22 00:56 /lib/libc.so.1
-rw-r--r-- 1 root bin 1908016 ξΟΡ 22 00:56 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 ζΕΧ 1 14:50 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 805364 ξΟΡ 22 00:56 /usr/lib/libc.so.1
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'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
