Edit report at https://bugs.php.net/bug.php?id=41997&edit=1
ID: 41997
Updated by: s...@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] u...@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] u...@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] u...@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
