Bug #18551: multiple pconnect => too many established TCP connection

From: tl@ccf.fr Operating system: windows 2000 PHP version: 4.2.2 PHP Bug Type: MySQL related Bug description: multiple pconnect => too many established TCP connection PHP is running as apache module (apache version 2.0.39) Multiple call to mysql_Pconnect on same mysqldb host with eachtime same host,user and password parameters cause in somecase to return different php ressourceID. So, as persistent connection on php apache module will be available until thread die, (silently) more and more opened connection to mysql are made. After a certain time, it causes apache to stop to serve http request (without apache2 service die) with an "Cannot get free socket to listen on 0.0.0.0:80) because at this time, it seems there is too many TCP ESTABLISHED state connection between apache and mysql (near 80 on my system). Trying to play with multithreading apache configuration, can delay this problem (serveral hours), but not resolve it;Same for apache keepalive sets to on or off. The only way I found to avoid this trouble is just use non-persistent connection. In this case I can observe that there is always one uniq ressource id for the same host, user and password mysql_connect. PS: Mysql and apache on the same computer. Mysql, apache and php timeouts configurations are all sets by default. Mysql, apache and php are newer installion on a newer W2000 computer. -- Edit bug report at http://bugs.php.net/?id=18551&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18551&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18551&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18551&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18551&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18551&r=support Expected behavior: http://bugs.php.net/fix.php?id=18551&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18551&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18551&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18551&r=globals