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
