#35205 [Fbk->Opn]: oci_connect is not closing opened connections after script execution

ID: 35205 User updated by: robertg2 at hope dot ac dot uk Reported By: robertg2 at hope dot ac dot uk -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.0.5 New Comment: Hi Wez, It's definitely 1.1.1 - unless I've gone totally delirious. phpinfo() reports oci8 '$Revision: 1.274 $' (??), and lists the new oci8 directives and default values. If you'd like the URL to the phpinfo() page, give me a shout. Thanks, Gareth Previous Comments: ------------------------------------------------------------------------ [2005-11-13 13:55:43] wez@php.net That doesn't sound right (hence your bug report); can you verify that you really are using the latest PECL OCI8 extension? Check your phpinfo() output. ------------------------------------------------------------------------ [2005-11-13 13:43:51] robertg2 at hope dot ac dot uk Hi there, It's now the morning, and I've verified this behaviour. <?php $conn = oci_connect("user", "pw", "db"); ?> 'netstat -an | grep 1521.*ESTABLISHED | wc -l' reports an incremented number of connections after script execution ends. ------------------------------------------------------------------------ [2005-11-13 01:56:52] robertg2 at hope dot ac dot uk 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 this bug report at http://bugs.php.net/?id=35205&edit=1