ID: 35217 Updated by: [EMAIL PROTECTED] -Summary: mssql.max_procs strange behavoiur Reported By: vovik at getart dot ru -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: RHEL 4 PHP Version: 4.4.1 New Comment:
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 Previous Comments: ------------------------------------------------------------------------ [2005-11-14 16:34:47] vovik at getart dot ru Description: ------------ When I try to limit maximum number of MS SQL open connections via php.ini it doesn't work properly. It doesn't work at all. Instead of this, connections actually established, but some error messages (from FreeTDS ?) appeared on every mssql_connect() above mssql.max_procs. I've added sleep() to end of script for checking number of connections on SQL server side and in example above it is 30. Reproduce code: --------------- <?php // mssql.max_procs set to 26 in php.ini $links = array(); for ($k = 0; $k < 30; ++$k) { $link = mssql_connect("mssqlserver", "xxx", "yyy", true); if (!$link) { exit("Connect failed."); } $links[] = $link; } sleep(20); ?> Expected result: ---------------- PHP warning: Too many open links (26) Connect failed. Actual result: -------------- (on stderr) Max connections reached, increase value of TDS_MAX_CONN Max connections reached, increase value of TDS_MAX_CONN Max connections reached, increase value of TDS_MAX_CONN Max connections reached, increase value of TDS_MAX_CONN ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35217&edit=1
