php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #46364 PDO Procedure Issue
Submitted: 2008-10-22 11:34 UTC Modified: 2009-02-21 01:00 UTC
From: usha dot adhuri at gmail dot com Assigned:
Status: No Feedback Package: PDO related
PHP Version: 5.2.6 OS: Windows
Private report: No CVE-ID: None
View Developer Edit
 [2008-10-22 11:34 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-02-13 23:42 UTC] felipe@php.net 
Please try using this CVS snapshot:

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

  http://windows.php.net/snapshots/
 [2009-02-21 01:00 UTC] 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".
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri Aug 01 15:00:03 2025 UTC