From: robertg2 at hope dot ac dot uk Operating system: Solaris 8 PHP version: 5.0.5 PHP Bug Type: OCI8 related Bug description: oci_connect is not closing opened connections after script execution
Description: ------------ Today I've been developing on a web server connecting to a remote Oracle 9i database using the latest 1.1.1 oci8 extension from PECL. Unfortunately, towards the end of the day I started receiving the Oracle error ORA-00020, indicating that the connections from the web server to the database server were not closing automatically at script execution end as I expected. 'netstat -an | grep 1521 | wc -l' on the web server reports 436 which is waaaaaay too high for a Saturday and is not representative of the load we are receiving. I understand that I am able to close the connections explicitly, but I assumed that the connections would themselves be closed automatically at end of script execution? I just installed oci8 1.1.1 yesterday and started developing on it today. Thanks, Gareth Reproduce code: --------------- In theory: <?php oci_connect($user, $password, $db); ?> and refresh a couple of hundred times. Expected result: ---------------- oci_connect($user, $password, $db) to return false with the error reported by oci_error to be ORA-00020 Actual result: -------------- not available -- Edit bug report at http://bugs.php.net/?id=35205&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35205&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35205&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35205&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35205&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35205&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35205&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35205&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35205&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35205&r=support Expected behavior: http://bugs.php.net/fix.php?id=35205&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35205&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35205&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35205&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35205&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35205&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35205&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35205&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35205&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35205&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35205&r=mysqlcfg
