ID: 35205
User updated by: robertg2 at hope dot ac dot uk
Reported By: robertg2 at hope dot ac dot uk
Status: Assigned
Bug Type: OCI8 related
Operating System: Solaris 8
PHP Version: 5.0.5
Assigned To: tony2001
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2005-11-13 20:23:03] [EMAIL PROTECTED]
Just to be sure:
Do you have a debugger there?
If yes, please check that functions "php_oci_connection_close" and
"OCIServerDetach" are being called (just set a breakpoint there),
'cause I'm absolutely sure I can't reproduce it on Linux.
Thanks.
------------------------------------------------------------------------
[2005-11-13 18:36:29] [EMAIL PROTECTED]
I'll check it out.
------------------------------------------------------------------------
[2005-11-13 17:25:46] robertg2 at hope dot ac dot uk
Would the fact that it's being run with Apache2 using a threaded MPM
have anything to do with it?
------------------------------------------------------------------------
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
