#30666 [NEW]: mysql_connect reports unable to connect after numerous requests

From: Date: Tue, 02 Nov 2004 19:31:23 +0000
Subject: #30666 [NEW]: mysql_connect reports unable to connect after numerous requests
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-68641@lists.php.net to get a copy of this message
From: eugene dot kharkov at videinfra dot com Operating system: W2K Pro, Win XP Pro,Win 2003 Srv PHP version: 4.3.9 PHP Bug Type: MySQL related Bug description: mysql_connect reports unable to connect after numerous requests Description: ------------ I executed a simple script on Windows and Linux platforms. I used Apache Jmeter to simulate server load (5 concurrent connections per second to each platform). In both cases I used the same MySQL server. Settings in php.ini file on both platforms were the same. After a number of requests, script on Windows platform started responding Can't connect to MySQL server on '10.0.1.4' (10048), whereas script on Linux continue its work. 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"; ?> -- Edit bug report at http://bugs.php.net/?id=30666&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30666&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30666&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30666&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30666&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30666&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30666&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30666&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30666&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30666&r=support Expected behavior: http://bugs.php.net/fix.php?id=30666&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30666&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30666&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30666&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30666&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30666&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30666&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30666&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30666&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30666&r=mysqlcfg

« previous php.bugs (#68641) next »