#36519 [Fbk]: [Fri Feb 24 11:27:49 2006] [notice] child pid 966962 exit signal Abort (6)
| From: | tony2001@php.net | Date: | Sun, 26 Feb 2006 08:08:20 +0000 |
| Subject: | #36519 [Fbk]: [Fri Feb 24 11:27:49 2006] [notice] child pid 966962 exit signal Abort (6) | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-93678@lists.php.net to get a copy of this message | ||
ID: 36519
Updated by: tony2001@php.net
Reported By: sanchezvilledah at missouri dot edu
Status: Feedback
Bug Type: Oracle related
Operating System: Red Hat 9.0
PHP Version: 5.1.2
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5.1-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.1-win32-latest.zip
Try CVS snapshot first.
Previous Comments:
------------------------------------------------------------------------
[2006-02-25 17:15:01] derick@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php
for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php
for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
------------------------------------------------------------------------
[2006-02-24 22:47:30] sanchezvilledah at missouri dot edu
Description:
------------
The script does not process the last records. If I use phpinfo() at the
end of the script it finishes, otherwise the script lost the last 3
rows, and I got in error_log file [Fri Feb 24 11:27:49 2006] [notice]
child pid.
url at
http://btest.rnet.missouri.edu/Roots/Roots_Integration/MicroArray_Info6.php
Reproduce code:
---------------
<?
require_once("connection.php");
require_once("Structure3.php");
/*********************/
/* connect to Oracle */
/*********************/
$conn = db_connect();
if (!$conn)
return "Can not connect to Oracle.";
$FDR_Min = SetFDRMin();
$FDR_Max = SetFDRMax();
$tab_active = "MArray";
PrintHTMLHeader( $tab_active );
DisplaySearchFDR(); # display the box with search
options
print "<table class=\"sort-table\" id=\"table-1\" border=1,
width=\"1250\">";
print "<thead><tr><td title=\"String\">MZ_NAME</td><td
title=\"Number\">FOLD CHANGE</td><td
title=\"Number\">P_VALUE</td><td
title=\"Number\">FDR</td><td title=\"Number\">STD
DEV</td><td
title=\"String\">EXPERIMENT</td></tr></thead>\n";
$query = CreateFDRQuery($FDR_Min, $FDR_Max);
$query = OCIParse($conn, $query);
OCIExecute($query);
print " <tbody>";
while(OCIFetch($query)) {
$GName = OCIResult($query, "MZ_NAME");
$FChange = OCIResult($query, "FOLD_CHANGE");
$PValue = OCIResult($query, "P_VALUE");
$FDR = OCIResult($query, "FDR");
$STD_DEV = OCIResult($query, "STD_DEV");
$Experiment = OCIResult($query, "EXPERIMENT_NAME");
$Exp_ID = SetExperiment($Experiment);
$EXPERIMENTURL =
"http://bioinf2.rnet.missouri.edu/nologin.phtml?location=experiment_edit.phtml?i_e=".$Exp_ID;
$DESCURL =
"/Roots/Roots_Integration/MicroArray_Desc.php?Mz_Name=".$GName;
print "<tr><td><a target=\"_blank\"
href=".$DESCURL.">".$GName."</a></td><td>".$FChange."</td><td>".$PValue."</td><td>".$FDR."</td><td>"
.$STD_DEV."</td><td><a target=\"_blank\"
href=".$EXPERIMENTURL.">".$Experiment."</a></td></tr>\n";
# print "<tr><td><a href=\"MicroArray_Desc.php\"
onclick="MM_openBRWindow(\'.$DESCURL.">".$GName','','width=500,height=400\')."</a></td><td>".$FChange."</td><td>".$PValue."</td><td>".$FDR."</td><td>"
.$STD_DEV."</td><td><a target=\"_blank\"
href=".$EXPERIMENTURL.">".$Experiment."</a></td></tr>\n";
}
print "</tbody>";
print "</table>";
print "<script type=\"text/javascript\">";
print "var st1 = new
SortableTable(document.getElementById(\"table-1\"), [\"String\",
\"Number\", \"Number\", \"Number\", \"Number\",
\"String\"])";
print "</script>\n";
OCIFreeStatement($query);
$query = CreateFDRQuery($FDR_Min, $FDR_Max);
$query = OCIParse($conn, $query);
OCIExecute($query);
OCILogoff($conn);
print phpinfo(32); # if this line is commented the last rows are
not processed
?>
</BODY>
</HTML>
Expected result:
----------------
I expect that the script process all the Fetched records and print
them.
Actual result:
--------------
If I include other sql query and print the results to the screen it
works, however the last rows for the second query are not processed.
It might be something with the buffer.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36519&edit=1