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

From: Date: Tue, 25 Jul 2006 15:42:44 +0000
Subject: #37605 [Com]: PDO stored procedure prepare call hangs
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-99871@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:

In this case PHP doesn't crash. It's only hanging when a MySQL stored
procedure is called.

Please look at URL provided above again, I've added CLI version of same
script.


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

[2006-07-25 15:18:03] tony2001@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-07-25 15:02:04] laurinkus at gmail dot com

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

I've managed to reproduce problem using these files.

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

[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.

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

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 (#99871) next »