|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #33310 PDO/MySQL Driver takes MySQL in infinitive loop
Submitted: 2005-06-11 14:25 UTC Modified: 2005-06-11 17:57 UTC
From: martin dot stricker at rz dot hu-berlin dot de Assigned:
Status: Closed Package: PDO related
PHP Version: 5CVS-2005-06-11 (dev) OS: OS X 10.4.1
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
5 - 5 = ?
Subscribe to this entry?

 [2005-06-11 14:25 UTC] martin dot stricker at rz dot hu-berlin dot de
This bug concerns 5.1beta1 / Apache 1.3 / MySQL 4.0.12 
When using the MySQL-Driver for a new PDO-Object, the webserver (Apache 1.3) stalls. The MySQL-Log:
4 Query       SET AUTOCOMMIT=1
and then in an infinite loop:
		      4 Query       ROLLBACK
		      4 Query       ROLLBACK
the MySQL-log filled quickly with that last line (about 12MB in 30 seconds). Server had to be killed.
Additionally, phpinfo() tells: "PDO Driver for MySQL 3.x Client Libraries", instead of expected 4.x

Reproduce code:
$dsn = "mysql:host=localhost;dbname=xxxx";
$user = "xxxx";
$pass = "xxxx";

try {
	$p =& new PDO($dsn,$user,$pass);
}  catch(PDOException $e) {
	echo $e->getMessage() . "\n";

Expected result:
PDO-Connection to MySQL

Actual result:
See above.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2005-06-11 16:17 UTC]
Please try using this CVS snapshot:
For Windows:

This was fixed in CVS last night; try a snapshot.
 [2005-06-11 17:11 UTC] martin dot stricker at rz dot hu-berlin dot de
Yes, I can confirm this fix for OS X 10.4.1 with snapshot 20050611-1230
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Thu Oct 28 12:03:36 2021 UTC