ID: 37605
Updated by: [EMAIL PROTECTED]
Reported By: randall dot carlson at navy dot mil
-Status: Open
+Status: Feedback
Bug Type: PDO related
Operating System: REL 4
PHP Version: 5.1.4
New Comment:
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
Previous Comments:
------------------------------------------------------------------------
[2006-05-30 11:36:42] randall dot carlson at navy dot mil
My code is within a portal application so, your test is slightly
different than mine. Again, as of PHP 5.1.2, the portal application
and my code works just fine. It was only when PHP 5.1.4 was built that
this issue appeared. Now as I monitor the mysql logs, I have discovered
that when it hangs, the stored procedure calls appear to be executing
twice (while one call was issued).
------------------------------------------------------------------------
[2006-05-29 11:10:03] [EMAIL PROTECTED]
Works perfectly fine here.
But doesn't output any results, of course, since there is no "dummy"
table with "dummy" field.
------------------------------------------------------------------------
[2006-05-26 17:09:43] randall dot carlson at navy dot mil
Description:
------------
It appears the PDO execute is hanging when a MySQL stored procedure is
called. The same code works fine on PHP 5.1.2 & MySQL 4.0.21. Once we
upgraded to 5.1.4, the problem began. It looks as if the call is being
executed a couple of times in the MySQL queries.log. Our application
code has many such calls and after attempting to execute each one the
browser eventually timesout.
When I subtitute the SQL statment in the prepare, it comes back fine.
Reproduce code:
---------------
create procedure pdo_test() begin select dummy from dummy; end;
$pdo = new PDO("mysql:host=localhost;dbname=x","x","x");
$stmt = $pdo->prepare("call pdo_test()"/*"select dummy from
dummy;"*/);
$stmt->execute();
echo "<B>outputting...</B><BR>";
while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
echo "output: ".$rs->dummy."<BR>";
}
echo "<BR><B>".date("r")."</B>";
Expected result:
----------------
should get
outputting...
output: 1
Fri, 26 May 2006 13:02:17 -0400
Actual result:
--------------
timeout
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37605&edit=1
