ID: 30127 Comment by: terry dot greenlaw at logicalshift dot com Reported By: andreys at uniqinfo dot ru Status: No Feedback Bug Type: OCI8 related Operating System: Windows 2000 SP4 PHP Version: 5.0.1 New Comment:
The current code is returning cached connections that are no longer valid. If the oracle instance is bounced without restarting Apache, the cached connections will no longer function (they will return ORA-24237), but they are still being returned to oci_connect (and oci_new_connect). The connection either needs to be tested for "liveness" before being returned, or closed properly. They really should be closed instead of cached (unless using pconnect). We're going to have to switch to CLI mode on our production systems until this is fixed. Previous Comments: ------------------------------------------------------------------------ [2005-04-30 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-04-22 13:10:12] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip ------------------------------------------------------------------------ [2004-10-03 15:45:28] cdcampos at netcabo dot pt I have this behaviour with the following scenario: Oracle 8i, server and client 8.1.7.4 Apache 1.3.31 Windows 2000 SP4 PHP 5.0.1 ------------------------------------------------------------------------ [2004-09-17 16:56:49] [EMAIL PROTECTED] There are no connections/disconnections between two different requests served by the same apache child. PHP's OCI8 module doesn't close connection even with ocilogoff/oci_close because of performance (and other) reasons and leaves this responsibility to the Oracle server. I.e. even "usual" connections behave as "persistent" ones. So, you aren't able to reproduce it with CLI? Or Apache1? What exactly did you try? ------------------------------------------------------------------------ [2004-09-17 16:39:50] andreys at uniqinfo dot ru I was not capable to reproduce this mistake. The matter is that the mistake arises spontaneously! The system can work long enough without occurrence of a mistake. For this time occurs thousand connections and disconnections. ------------------------------------------------------------------------ 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/30127 -- Edit this bug report at http://bugs.php.net/?id=30127&edit=1
