>Description:
sig 11 every now and then, mysqld freezes.
we have exim + courier authenticating against mysql,
also some customer databases (php)
>How-To-Repeat:
well, no idea, it just happens...
fivefold /tmp # resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
0x80cf3d4 handle_segfault__Fi + 428
0x4002e5cb _end + 935451919
0x4018900e _end + 936871762
0x40019911 _end + 935366741
0x8454120 _end + 276580
-- previously with .43 or .45 or even .48 (not overly sure about it
mysql was crashing daily. then with .52 it was working better, but
now it starts to crash again. This is a Debian box.
>Fix:
stopping all services using mysql, killing mysqld hard (-9) and
then safe_mysql does its job, restart all other services
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED] (Alexander Koch)
>Organization: cid.net, Germany
>MySQL support: none
>Synopsis: mysqld dying every some minutes
>Severity: serious
>Priority: high
>Category: mysql
>Class:
>Release: mysql-3.23.52 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.52-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 7 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.143
>Environment:
System: Linux fivefold 2.4.17 #1 SMP Tue Feb 5 14:40:34 CET 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20010827 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Nov 15 08:58 /lib/libc.so.6 -> libc-2.3.1.so
-rwxr-xr-x 1 root root 1109900 Oct 21 16:41 /lib/libc-2.3.1.so
-rw-r--r-- 1 root root 2344742 Oct 21 16:41 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 21 16:41 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin
--datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql
--includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man
--enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb
--enable-static --enable-shared --enable-local-infile --with-raid
--enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
