ID: 37605
Comment by: laurinkus at gmail dot com
Reported By: randall dot carlson at navy dot mil
Status: No Feedback
Bug Type: PDO related
Operating System: REL 4
PHP Version: 5.1.4
New Comment:
Facing same problem with 5.1.4 on FreeBSD 5.1 and MySQL 5.1.11. Code
extract below:
function getOMXDailySnapshot($submarkets_id)
{
$db = Zend::registry('db');
$stm = $db->prepare('CALL omx_daily_snapshot(:submarket_id)');
$stm->bindValue('submarket_id',$submarkets_id);
$stm->execute();
$result = $stm->fetchAll();
return $result;
}
It seems to me that it is somehow related to result set length.
Previous Comments:
------------------------------------------------------------------------
[2006-06-28 01:00:02] 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".
------------------------------------------------------------------------
[2006-06-20 14:44:42] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.2-win32-latest.zip
Still can't reproduce.
------------------------------------------------------------------------
[2006-06-05 20:50:26] randall dot carlson at navy dot mil
Well, my problem involves database access with PDO, so I don't know how
to convey the problem without a database. As far as the script itself:
<?php
$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>";
?>
That is all of it, except for the MySQL stored procedure script:
create procedure pdo_test() begin select dummy from dummy; end;
------------------------------------------------------------------------
[2006-05-30 11:42:18] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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).
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37605
--
Edit this bug report at http://bugs.php.net/?id=37605&edit=1
