we had the same problem. We had mysql and BIND running on single server. Upgrading BIND helped to solve this problem.
.:: Andrius Armonas ::. .:: [EMAIL PROTECTED] ::. .:: http://baubas.andrius.org ::. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 12, 2002 12:52 AM Subject: Mysqld DNS lookup causes crash > >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_L ARGEFILE_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 --sbind ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ e --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shareds tatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without -debug --without-readline --enable-shared --with-extra-charsets=complex --wi th-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mys ql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-inno db --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 > > --------------------------------------------------------------------- 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
