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

ID: 37594 User updated by: mzamora at meritlending dot com Reported By: mzamora at meritlending dot com -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: windows 2000 sp4 PHP Version: 5.1.4 Assigned To: fmk New Comment: We have been running with php_dblib.dll for a little over a week now and have not noticed any instability issues. Is there any additional information that we can provide to assist in isolating the issue within mssql.dll? We are very interested in getting a stable version of mssql.dll as running with php_dblib.dll has caused a sizable increase in our query times. Previous Comments: ------------------------------------------------------------------------ [2006-05-30 15:44:19] mzamora at meritlending dot com We have the server running with the php_dblib.dll, but because of the long holiday weekend the server has not been under the load level that causes the failure. ------------------------------------------------------------------------ [2006-05-26 06:24:02] derick@php.net Let's leave at feedback until then then. ------------------------------------------------------------------------ [2006-05-26 00:13:40] mzamora at meritlending dot com we are using php5apache2.dll. It will be some time tomorrow before I get a chance to do any testing with php_dblib.dll. ------------------------------------------------------------------------ [2006-05-25 23:54:13] fmk@php.net 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. ------------------------------------------------------------------------ [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