ID: 42496 Comment by: br at absb dot de Reported By: iddekingej at lycos dot com Status: Open Bug Type: OCI8 related Operating System: win 2000 PHP Version: 5.2.4 New Comment:
We can reproduce the problem with OCI8 versions before 1.2.4: Version 1.2.3, $Revision: 1.269.2.16.2.32 $ Previous Comments: ------------------------------------------------------------------------ [2007-11-09 03:21:13] martin at catalyst dot net dot nz > Does setting oci8.statement_cache_size = 0 change the behavior? It does not in our tests, unfortunately. ------------------------------------------------------------------------ [2007-11-09 01:52:04] [EMAIL PROTECTED] Does setting oci8.statement_cache_size = 0 change the behavior? ------------------------------------------------------------------------ [2007-11-08 23:52:44] martin at catalyst dot net dot nz This Moodle bugreport is related: http://tracker.moodle.org/browse/MDL-11429 Note that under moodle (using AdoDB) we are seeing the problem as soon as the resultset contains at least one LOB. If the table has LOBs but the resultset is empty, no cursors are leaked. ------------------------------------------------------------------------ [2007-11-08 23:38:57] martin at catalyst dot net dot nz These are the revisions as reported in phpinfo() for the versions I've tested: grep -r Revision oci8-1.*/oci8.c oci8-1.1.1/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.274 $"); oci8-1.2.3/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.29 $"); oci8-1.2.4/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.38 $"); oci8-1.3.0/oci8.c: php_info_print_table_row(2, "Revision", "$Revision: 1.269.2.16.2.38.4.1 $"); ------------------------------------------------------------------------ [2007-11-08 23:34:29] martin at catalyst dot net dot nz Narrowed down the problem to the OCI8 driver, which is versioned separately from PHP. After a bit of testing, the problem appeared in v1.2.4 of OCI8, which got included in PHP v5.2.3 OCI8 v1.2.3 does not exhibit the problem. vOCI8 1.3.0 Beta (as of today) still exhibits the problem. I've reported it on the bugtracker here http://pecl.php.net/bugs/bug.php?id=12407 linking back to this bug. The different versions of the OCI8 driver are downloadable from http://pecl.php.net/package/oci8 -- HTH! ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/42496 -- Edit this bug report at http://bugs.php.net/?id=42496&edit=1