#35205 [Asn]: oci_connect is not closing opened connections after script execution
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: Tony, Unfortunately it doesn't look like it picked up the instant client in compilation as the new style \\HOSTNAME\DBNAME referencing feature doesn't work. So still it's unclear whether compiling with the instant client would reproduce the problem. Will try again tonight. Previous Comments: [2005-11-20 01:55:28] robertg2 at hope dot ac dot uk Sorry for the delay in testing. The connection is closed off correctly when compiled against InstantClient 10. [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. 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=35205edit=1
#35205 [Asn]: oci_connect is not closing opened connections after script execution
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: oh and... as for the comment I made at 1:55am... that was a mistake. I hadn't taken the oci_close statement out of the code. Sorry :( Previous Comments: [2005-11-20 13:15:55] robertg2 at hope dot ac dot uk Tony, Unfortunately it doesn't look like it picked up the instant client in compilation as the new style \\HOSTNAME\DBNAME referencing feature doesn't work. So still it's unclear whether compiling with the instant client would reproduce the problem. Will try again tonight. [2005-11-20 01:55:28] robertg2 at hope dot ac dot uk Sorry for the delay in testing. The connection is closed off correctly when compiled against InstantClient 10. [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. 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=35205edit=1
#35205 [Asn]: oci_connect is not closing opened connections after script execution
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:
Okay, for real this time:
Using the 32-bit instantclient 10 doesn't seem to have an effect on the
behaviour in question.
?
oci_connect('user', 'pw', '//HOST/DBNAME');
?
After browsing to a script such as this via the web, the connection to
the database remains.
Previous Comments:
[2005-11-20 13:18:40] robertg2 at hope dot ac dot uk
oh and... as for the comment I made at 1:55am... that was a mistake. I
hadn't taken the oci_close statement out of the code.
Sorry :(
[2005-11-20 13:15:55] robertg2 at hope dot ac dot uk
Tony,
Unfortunately it doesn't look like it picked up the instant client in
compilation as the new style \\HOSTNAME\DBNAME referencing feature
doesn't work. So still it's unclear whether compiling with the instant
client would reproduce the problem.
Will try again tonight.
[2005-11-20 01:55:28] robertg2 at hope dot ac dot uk
Sorry for the delay in testing.
The connection is closed off correctly when compiled against
InstantClient 10.
[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.
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=35205edit=1
#35205 [Asn]: oci_connect is not closing opened connections after script execution
ID: 35205 Updated by: [EMAIL PROTECTED] 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: Just for the record: I can't reproduce on Linux and on Solaris with Apache2/prefork. Previous Comments: [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. [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. 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=35205edit=1
#35205 [Asn]: oci_connect is not closing opened connections after script execution
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=35205edit=1
