php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #36519 [Fri Feb 24 11:27:49 2006] [notice] child pid 966962 exit signal Abort (6)
Submitted: 2006-02-24 22:47 UTC Modified: 2006-07-17 08:05 UTC
From: sanchezvilledah at missouri dot edu Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 5.1.2 OS: Red Hat 9.0
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sanchezvilledah at missouri dot edu
New email:
PHP Version: OS:

 

 [2006-02-24 22:47 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-02-25 17:15 UTC] 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-26 09:08 UTC] tony2001@php.net
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.
 [2006-03-06 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 04:01:29 2024 UTC