#37605 [Com]: PDO stored procedure prepare call hangs

From: Date: Tue, 25 Jul 2006 15:02:05 +0000
Subject: #37605 [Com]: PDO stored procedure prepare call hangs
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-99869@lists.php.net to get a copy of this message 
 ID:               37605
 Comment by:       laurinkus at gmail dot com
 Reported By:      randall dot carlson at navy dot mil
 Status:           Feedback
 Bug Type:         PDO related
 Operating System: REL 4
 PHP Version:      5.1.4
 New Comment:

Please look at:
http://spekuliantai.no-ip.org/la/php_problems/

I've managed to reproduce problem using these files.


Previous Comments:
------------------------------------------------------------------------

[2006-07-25 13:39:47] tony2001@php.net

We still need a reproduce script.

------------------------------------------------------------------------

[2006-07-25 13:37:27] randall dot carlson at navy dot mil

I've been contacted by another user with the same issue.  Please review
with laurinkus at gmail dot com.

------------------------------------------------------------------------

[2006-07-24 21:33:49] laurinkus at gmail dot com

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.

------------------------------------------------------------------------

[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] tony2001@php.net

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.

------------------------------------------------------------------------

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

Thread (12 messages)

« previous php.bugs (#99869) next »