Randomly get timeout on SqlClient hitting localhost

Hi;

I get this error randomly on both my home and work computer. I'm hitting Sql 
Server 2000 dev version on localhost. This happens on both my home and work 
computer.

Here's the exception:
System.Data.SqlClient.SqlException occurred
  Message="Timeout expired.  The timeout period elapsed prior to completion 
of the operation or the server is not responding."
  Source=".Net SqlClient Data Provider"
  ErrorCode=-2146232060
  Class=11
  LineNumber=0
  Number=-2
  Procedure=""
  Server="localhost"
  State=0
  StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException 
exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
exception, Boolean breakConnection)
       at 
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject 
stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet 
bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader 
ds, RunBehavior runBehavior, String resetOptionsString)
       at 
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, 
DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior 
behavior, String method)
       at 
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at 
net.windward.datasource.ado.AdoDataSource.executeQuery(IDbConnection conn, 
String select) in 
C:\src\kahuna\DotNetEngine\WindwardReports\net\windward\datasource\ado\AdoDataSource.jsl:line 1852

-- 
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

Date:Thu, 5 Jul 2007 22:38:00 -0700 Author:

RE: Randomly get timeout on SqlClient hitting localhost

Hi Dave,

From your description, you're getting some timeout exception in your 
application randomly, correct?

It seems your ADO.NET code will meet connection unusable condition 
randomly. Have you checked the server-side to see whether there is anything 
abnormal sometimes? Since the code works mostly and if the code logic is 
not quite complex, I think client-side should be ok.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.

Date:Fri, 06 Jul 2007 11:57:48 GMT Author:

RE: Randomly get timeout on SqlClient hitting localhost

That's what is so strange about this - it is all on one machine. And this is 
not a web app, it a Forms app. So there isn't much to go wrong at the 
communications layer.

The other thing I just realized - it times-out fast. In under a second. So 
there is some reason that it decides it is a timeout other than taking a long 
time trying to connect.

-- 
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

"Steven Cheng[MSFT]" wrote:

> Hi Dave,
> 
> From your description, you're getting some timeout exception in your 
> application randomly, correct?
> 
> It seems your ADO.NET code will meet connection unusable condition 
> randomly. Have you checked the server-side to see whether there is anything 
> abnormal sometimes? Since the code works mostly and if the code logic is 
> not quite complex, I think client-side should be ok.
> 
> Sincerely,
> 
> Steven Cheng
> 
> Microsoft MSDN Online Support Lead
> 
> 
> This posting is provided "AS IS" with no warranties, and confers no rights.
> 
>

Date:Fri, 6 Jul 2007 07:06:05 -0700 Author:

RE: Randomly get timeout on SqlClient hitting localhost

Thanks for your reply Dave,

Since it is a client form application, I think the problem should not be 
caused by performance stress. If possible, you can try connecting to 
different database to see whether you'll encounter the same error. 

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.

Date:Tue, 10 Jul 2007 15:10:39 GMT Author:

RE: Randomly get timeout on SqlClient hitting localhost

I do. I get this problem on both my work and home computer. In both cases 
they are connecting to a local copy of Sql Server 2000 dev version.

-- 
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm




"Steven Cheng[MSFT]" wrote:


> Thanks for your reply Dave,
> 
> Since it is a client form application, I think the problem should not be 
> caused by performance stress. If possible, you can try connecting to 
> different database to see whether you'll encounter the same error. 
> 
> Sincerely,
> 
> Steven Cheng
> 
> Microsoft MSDN Online Support Lead
> 
> 
> This posting is provided "AS IS" with no warranties, and confers no rights.
> 
>

Date:Tue, 10 Jul 2007 08:24:05 -0700 Author: