Bug #16502: OCIPLogon does not reconnect to restarted Database

From: bmironov@jonview.com Operating system: RedHat 7.2 PHP version: 4.1.2 PHP Bug Type: OCI8 related Bug description: OCIPLogon does not reconnect to restarted Database Hello, I have an issue between PHP and Oracle. As soon as I have to restart database I have to do same for Apache. If I will not do that my session will retrieve error message about "end-of-file coonection". I agree that some of child processes in Apache can be in this status. But I guess, that it is possible to track that OCIPLogon tries to connect to DB through dead connection. That can trigger whole "connection process" to run again. It is better than wait for administrator to restart whole web server. I prefer OCIPLogon for small SELECT's because of performance issue. I tried to solve this issue with apache_child_terminate() but received message that it is disabled somehow (I even have no idea how to enable it) My environment is: RedHat 6.1 / 7.2 Apache 1.3.23 PHP 4.1.2 (--with-oci8) Oracle 8.1.5 client remote Oracle7 and Oracle8.1.5 databases Thanks for any advise, Boris bmironov@jonview.com -- Edit bug report at http://bugs.php.net/?id=16502&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16502&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16502&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16502&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16502&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16502&r=support Expected behavior: http://bugs.php.net/fix.php?id=16502&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16502&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16502&r=submittedtwice