From: sanchezvilledah at missouri dot edu Operating system: Red Hat 9.0 PHP version: 5.1.2 PHP Bug Type: Oracle related Bug description: [Fri Feb 24 11:27:49 2006] [notice] child pid 966962 exit signal Abort (6)
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 bug report at http://bugs.php.net/?id=36519&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36519&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36519&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36519&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36519&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36519&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36519&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36519&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36519&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36519&r=support Expected behavior: http://bugs.php.net/fix.php?id=36519&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36519&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36519&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36519&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36519&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36519&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36519&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36519&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36519&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36519&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36519&r=mysqlcfg
