php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #30719 can't connect to MySQL after a number of requests
Submitted: 2004-11-08 15:56 UTC Modified: 2004-11-09 11:04 UTC
From: it at videinfra dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.3.9 OS: W2K,WinXp, Win 2003 Srv
Private report: No CVE-ID: None
 [2004-11-08 15:56 UTC] it at videinfra dot com
Description:
------------
I simultaneously run one, absolutely indentical script on two different servers, one running Linux and another Windows. The script on both machines connects to the remote MySQL server on another Linux machine. The PHP script on Linux machine works fine, while the script on Windows machine gives an error - Can't connect to MySQL server on '10.0.1.4' (10048) - after a number of requests. 

I believe that this implies a bug in PHP on Windows, because as seen from the test described above, MySQL connection limit COULD NOT BE THE CAUSE, since the script on the Linux machine continues working with the same database without any problem. Also, PHP configuration files on both platforms are identical.

 

Reproduce code:
---------------
<?
$conn = mysql_connect ( '10.0.1.4', 'root', '') 
or die("Could not connect: " . mysql_error()); mysql_select_db('lub2', $conn); $res = mysql_query("SELECT title FROM pages_lv0 WHERE id = 1", $conn) 
or die("Invalid query: " . mysql_error()); 
mysql_close($conn);
echo "ok";
?>


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-11-08 20:29 UTC] tony2001@php.net
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. 

Thank you for your interest in PHP.

Duplicate of #30666.
 [2004-11-09 11:04 UTC] it at videinfra dot com
I submit the same problem, because to my knowledge it is a bug in PHP, a critical one that blocks us from the normal work. Could you please explain how do you judge that this problem is not a bug in PHP? We spent time checking the configuratiom and then conducting a series of test to understand the problem before we submit a bug here. We got a brief reply that the cause of the issue is the MySQL configuration. That just couldn't be the case if you read my previous post carefully.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Oct 06 16:01:26 2024 UTC