[PHP-DEV] PHP 4.0 Bug #6383 Updated: DB Persistent Connection not re-used From: jmoore <email protected>
Date: 10/30/00

ID: 6383
Updated by: jmoore
Reported By: Howard.Cohodas <email protected>
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 <email protected>
Reopened, sorry.. Misassumption on my behave

---------------------------------------------------------------------------

[2000-10-30 13:44:30] mathieu <email protected>
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 <email protected>
Bug persists in PHP4.0.2.

---------------------------------------------------------------------------

[2000-08-27 15:27:25] Howard.Cohodas <email protected>
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 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>