#30127 [Opn->Fbk]: lost oracle connection. need restart apache.

ID: 30127 Updated by: tony2001@php.net Reported By: andreys at uniqinfo dot ru -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 SP4 PHP Version: 5.0.1 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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] tony2001@php.net 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. ------------------------------------------------------------------------ [2004-09-17 16:27:35] tony2001@php.net I do not propose you to change buggy and poorly tested Apache2 to CLI. I just want to know if you're able to reproduce it with Apache1 and/or CLI. ------------------------------------------------------------------------ [2004-09-17 16:17:37] andreys at uniqinfo dot ru It not an output. We use Apache 2.X because at us dual-processor system. Apache 2.X just for this purpose it is intended. Work through the CLI interface in console will considerably reduce productivity of a server. ------------------------------------------------------------------------ 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