#37594 [Opn->Fbk]: mssql fails under load

ID: 37594 Updated by: fmk@php.net Reported By: mzamora at meritlending dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: windows 2000 sp4 PHP Version: 5.1.4 -Assigned To: +Assigned To: fmk New Comment: Are you using CGI or php5apache2.dll? The library used by the mssql extension is not thread safe. You might want to try php_dblib.dll. It's the same mssql_*() functions but it's compiled against FreeTDS. Previous Comments: ------------------------------------------------------------------------ [2006-05-25 23:42:43] mzamora at meritlending dot com Description: ------------ Under heavy load the server responds with the following: "Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: servername" We see the same type issue with the connect function. Our configuration is as follows: OS - Windows 2000 SP4 Apache - 2.0.0.58 PHP - 5.1.4 Changes to the PHP.ini include Enabling the following extensions extension=php_curl.dll extension=php_mime_magic.dll extension=php_mssql.dll extension=php_openssl.dll extension=php_printer.dll All mssql relevant settings have been not been changed from php.ini-dist Please let me know what we can do to help find a resolution to this issue. As a note the issue we are encountering is exactly like the one reported in bug #32854 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37594&edit=1