From: it at videinfra dot lv
Operating system: Win Server 2003, Win XP Pro
PHP version: 4.3.9
PHP Bug Type: MySQL related
Bug description: cannot connect to mysql server after sending a number of concurrent
requests
Description:
------------
We met the same problem recently, when we developed a project running on
Win2003. We got cannot connect error when we tested server's productivity.
We used Apache JMeter to simulate 10 concurrent connections. Initially, we
thought that it is because of big amount of queries we run at the first
page. To make sure this is not because of the number of queries, we
created simple PHP script that creates connection to MySQL, runs simple
query like SELECT title FROM pages WHERE id = 1 and closes connection. The
result was the same. We moved the script and MySQL to a Linux server and
repeated the test. We did not get the error. We repeated the test with PHP
on windows and MySQL on Linux and the error came again. So, when we run PHP
script on windows platform, we got the error everytime irrespective MySQL
location.
Reproduce code:
---------------
<?
$t1 = time();
$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);
$t2 = time();
echo $t2 - $t1 . "<br />";
?>
--
Edit bug report at http://bugs.php.net/?id=30584&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30584&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30584&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30584&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=30584&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=30584&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=30584&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=30584&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=30584&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=30584&r=support
Expected behavior: http://bugs.php.net/fix.php?id=30584&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=30584&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=30584&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=30584&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30584&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=30584&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=30584&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=30584&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=30584&r=float
MySQL Configuration Error: http://bugs.php.net/fix.php?id=30584&r=mysqlcfg
