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:
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. Previous Comments: ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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