#16657 [Opn->Fbk]: Persistent connections and high-load problems

ID: 16657 Updated by: iliaa@php.net Reported By: jlvillar1@hotmail.com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-06-01 12:27:44] justin@down.cx I also am experiencing the very same problem. Under high loads, the mssql_pconnect function pools up exactly 25 connections then completely denies any further connections. If the max_persistent variable is higher than 25, mssql_pconnect returns FALSE until Apache is restarted. If it is set lower than 25, it STILL pools 25 connections but will eventually release them (read: it takes a long time). ------------------------------------------------------------------------ [2002-04-17 08:12:49] jlvillar1@hotmail.com Persistent connections (using mssql_pconnect) don't work properly in Php 4.1.2 (under Windows 2000 professional and Apache 1.3.12 server) connecting to a MSSQL 7.0 database of a second machine. High-loaded connections break and the php.ini file is omited when setting the maximun number of persistent connections (mssql.max_persistent variable) regards Jose Luis ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16657&edit=1