#44206 [Opn->Csd]: Cursor leak with REF CURSORS
| From: | sixd@php.net | Date: | Tue, 26 Feb 2008 00:24:19 +0000 |
| Subject: | #44206 [Opn->Csd]: Cursor leak with REF CURSORS | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-122704@lists.php.net to get a copy of this message | ||
ID: 44206
Updated by: sixd@php.net
Reported By: christopher dot jones at oracle dot com
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: n/a
PHP Version: 5.2.5
New Comment:
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
+------------------------------
| Fix has been merged to 5.2.6, 5.3 and 6.
| Thanks go to Haneef.
+------------------------------
Previous Comments:
------------------------------------------------------------------------
[2008-02-21 19:29:30] christopher dot jones at oracle dot com
Description:
------------
When more than one REF CURSOR is returned in a query, ORA-1000 occurs
after some iterations.
Haneef investigated and says:
"The refcount of the parent statement is incremented by the ref
cursors in php_oci_define_callback and is not decremented. The
incrementing is necessary as the parent statement needs to be around
while fetching the data from the ref cursor. The fix is to decrement
the refcount of the parent statement before ref cursor is freed."
The fix is being tested.
Reproduce code:
---------------
<?php
$c = oci_connect('hr', 'hrpwd', '//localhost/XE');
for ($x = 0; $x < 400; $x++) {
// more than one CURSOR column causes the problem.
$sql = "select cursor(select $x from dual) a,
cursor(select $x from dual) b
from dual";
$sth = oci_parse($c, $sql);
$r = oci_execute($sth);
if (!$r) {
echo "Exiting $x\n"; exit;
}
while ($row = oci_fetch_array($sth, OCI_ASSOC)) {
if ($row) {
foreach ($row as $k => $v) {
if (is_resource($v) &&
get_resource_type($v) == "oci8 statement") {
oci_execute($v);
oci_fetch_all($v, $row[$k], 0, -1, OCI_ASSOC);
oci_free_statement($v);
}
}
}
echo $x, "\n";
}
oci_free_statement($sth);
}
print "Completed $x\n";
oci_close($c);
?>
Expected result:
----------------
...
398
399
Completed 400
Actual result:
--------------
...
295
296
PHP Warning: oci_execute(): ORA-00604: error occurred at recursive SQL
level 1
ORA-01000: maximum open cursors exceeded in test.php on line 10
Exiting 297
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=44206&edit=1