ID: 35205
User updated by: robertg2 at hope dot ac dot uk
Reported By: robertg2 at hope dot ac dot uk
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Solaris 8
PHP Version: 5.0.5
Assigned To: tony2001
New Comment:
Sorry for the delay in testing.
The connection is closed off correctly when compiled against
InstantClient 10.
Previous Comments:
------------------------------------------------------------------------
[2005-11-15 19:09:31] [EMAIL PROTECTED]
... and it works fine even if the MPM if "worker", so this is not a
multithreading related issue.
Please try to build PHP with Oracle Instant Client and see if it
helps.
------------------------------------------------------------------------
[2005-11-15 14:47:40] [EMAIL PROTECTED]
Just for the record: I can't reproduce on Linux and on Solaris with
Apache2/prefork.
------------------------------------------------------------------------
[2005-11-14 01:39:02] robertg2 at hope dot ac dot uk
I believe you. We both want the same thing right?
In this role, I answer to my boss first. To the University's students
second. And to the PHP community a far third.
I'm well aware that to fix this bug I should to help you, and that's
why I shall schedule maintenance and take one of the web servers out of
the load balancing circuit when is convenient for me and the
organisation and the students it serves.
A traveller from Bug #29779, there's nothing more in PHP - and I'm a
PHP fanatic - to see a reliable oci8 library.
I'm lurking on Undernet about to ambush you when you get on :p.
------------------------------------------------------------------------
[2005-11-14 00:34:19] [EMAIL PROTECTED]
It'll take some time for me to install OCI client at Solaris and build
PHP --with-oci8, so I doubt I'll be able to do it in the nearest days.
Though, that doesn't mean that I won't do it at all.
I believe it'd be easier to install debugger and to see if this is a
problem of PHP or a problem of Oracle Client on Solaris (and to help
*yourself* this way).
Reconfirming and re-re-confirming doesn't add any value, believe me.
------------------------------------------------------------------------
[2005-11-13 21:32:32] robertg2 at hope dot ac dot uk
Ahh Tony. Last time I touched C was in 1997... there's no debugger
installed... space on /usr/local is severely limited... this PHP
project has got to be finished by Wednesday... and if anything breaks
again tonight it'll be my head on a stick on Monday morning.
That is, I'd love to help right now but am not able to.
Have reconfirmed the behaviour again. Also, thought this snippet might
be of some use:
<?php
$conn = oci_connect("user", "pw", "db");
echo oci_close($conn);
?>
oci_close($conn) returns 1 and 'netstat -an | grep 1521.*ESTABLISHED |
wc -l' does NOT increment. That is, if oci_close is called the
connection closes, but if it doesn't it stays open forever.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35205
--
Edit this bug report at http://bugs.php.net/?id=35205&edit=1
