>Description:
After running for a variable amount of time, our server will just die.
We have run myisamchk several times, with -r and with -o. We even
checked the actual file system for corruption. This is a real problem
when the server doesn't automatically restart.
This is what the log looks like when it doesn't come back up:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong
Bogus stack limit or frame pointer, aborting backtrace
Number of processes running now: 0
010209 18:37:25 mysqld restarted
010209 18:37:25 Can't start server: Bind on TCP/IP port: Address already
in use
010209 18:37:25 Do you already have another mysqld server running on
port: 1433 ?
010209 18:37:25 Aborting
010209 18:37:25 mysqld ended
>Severity: serious
>Priority: high
>Category: mysql
>Class:
>Release: mysql-3.23.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, 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.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 4 min 19 sec
Threads: 101 Questions: 255072 Slow queries: 0 Opens: 139 Flush tables: 1 Open
tables: 133 Queries per second avg: 984.834
>Environment:
System: Linux db1.audiogalaxy.com 2.4.2-pre3 #1 SMP Fri Feb 9 18:01:57 CST 2001 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.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Dec 18 04:16 /lib/libc.so.6 ->
libc-2.1.94.so
-rwxr-xr-x 1 root root 4796386 Oct 5 16:46 /lib/libc-2.1.94.so
-rw-r--r-- 1 root root 22737326 Oct 5 16:09 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 5 16:09 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
