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' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]