#18933 [Opn->Csd]: MSSQL issues under stress

ID: 18933 Updated by: kimihia@php.net Reported By: grangeway@hotmail.com -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: win2k PHP Version: 4.2.2 New Comment: #1 = Not PHP developer issue Others = "threadsafe" issues Previous Comments: ------------------------------------------------------------------------ [2002-11-30 20:41:08] mail-php.net@kimihia.org.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-08-15 20:43:32] grangeway@hotmail.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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18933&edit=1