Bug #12518 Updated: ocifreestatment doesn't free the Oracle cursor and so you run out of cursors
| From: | thies@php.net | Date: | Wed, 01 Aug 2001 20:18:03 +0000 |
| Subject: | Bug #12518 Updated: ocifreestatment doesn't free the Oracle cursor and so you run out of cursors | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-61777@lists.php.net to get a copy of this message | ||
ID: 12518
Updated by: thies
Reported By: derek@innovyx.com
Old Status: Open
Status: Feedback
Bug Type: OCI8 related
Operating System: Linux
PHP Version: 4.0.6
New Comment:
what makes you belive it doesn't work?
please send me a short testcase that shows leakage of
resources.
Previous Comments:
------------------------------------------------------------------------
[2001-08-01 13:20:01] derek@innovyx.com
the ocifreestatment function doesn't actually free the Oracle cursor, these are only freed when
the script exits.
While this isn't a problem when using PHP as a web page it is a problem if you have a command
line script that has to perform thousands (or tens of thousands) of queries eventually the
open_cursors limit is exceeded and all further queries fail.
The same appears to be true with connections.
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=12518&edit=1