>Description:
Server version 3.23.49-log
Protocol version 10
OS Linux atlas 2.4.18-5smp #1
Mysqld two days ago began to crash on accepting non-local mysql connections. After a
day of database testing and debug researching I used the --skip-name-resolve in the
startup script because we noted that auth wasn't even having time to get checked on
the connection. We needed to start looking before auth. This new cmd option allows
the server to run. No system changes have occured, no hardware crashes. It is all
very bizare to us.
>How-To-Repeat:
To reintroduce the problem take out --skip-name-resolve and connect remotely.
>Fix:
Add --skip-name-resolve to the startup script.
>Submitter-Id: <submitter ID>
>Originator: Andy Ciordia
>Organization:
Planned Giving Design Center
>MySQL support: none
>Synopsis: Mysqld crashing on DNS lookup
>Severity: serious
>Priority: medium
>Category: mysql
>Class:
>Release: mysql-3.23.49 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386
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.49-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 6 min 6 sec
Threads: 1 Questions: 86 Slow queries: 0 Opens: 41 Flush tables: 1 Open tables:
30 Queries per second avg: 0.235
>Environment:
System: Linux atlas 2.4.18-5smp #1 SMP Mon Jun 10 15:19:40 EDT 2002 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-112)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='gcc' CXXFLAGS='-O2 -march=i386
-mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti
-fno-exceptions' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 7 18:29 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x 1 root root 1260480 Sep 9 10:16 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2312410 Sep 9 10:02 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 9 09:56 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Aug 26 12:55 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline --enable-shared
--with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-innodb --with-berkeley-db --enable-large-files=yes
--enable-largefile=yes --with-thread-safe-client --enable-assembler
---------------------------------------------------------------------
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
