Bug #70167 [Opn]: Cannot execute queries while other unbuffered queries are active
| From: | hiren at aspl dot in | Date: | Thu, 30 Jul 2015 06:49:49 +0000 |
| Subject: | Bug #70167 [Opn]: Cannot execute queries while other unbuffered queries are active | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-194830@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=70167&edit=1
ID: 70167
User updated by: hiren at aspl dot in
Reported by: hiren at aspl dot in
Summary: Cannot execute queries while other unbuffered
queries are active
Status: Open
Type: Bug
Package: PDO MySQL
Operating System: Linux
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
Below is MySQL version:
mysql Ver 14.14 Distrib 5.5.43, for Linux (x86_64) using readline 5.1
Previous Comments:
------------------------------------------------------------------------
[2015-07-30 06:44:31] hiren at aspl dot in
Description:
------------
Error is:
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.
Environment:
PHP 5.5.25
mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $
PDO (1.0.4dev)
pdo_mysql (1.0.2)
Symfony 1.4
Doctrine 1.2.4
I already tried with setting PDO::MYSQL_ATTR_USE_BUFFERED_QUERY but seems not working and still
facing the error.
It seems to be having some issue with mysqlnd native library.
Apart I made sure that PDO library is using mysqlnd native library and not the other one:
php -r "var_dump(function_exists('mysqli_get_client_stats'));"
bool(true)
Please help.
Many thanks.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=70167&edit=1