Bug #41997 [NoF->ReO]: pdo_mysql: stored procedure call returning single rowset blocks future queries

Edit report at https://bugs.php.net/bug.php?id=41997&edit=1 ID: 41997 Updated by: stas@php.net Reported by: nitel_defect at yahoo dot com Summary: pdo_mysql: stored procedure call returning single rowset blocks future queries -Status: No Feedback +Status: Re-Opened Type: Bug Package: PDO related -Operating System: Windows XP SP2 +Operating System: * PHP Version: 5.2.3 Assigned To: johannes Block user comment: N Private report: N New Comment: I still see test bug_41997 failing for me on master. Same happens on tracis CI: https://travis-ci.org/php/php-src/builds/10062028 Error message is: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error in /home/smalyshev/php-src/ext/pdo_mysql/tests/bug_41997.php on line 10 Client library version is: pdo_mysql Client API version => mysqlnd 5.0.11-dev - 20120503 - $Id: 40933630edef551dfaca71298a83fad8d03d62d4 $ Previous Comments: ------------------------------------------------------------------------ [2008-07-30 01:00:01] 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". ------------------------------------------------------------------------ [2008-07-22 14:40:38] uw@php.net Please make sure that you try this with PHP 5.3+ and mysqlnd (--with-pdo-mysql=mysqlnd , default). It might not work when using the mysqlclient library (libmysql, --with-pdo-mysql=/path/to/mysql_config) ------------------------------------------------------------------------ [2008-07-22 14:38:17] uw@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.3-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.3-win32-installer-latest.msi ------------------------------------------------------------------------ [2008-05-22 17:32:37] uw@php.net The next PDO_MYSQLND release should fix this ------------------------------------------------------------------------ [2008-01-24 11:46:34] ben at stickyeyes dot com Just to add to this bug, I too experience this problem when trying to execute two stored procedures, one after the other. Unfortunately, the only work around I could get working, was to create a new PDO object for each query (attempting to clone an existing PDO object caused Apache to crash, but thats another bug for another day...) Sucks, but it works. Apache/2.2.4 (Win32) PHP/5.2.3 PDO Driver for MySQL, client library version 5.0.37 MySQL 5.1.22 ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=41997 -- Edit this bug report at https://bugs.php.net/bug.php?id=41997&edit=1