#27007 [NEW]: Failed pg_connect leaves Network Socket in CLOSE_WAIT State

From: bty at requesttech dot com Operating system: RedHat 9 PHP version: 4.3.4 PHP Bug Type: PostgreSQL related Bug description: Failed pg_connect leaves Network Socket in CLOSE_WAIT State Description: ------------ When a database connection to postgres fails the assocaited socket is not closed by PHP but kept in a CLOSE_WAIT state. When doing a tcpdump if the PostgreSQL sends a FIN first the final FIN packet is not Sent by PHP leaving the socket in CLOSE_WAIT. I have checked bug reports 9252 and 16356. This IS PHPs problem as it does not correctly send the FIN packet (probably a if( GOT_FIN ) close( socket ) missing from the code) when the PostgreSQL server (or any service) sends FIN first. This is a serious issue as the only way to remove the CLOSE_WAIT sockets is to restart the web server. It is obvious that PHP is not doing something correct. Reproduce code: --------------- $resource_id = pg_connect( "host=good dbname=good user=good password=good" ); pg_close( $resource_id ); //This will put the socket in a TIME_WAIT state and will //close in a matter of minutes for( $i=0; $i < 1024; $i++ ) { $resource_id = pg_connect( "host=good dbname=good user=good password=bad" ); if( $resource_id ) pg_close( $resource_id ); } //Towards the end of this loop, connections will be refused //because too many sockets are open. //The sockets remain in the CLOSE_WAIT state until the web //server is rebooted Expected result: ---------------- Sockets are closed by the final sending of a FIN packet from PHP. Actual result: -------------- Sockets are left in CLOSE_WAIT until the web server is rebooted. -- Edit bug report at http://bugs.php.net/?id=27007&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27007&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27007&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27007&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27007&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27007&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27007&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27007&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27007&r=support Expected behavior: http://bugs.php.net/fix.php?id=27007&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27007&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27007&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27007&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27007&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27007&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27007&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27007&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27007&r=float