From: i65 at ornl dot gov Operating system: Suse Linux 9.3 (x86-64) PHP version: 5.2.2 PHP Bug Type: Reproducible crash Bug description: Fatal error - like bug 39640
Description: ------------ Hello, we built latest 5.2.2 on May 6, 2007 with Oracle 10 g R1 client on SuSE Linux 9.3 (x86-64) platform. We get this error now on large Oracle tables (> 90,000 rows). Fatal error: Allowed memory size of 16777216 bytes exhausted at /usr/local/php-5.2.2/ext/oci8/oci8_interface.c:1428 (tried to allocate 24 bytes) Bug 39640 says closed and fixed, but we get it for oci8, installed yesterday from latest snapshot. Reproduce code: --------------- php build info - './configure' '--prefix=/usr/local' '--with-apxs2=/usr/sbin/apxs2' '--with-oci8=/opt/oracle/product/10g1' '--with-mysql=/usr' '--with-zlib' '--enable-debug' '--enable-sigchild' We dropped back to 4.4.7 and error is gone. Statements that generated this error: $cstring = "(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = host.machine (PORT = 1521))(CONNECT_DATA =(SID = DB)))"; $conn = @OCIlogon("$username","$password", $cstring); $stmt="select $select_fields from $table_name order by $sort_field $sort_direction"; $verify=ociparse($conn, $stmt); ociexecute($verify) or die ("SQL execution has failed. Failed statement =$stmt"); $nrows = OCIFetchStatement($verify,$results); Expected result: ---------------- A table of output. Actual result: -------------- Fatal error: Allowed memory size of 16777216 bytes exhausted at /usr/local/php-5.2.2/ext/oci8/oci8_interface.c:1428 (tried to allocate 24 bytes) I do not have any backtrace info recorded. Any help would be appreciated. Thanks, Leslie Galloway [EMAIL PROTECTED] -- Edit bug report at http://bugs.php.net/?id=41320&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41320&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41320&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41320&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41320&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41320&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41320&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41320&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41320&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41320&r=support Expected behavior: http://bugs.php.net/fix.php?id=41320&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41320&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41320&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41320&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41320&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41320&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41320&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41320&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41320&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41320&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41320&r=mysqlcfg