>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