php.net |  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: martin dot stricker at rz dot hu-berlin dot de
New email:
PHP Version: OS:

 

 [2005-06-11 14:25 UTC] martin dot stricker at rz dot hu-berlin dot de
Description:
------------
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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-06-11 16:17 UTC] wez@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

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-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 11:01:30 2024 UTC