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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Sat Apr 20 01:01:28 2024 UTC