#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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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=37594edit=1
#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 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. Previous Comments: [2006-05-26 06:24:02] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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=37594edit=1
#37594 [NEW]: mssql fails under load
From: mzamora at meritlending dot com Operating system: windows 2000 sp4 PHP version: 5.1.4 PHP Bug Type: MSSQL related Bug description: mssql fails under load 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 bug report at http://bugs.php.net/?id=37594edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37594r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=37594r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37594r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37594r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37594r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37594r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=37594r=needscript Try newer version:http://bugs.php.net/fix.php?id=37594r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37594r=support Expected behavior:http://bugs.php.net/fix.php?id=37594r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37594r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37594r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37594r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37594r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37594r=dst IIS Stability:http://bugs.php.net/fix.php?id=37594r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37594r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37594r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37594r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=37594r=mysqlcfg
#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 are using php5apache2.dll. It will be some time tomorrow before I get a chance to do any testing with php_dblib.dll. Previous Comments: [2006-05-25 23:54:13] [EMAIL PROTECTED] 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=37594edit=1