#29019 [Opn]: Database not closing
| From: | cyberlot at cyberlot dot net | Date: | Mon, 05 Jul 2004 17:51:24 +0000 |
| Subject: | #29019 [Opn]: Database not closing | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-61705@lists.php.net to get a copy of this message | ||
ID: 29019
User updated by: cyberlot at cyberlot dot net
Reported By: cyberlot at cyberlot dot net
Status: Open
Bug Type: MySQL related
Operating System: Fedora Core 2
PHP Version: 5.0.0RC3
New Comment:
narrowed the problem down further, Its directly related to me trying to
extend the mysqli class. If I take out the extend it closes properly, If
I put in the extend with no functions at all it does not close properly
So
<?
$mysqli = new
extend_mysqli('localhost','billing','billing','billing');
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
?>
Connection does not close properly
<?
$mysqli = new
mysqli('localhost','billing','billing','billing');
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
?>
Connection does close properly.
Previous Comments:
------------------------------------------------------------------------
[2004-07-05 19:39:22] cyberlot at cyberlot dot net
Description:
------------
mysqli, using class interface not not closing connection at end of
script unless you specificly call $mysqli->close
This is a change of behavior from the normal mysql extension which does
not "require" you to close connection.
Reproduce code:
---------------
<?
$mysqli = new
extend_mysqli('localhost','billing','billing','billing');
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
?>
Expected result:
----------------
Every time its run it should release the database connection
Actual result:
--------------
Each time you run it a new db connection is done until you max out the
mysql server.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29019&edit=1