ID: 28924
User updated by: ben at grinvalds dot net
-Summary: reference memory error running script
Reported By: ben at grinvalds dot net
Status: Open
Bug Type: OCI8 related
Operating System: Windows XP
PHP Version: 5.0.0RC3
New Comment:
I've been doing some more investigation. When I changed my php
configuration in the Apache http.conf from sapi to cgi, the problem
goes away. Looks like the problem is related to the sapi module.
Previous Comments:
------------------------------------------------------------------------
[2004-06-29 16:11:23] ben at grinvalds dot net
I have included a script which causes a reference memory error to occur
more frequently. If you run this script three or four times back to
back you will get the error.
Ben
<?php
class Test {
var $_results;
var $_ncount;
function display() {
$conn = oci_connect("scott", "tiger", "host_name");
$stmt = oci_parse($conn, "select ENAME from emp");
oci_execute($stmt);
$this->_ncount = oci_fetch_all($stmt, $this->_results);
oci_free_statement($stmt);
oci_close($conn);
for ($i = 0; $i < $this->_ncount; $i++) {
echo $this->_results["ENAME"][$i];
}}}
$test = new Test();
$test->display();
?>
------------------------------------------------------------------------
[2004-06-25 16:56:39] ben at grinvalds dot net
Description:
------------
I have been testing my code in PHP5 and have been getting regular
Apache.exe Application errors.
When I run the script below a few times, I will consistantly get
reference memory errors. Even after I re-boot my system. My
application makes many calls to an Oracle database. I'm not sure if
this is specifically related to OCI or if it is a more general PHP
memory issue.
Environment:
OS: Windows XP Professional with SP1
Server: Apache 1.3.31 (Win32)
DB: Oracle 8.4.7
Reproduce code:
---------------
<?php
$conn = oci_connect("scott", "tiger", "your_host_name");
for ($p=0; $p <= 500; $p++) {
$stmt = oci_parse($conn, "select ENAME from emp");
oci_execute($stmt);
$i = 0;
while (oci_fetch($stmt)) {
$i++;
$name = oci_result($stmt, "ENAME");
echo $name . "<br>";
}
echo "<br>";
echo $i . " Records Selected. Count:" . $p;
echo "<br><br>";
}
oci_free_statement($stmt);
oci_close($conn);
?>
Expected result:
----------------
I should be able to run this without encountering any Apache.exe
Application error.
Actual result:
--------------
The error message that I am receiving is: The instruction at
"0x6042fdc2" refereced memory at "0x00000010". The memory could not be
"read".
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=28924&edit=1
