ID: 41320
User updated by: i65 at ornl dot gov
Reported By: i65 at ornl dot gov
Status: Bogus
Bug Type: Reproducible crash
Operating System: Suse Linux 9.3 (x86-64)
PHP Version: 5.2.2
New Comment:
Sorry for incorrect language; I'm following 39640 submission. It is
reproducible as every time I query that table, I get that Fatal error.
Querying a smaller table does not give the Fatal error. I am not
hitting memory_limit as 4.4.7 does not have this error with same php.ini
file and configuration.
Thanks
Previous Comments:
------------------------------------------------------------------------
[2007-05-07 20:52:06] [EMAIL PROTECTED]
I don't see any crash here and Fatal error is no crash, but expected
result when your memory_limit is exceeded.
------------------------------------------------------------------------
[2007-05-07 20:42:36] i65 at ornl dot gov
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 this bug report at http://bugs.php.net/?id=41320&edit=1
