#33310 [NEW]: PDO/MySQL Driver takes MySQL in infinitive loop

From: Date: Sat, 11 Jun 2005 12:25:14 +0000
Subject: #33310 [NEW]: PDO/MySQL Driver takes MySQL in infinitive loop
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-80145@lists.php.net to get a copy of this message
From: martin dot stricker at rz dot hu-berlin dot de Operating system: OS X 10.4.1 PHP version: 5CVS-2005-06-11 (dev) PHP Bug Type: PDO related Bug description: PDO/MySQL Driver takes MySQL in infinitive loop 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. -- Edit bug report at http://bugs.php.net/?id=33310&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33310&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33310&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33310&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33310&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33310&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33310&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33310&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33310&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33310&r=support Expected behavior: http://bugs.php.net/fix.php?id=33310&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33310&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33310&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33310&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33310&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33310&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33310&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33310&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33310&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33310&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33310&r=mysqlcfg

« previous php.bugs (#80145) next »