PHP 4.0 Bug #6383 Updated: DB Persistent Connection not re-used

ID: 6383 Updated by: jmoore Reported By: Howard.Cohodas@dkt.com Status: Open Bug Type: MySQL related Assigned To: Comments: Your assumption that I was running in cgi mode is not accurate. I may have failed to mention it in the bug report, but a note to me before you closed the bug would have cleared up the misunderstanding. The problem: In a Windows environment using the ISAPI version of PHP4 with several data bases (MySQL, PostgreSQL) with several servers (IIS, WebSite Pro), persistent connections are not reused and just accumulate forever or whenever the db server is stopped and restarted, whichever comes first. Howard A. Cohodas Design Knowledge Technologies Inc. Phone: (011)(330)492-9900 FAX: (011)(330)492-1100 otfGIF Encoder: http://www.dkt.com/otfGIF Previous Comments: --------------------------------------------------------------------------- [2000-10-30 14:45:02] mathieu@php.net Reopened, sorry.. Misassumption on my behave --------------------------------------------------------------------------- [2000-10-30 13:44:30] mathieu@php.net You're using PHP in a CGI environment (php.exe gets ran) Persistent Database connections are not possible for obvious reasons.. It even says in the manual. --------------------------------------------------------------------------- [2000-08-30 09:32:08] Howard.Cohodas@dkt.com Bug persists in PHP4.0.2. --------------------------------------------------------------------------- [2000-08-27 15:27:25] Howard.Cohodas@dkt.com Configuration... php-4.0.2-dev-Win32-24-8-2000.zip WinNT4 SP6a HTTP Server: WebSitePro/2.5.4 mySQL: 3.23.22-beta ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Refer to Bug id #5807. Seems similar. If so then might be OS relateded, not mySQL or PostgreSQL related. Script... <html> <head> <title>DB Persistant Connection Test</title> </head> <body> <?php $db = mysql_pconnect ("localhost", "root") or die ("Could not connect"); if (mysql_create_db ("myXdb")) { print ("Database created successfully"); } else { printf ("Error creating database: %s", mysql_error ()); } print "<br>"; if (mysql_drop_db ("myXdb")) { print "Database dropped successfully"; } else { printf ("Error dropping database: %s", mysql_error ()); } print "<br>"; mysql_close($db); show_source(__FILE__); phpinfo(); ?> </body> </html> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Problem.. Running WinMySQLadmin, observing Processes. Each time the script is run another process is added th the process list. The process goes into Sleep mode. Rather than re-using the idle persistent connection, another process is created. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=6383