#44555 [Opn]: mysql.connect_timeout ignored
ID: 44555
Updated by: uw@php.net
Reported By: tstarling at wikimedia dot org
Status: Open
Bug Type: MySQL related
Operating System: Windows XP
PHP Version: 5.2.5
Assigned To: uw
New Comment:
As I see it the upper wait time is set to 100s. Your Windows gives a
DNS timeout after 20s. PHP bails at you after 20s. 20s < 100s, all
fine.
Previous Comments:
------------------------------------------------------------------------
[2008-07-15 16:21:05] tstarling at wikimedia dot org
s/ARIN/IANA
------------------------------------------------------------------------
[2008-07-15 15:27:20] tstarling at wikimedia dot org
No of course the host "1.2.3.4" doesn't exist, it's an IP address in
the unused 1.0.0.0/8 block reserved by ARIN, that's the point.
If I instead use a hostname for a host which responds to DNS rapidly,
but drops ignores SYN packets on the port in question (such as
www.google.com), the result is the same.
Are you asking me this question because you've tried it and can't
reproduce it? If so, maybe I can help to isolate the configuration.
------------------------------------------------------------------------
[2008-07-14 16:57:08] uw@php.net
Does the host 1.2.3.4 exist? If not, you're probably running into the
default DNS lookup timeout of your system -> bogus, not a bug. Try
changing your system settings,
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/regentry/96406.mspx?mfr=true
------------------------------------------------------------------------
[2008-03-28 09:03:03] tstarling at wikimedia dot org
Description:
------------
mysql.connect_timeout is ignored, a fixed timeout of 20s is used.
Observed on PHP 5.2.5 WinXP, not observed on PHP 5.1.4 Linux.
Reproduce code:
---------------
print mysql_get_client_info() ."\n";
ini_set('mysql.connect_timeout',1);
$t = -microtime(true);
mysql_connect('1.2.3.4');
$t += microtime(true);
print "$t\n";
ini_set('mysql.connect_timeout',100);
$t = -microtime(true);
mysql_connect('1.2.3.4');
$t += microtime(true);
print "$t\n";
Expected result:
----------------
5.0.45
1.00128006935
99.9788169861
Actual result:
--------------
5.0.45
20.9900009632
21.0206007957
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=44555&edit=1
Thread (8 messages)