ID: 35205
User updated by: robertg2 at hope dot ac dot uk
Reported By: robertg2 at hope dot ac dot uk
Status: Open
Bug Type: OCI8 related
Operating System: Solaris 8
PHP Version: 5.0.5
New Comment:
Would the fact that it's being run with Apache2 using a threaded MPM
have anything to do with it?
Previous Comments:
------------------------------------------------------------------------
[2005-11-13 14:52:15] robertg2 at hope dot ac dot uk
Hi Wez,
It's definitely 1.1.1 - unless I've gone totally delirious. phpinfo()
reports oci8 '$Revision: 1.274 $' (??), and lists the new oci8
directives and default values.
If you'd like the URL to the phpinfo() page, give me a shout.
Thanks,
Gareth
------------------------------------------------------------------------
[2005-11-13 13:55:43] [EMAIL PROTECTED]
That doesn't sound right (hence your bug report); can you verify that
you really are using the latest PECL OCI8 extension? Check your
phpinfo() output.
------------------------------------------------------------------------
[2005-11-13 13:43:51] robertg2 at hope dot ac dot uk
Hi there,
It's now the morning, and I've verified this behaviour.
<?php
$conn = oci_connect("user", "pw", "db");
?>
'netstat -an | grep 1521.*ESTABLISHED | wc -l' reports an incremented
number of connections after script execution ends.
------------------------------------------------------------------------
[2005-11-13 01:56:52] robertg2 at hope dot ac dot uk
Description:
------------
Today I've been developing on a web server connecting to a remote
Oracle 9i database using the latest 1.1.1 oci8 extension from PECL.
Unfortunately, towards the end of the day I started receiving the
Oracle error ORA-00020, indicating that the connections from the web
server to the database server were not closing automatically at script
execution end as I expected.
'netstat -an | grep 1521 | wc -l' on the web server reports 436 which
is waaaaaay too high for a Saturday and is not representative of the
load we are receiving.
I understand that I am able to close the connections explicitly, but I
assumed that the connections would themselves be closed automatically
at end of script execution?
I just installed oci8 1.1.1 yesterday and started developing on it
today.
Thanks,
Gareth
Reproduce code:
---------------
In theory:
<?php
oci_connect($user, $password, $db);
?>
and refresh a couple of hundred times.
Expected result:
----------------
oci_connect($user, $password, $db) to return false with the error
reported by oci_error to be ORA-00020
Actual result:
--------------
not available
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35205&edit=1
