Bug #70167 [NEW]: Cannot execute queries while other unbuffered queries are active

From: hiren at aspl dot in Operating system: Linux PHP version: Irrelevant Package: PDO MySQL Bug Type: Bug Bug description:Cannot execute queries while other unbuffered queries are active 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 bug report at https://bugs.php.net/bug.php?id=70167&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=70167&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=70167&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=70167&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=70167&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=70167&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=70167&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=70167&r=needscript Try newer version: https://bugs.php.net/fix.php?id=70167&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=70167&r=support Expected behavior: https://bugs.php.net/fix.php?id=70167&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=70167&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=70167&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=70167&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=70167&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=70167&r=dst IIS Stability: https://bugs.php.net/fix.php?id=70167&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=70167&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=70167&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=70167&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=70167&r=mysqlcfg