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
 [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 10:01:29 2024 UTC