#50820 [Opn->Csd]: mysqli Active Links memory leak

ID: 50820 Updated by: jani@php.net Reported By: mat999 at gmail dot com -Status: Open +Status: Closed Bug Type: MySQLi related Operating System: Debian Lenny / Linux PHP Version: 5.3.1 New Comment: Can not reproduce using latest SVN, considered closed. Previous Comments: ------------------------------------------------------------------------ [2010-01-24 09:13:02] mat999 at gmail dot com Sorry I cant compile a development snapshot on this production machine. The problem is existing on it, most likely due to fastcgi im am guessing. Should be easy to reproduce. Heres a screenshot of the phpinfo below after 4 hours, 1540 active links which is 20 times my mysql max_connections limit, and 100 times my php children amount. http://im4ge.info/show.php/128663_im4ge.png.html ------------------------------------------------------------------------ [2010-01-22 09:00:31] jani@php.net Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2010-01-22 07:05:46] mat999 at gmail dot com Description: ------------ System - mod_fastcgi. 1 process x 35 child php threads - PHP 5.3.1 dotdeb package - Mysqlnd Active Links increases throught the running of the server, for one it is greater than the number of threads so there obviously is a leak. PHPInfo: http://thewarezscene.org/phpinfo.php Reproduce code: --------------- <? $db = mysqi_connect(....); echo 'test'; mysqli_close($db); ?> Open script a few thousand times and take a look at phpinfo() Expected result: ---------------- Active Links = 0; Actual result: -------------- Active Links = XXXX; http://thewarezscene.org/phpinfo.php ^ I have to kill all processes every 3 hours to keep the number down and hence the memory usage. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=50820&edit=1