Bug #12518: ocifreestatment doesn't free the Oracle cursor and so you run out of cursors
| From: | derek at innovyx dot com | Date: | Wed, 01 Aug 2001 17:20:01 +0000 |
| Subject: | Bug #12518: ocifreestatment doesn't free the Oracle cursor and so you run out of cursors | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-61767@lists.php.net to get a copy of this message | ||
From: derek@innovyx.com
Operating system: Linux
PHP version: 4.0.6
PHP Bug Type: OCI8 related
Bug description: ocifreestatment doesn't free the Oracle cursor and so you run out of cursors
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 bug report at: http://bugs.php.net/?id=12518&edit=1