#29902 [NEW]: oci8 doesn't disconnect sessions, overloads oracle server

From: jwoodrich at avaya dot com Operating system: Solaris 7 PHP version: 5.0.1 PHP Bug Type: OCI8 related Bug description: oci8 doesn't disconnect sessions, overloads oracle server Description: ------------ PHP's oci8 opens connections to the database server but does not disconnect. This appears to be done for each instance of apache that uses PHP oci8. Eventually the maximum number of sessions is reached on the database server and no more connections can be made. This has occured on three different Solaris servers (two v7 and one v8) running PHP 5.0.1. After downgrading to PHP 4.3.8 the problem disappeared and connections disappeared from session listing in Oracle as web transactions completed. Config line: ./configure --with-apxs --with-oci8 \ --enable-ftp --with-curl --with-informix \ --with-imap \ --with-ldap --with-gd --with-jpeg- \ --with-pgsql \ --with-libxml-dir \ --prefix \ --with-png-dir --with-zlib --enable-pcntl --disable-debug Oracle Server version: 8.1.7.2 Oracle Client version: 8.1.7 Reproduce code: --------------- Example: $dbh=ocilogon("LOGIN","PASSWORD","DATABASE"); $sth=ociparse($dbh,"select sysdate from dual"); ociexecute($sth); ocifetchinto($sth,&$svret,OCI_ASSOC+OCI_RETURN_NULLS); ocifreestatement($sth); oci_close($dbh); var_dump($svret); Expected result: ---------------- array(1) { ["SYSDATE"]=>string(11) "<<the time>>" } Actual result: -------------- Once the maximum number of sessions is reached this error message is returned: ORA-00604: error occurred at recursive SQL level 1 ORA-00018: maximum number of sessions exceeded -- Edit bug report at http://bugs.php.net/?id=29902&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29902&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=29902&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=29902&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=29902&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29902&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29902&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29902&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29902&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29902&r=support Expected behavior: http://bugs.php.net/fix.php?id=29902&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29902&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29902&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29902&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29902&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29902&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29902&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29902&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29902&r=float