Re: mysqld 4.0.15 crashing once a week or so on same queries

[gerald_clark]

[EMAIL PROTECTED] wrote:

Since moving to mysql 4.0.15 from 3.23.5x, I am getting a crash
once a week on an hourly run set of queries that are disk intensive.
# ./resolve_stack_dump -n /tmp/mysqld.stack -s mysqld.sym
0x8070640 handle_segfault + 420
0x8288108 pthread_sighandler + 184
0x80aca70 __9Log_eventP3THDUsb + 64
0x80aaa8f new_file__9MYSQL_LOGb + 203
0x807f9e0 reload_acl_and_cache__FP3THDUlP13st_table_list + 156
0x8070c4e signal_hand + 562
0x82858bc pthread_start_thread + 220
0x82bb07a thread_start + 4
 

Submitter-Id:	<submitter ID>
Originator:	root
Organization:
   

 

MySQL support: [none | licence | email support | extended email support ]
Synopsis:	mysql 4.0.15 crashing sporadically
Severity:	critical
Priority:	high
Category:	mysql
Class:		sw-bug
Release:	mysql-4.0.15-standard (Official MySQL-standard binary)
   

 

C compiler:    2.95.3
C++ compiler:  2.95.3
Environment:
   

        
System: Linux www.actionmessage.com 2.4.20-19.7 #1 Tue Jul 15 13:44:14 EDT 2003 i686 
unknown
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-113)
Compilation info: CC='gcc'  CFLAGS='-O2 -mcpu=pentiumpro'  CXX='gcc'  CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors'  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx    1 root     root           13 Jun  4 16:18 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x    2 root     root      1260480 Mar  5  2003 /lib/libc-2.2.5.so
-rw-r--r--    1 root     root      2312442 Mar  5  2003 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 Mar  5  2003 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-embedded-server' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'

 

Do not use gcc version 2.96

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]