php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37594 mssql fails under load
Submitted: 2006-05-25 23:42 UTC Modified: 2006-06-13 01:00 UTC
From: mzamora at meritlending dot com Assigned: fmk (profile)
Status: No Feedback Package: MSSQL related
PHP Version: 5.1.4 OS: windows 2000 sp4
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2006-05-25 23:42 UTC] 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



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-05-25 23:54 UTC] 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-26 00:13 UTC] 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-26 06:24 UTC] derick@php.net
Let's leave at feedback until then then.
 [2006-05-30 15:44 UTC] 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-06-05 22:34 UTC] mzamora at meritlending dot com
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.
 [2006-06-05 22:56 UTC] fmk@php.net
Both the DBLIB and MSSQL versions of this extension uses the exact same C code. The difference between the two versions is the library used. The Library supplied by Microsoft and used in php_mssql.dll is not thread safe. Microsoft has not updated this library since SQL Server 6.5.

The extension named php_dblib.dll uses FreeTDS and there are ways to improve performance as this is an open source project.

In both cases it's the same server the performs the queries and it's the same C code that handles the output from the library, so the only differences I see is the transport protocols. If you have some examples of quieries that acts slower I'll take a look at those and see if tehre is anything that can be done.
 [2006-06-13 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Apr 14 09:01:29 2024 UTC