#41997 [Fbk]: pdo_mysql: stored procedure call returning single rowset blocks future queries

From: Date: Tue, 22 Jul 2008 14:40:38 +0000
Subject: #41997 [Fbk]: pdo_mysql: stored procedure call returning single rowset blocks future queries
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-127127@lists.php.net to get a copy of this message 
 ID:               41997
 Updated by:       uw@php.net
 Reported By:      nitel_defect at yahoo dot com
 Status:           Feedback
 Bug Type:         PDO related
 Operating System: Windows XP SP2
 PHP Version:      5.2.3
 Assigned To:      johannes
 New Comment:

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)


Previous Comments:
------------------------------------------------------------------------

[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

------------------------------------------------------------------------

[2008-01-22 13:28:59] felipe@php.net

Reclassified: mysql -> pdo

------------------------------------------------------------------------

[2007-08-21 00:08:52] marpiotr at gmail dot com

i seem to have the same problem on 5.1.6 on Fedora Core 6

------------------------------------------------------------------------

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
    http://bugs.php.net/41997

-- 
Edit this bug report at http://bugs.php.net/?id=41997&edit=1

Thread (21 messages)

« previous php.bugs (#127127) next »