ID: 39457 Comment by: bugs dot php at david-salisbury dot co dot uk Reported By: josh at mykoala dot com Status: Verified Bug Type: MySQLi related Operating System: OS X 10.4.8 PHP Version: 5.2.0 Assigned To: georg New Comment:
I've experienced this behaviour on the latest PHP5 CVS (built May 8 2007 22:31:22) running in Apache 2.0.59 as mod_php5. Further reproduce code if necessary: <?php $m = new mysqli(); $m->init(); $m->real_connect('localhost', 'root', 'pass', 'dbname'); $m->real_connect('localhost', 'root', 'pass', 'dbname'); $m->real_connect('localhost', 'root', 'pass', 'dbname'); ?> Previous Comments: ------------------------------------------------------------------------ [2006-11-10 12:00:27] josh at mykoala dot com Description: ------------ After invoking multiple identical connect() calls to a MySQLi object (after mysqli_init), only one is closed via close() or script termination. Reproduce code: --------------- # only when invoked through apache $db = mysqli_init(); $db->connect(null, 'root'); $db->connect(null, 'root'); $db->close(); Expected result: ---------------- Just like when using procedural MySQLi functions (or via mysql_* funcs), multiple connect() calls will not result in rogue db connections. Actual result: -------------- Checking the MySQL process list after each execution shows a rogue connection, which goes on until you reach max connections. This only happens when using OO style. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39457&edit=1