php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #18933 MSSQL issues under stress
Submitted: 2002-08-15 20:43 UTC Modified: 2002-11-30 20:44 UTC
Votes:4
Avg. Score:5.0 ± 0.0
Reproduced:3 of 3 (100.0%)
Same Version:3 (100.0%)
Same OS:2 (66.7%)
From: grangeway at hotmail dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.2.2 OS: win2k
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: grangeway at hotmail dot com
New email:
PHP Version: OS:

 

 [2002-08-15 20:43 UTC] grangeway at hotmail dot com
The MSSQL extension seems to have a few issues under heavy stress. Running a similar test with a mysql server produces no errors:

<?
$link = mssql_connect("127.0.0.1","1","1");
mssql_select_db("test");
$bit_result = mssql_query('SELECT testbitmoo FROM testbit');
$bit_row = mssql_fetch_array($bit_result);
print $bit_row['testbitmoo'];
mssql_close ($link);
?>

Running the above test script produces the following error log entries:
1. MS SQL:  Unable to connect to server:  127.0.0.1 
--> mysql doesn't fail taking new connections, but that error could be a server config setting.

2.
Corrupt Log file Entries e.g. : 

ndex.php on line 3
2
ine 8
tdocs\php\index.php on line 8


3. Failure connecting to server "null":
MS SQL:  Unable to connect to server:  (null)
(should be 127.0.0.1)

4. Attempting to connect as a null user:
MS SQL message:  Login failed for user '(null)'.
(should be "1")
Paul

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-11-30 20:41 UTC] mail-php dot net at kimihia dot org dot nz
Looks like two separate bugs.

#1 - this would be a problem with your MS SQL server settings. Not a PHP issue.

#2, #3, #4 - are you running as an ISAPI or CGI? There are issues with PHP ISAPI under stress.
 [2002-11-30 20:44 UTC] kimihia@php.net
#1 = Not PHP developer issue

Others = "threadsafe" issues
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Fri May 09 07:01:28 2025 UTC