#26829 [NEW]: Killed Oracle Sessions openned with OCIPLogon()

From: david dot gaia dot kano at dartmouth dot edu Operating system: Compaq Unix PHP version: 4.3.4 PHP Bug Type: OCI8 related Bug description: Killed Oracle Sessions openned with OCIPLogon() Description: ------------ Here at Dartmouth our DBA team has a policy of killing any Oracle session that has been connected for longer than 24 hours. Hence the persistant connections created by the PHP OCIPLogon() call get killed once a day. We don't really want to restart our apache server once a day, so it would be great if OCIPLogon() would check to see that a previously created persistant connection is still good somehow and if not, create a new connection. I noticed quite a few bugs along these lines, but they have all been closed. I don't know if that is because this bug was fixed or because the submitters have continued to restart their servers after every database restart or killed connection. If this is not going to be fixed, I guess we would have to write our own application level code to check the connections from ociplogon() and if it is bad, use OCILogon() instead for that request and issue a apache_child_terminate() call so that eventually all the children with bad oracle sessions would be restarted... Reproduce code: --------------- $con = OCIPLogon("user", "password", "tns_db_name"); // at this point all looks good still... $con != false // but if this session was killed then any use of $con // results in one error or another. -- Edit bug report at http://bugs.php.net/?id=26829&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26829&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26829&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26829&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26829&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26829&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=26829&r=needscript Try newer version: http://bugs.php.net/fix.php?id=26829&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26829&r=support Expected behavior: http://bugs.php.net/fix.php?id=26829&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26829&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26829&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26829&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26829&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26829&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26829&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26829&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26829&r=float