#46364 [Opn->Fbk]: PDO Procedure Issue

From: Date: Fri, 13 Feb 2009 23:42:06 +0000
Subject: #46364 [Opn->Fbk]: PDO Procedure Issue
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-133824@lists.php.net to get a copy of this message 
 ID:               46364
 Updated by:       felipe@php.net
 Reported By:      usha dot adhuri at gmail dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: Windows
 PHP Version:      5.2.6
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/




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

[2008-10-22 11:34:43] usha dot adhuri at gmail dot com

Description:
------------
I am using persistent PDO connetions and I got the error messages

SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other
unbuffered queries are active. Consider using PDOStatement::fetchAll().
Alternatively, if your code is only ever going to run against mysql, you
may enable query buffering by setting the
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

1) I only get the error randomly (approx. every 10th call of the
script)and when there is high load on the server.
2) I get the error in the prepare statement
3) nextRowset and closeCursor does not change anything and sometimes
connetion is lost.

Is there any fix for the problem. 



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


-- 
Edit this bug report at http://bugs.php.net/?id=46364&edit=1

Thread (2 messages)

« previous php.bugs (#133824) next »