List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:September 13 1999 3:35pm
Subject:Unknown MySQL Server Host (110) Errors
View as plain text  
maurice@stripped writes:
 > >Description:
 > 
 > Occasionally (a dozen or so times a week), we're seeing the following
 > error logged on our web servers (the host name has been changed):
 > 
 >   [Thu Sep  2 12:15:32 1999] payment-info.cgi: DBI->connect failed: Unknown MySQL
 > Server Host 'foo.com' (110) at /usr/lib/perl5/site_perl/5.005/CM/DB.pm line 22 
 > 
 > We're using DBI 1.13 and DBD::mysql 1.2206.  According to perror, error
 > code 110 is "Connection timed out".  
 > 
 > Could someone help me understand what the potential causes for this error
 > are?  Is it likely to be DNS related?  We're using IPs in the grant
 > tables and connection code.  I increased connect_timeout to 10, which
 > has made no improvement.  Tonight, I increased the back_log variable
 > to 128.  But I'm shooting in the dark -- if anyone can help 
 > isolate the problem, it would be greatly appreciated.
 > 
 > >How-To-Repeat:
 > 
 > Unknown.  I've been unable to reproduce the problem on our development
 > machines.
 > 
 > >Fix:
 > 
 > Unknown.
 > 
 > >Submitter-Id:	<submitter ID>
 > >Originator:	
 > >Organization: ClassMates
 > >MySQL support: licence
 > >Synopsis:      Unknown MySQL Server Host Errors  	
 > >Severity:	non-critical
 > >Priority:	low
 > >Category:	mysql
 > >Class:		
 > >Release:	mysql-3.22.23b (TCX binary)
 > 
 > >Environment:
 > 	
 > System: Linux sql.classmates.com 2.0.36 #1 Sat Jun 12 04:34:19 PDT 1999 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.7.2.3/specs
 > gcc version 2.7.2.3
 > Compilation info: CC='gcc'  CFLAGS='-O6 -mpentium -fomit-frame-pointer'  CXX='gcc' 
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors'  LDFLAGS='-static'
 > Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX
binary' --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared
 > Perl: This is perl, version 5.005_03 built for i686-linux
 > 

Hi,

Looks as if there is no route to host. Something wrong with the
net. The Perl program is trying to connect to a host that is
unreachable. Please check first that you can ping the machine that you
are trying to connect to, from the same machine you have this Perl
program running.

Regards,

- Jani

-- 
+-------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen     |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       jani@stripped   |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki         |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland          |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                   |
|             /*/             \*\            Developers Team  |
+-------------------------------------------------------------+
Thread
Unknown MySQL Server Host (110) Errorsmaurice10 Sep
  • Unknown MySQL Server Host (110) ErrorsJani Tolonen13 Sep
    • Unknown MySQL Server Host (110) ErrorsMichael Widenius15 Sep