Timeout expired RSS

• • Reply
  

  joshuait

  Member

  65 Points

  117 Posts

  Timeout expired

  Aug 20, 2012 07:22 AM|LINK

  Hi all,

  I am frequently getting the following error while using LINQ query to fetch data(Not while using Stored Procedure).

  My Connection string : 

  <add name="ConnectionString" connectionString="Data Source=example.com;Initial Catalog=&quot;Test DB&quot;;Uid=MyUid;Pwd=MyPass;Connect Timeout=3600; pooling='true'; Max Pool Size=200"
     providerName="System.Data.SqlClient" />

  Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding 

  My Stack Trace:

  
  

  [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
     System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073502
     System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064460
     System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
     System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
     System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
     System.Data.SqlClient.SqlDataReader.get_MetaData() +86
     System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
     System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
     System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
     System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
     System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
     System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
     System.Data.Common.DbCommand.ExecuteReader() +12
     System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +1266
     System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +113
     System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +344
     System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +34
     System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +315
     System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
     System.Data.Linq.Provider.BindingList.Create(DataContext context, IEnumerable`1 sequence) +82
     System.Data.Linq.DataQuery`1.GetNewBindingList() +40
     System.Data.Linq.DataQuery`1.System.ComponentModel.IListSource.GetList() +15
     System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +54
     System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +41
     System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +266
     System.Web.UI.WebControls.DataBoundControl.GetData() +4
     System.Web.UI.WebControls.DataBoundControl.PerformSelect() +59
     System.Web.UI.WebControls.ListView.PerformSelect() +113
     System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74
     my_reports.Page_PreRender(Object o, EventArgs e) in d:\HB\newBillflash\my-reports.aspx.cs:88
     System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
     System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
     System.EventHandler.Invoke(Object sender, EventArgs e) +0
     System.Web.UI.Control.OnPreRender(EventArgs e) +8997922
     System.Web.UI.Control.PreRenderRecursiveInternal() +103
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496

  Please give your suggestions to avoid this

  Thanks,
  Joshua
  • Edited by joshuait on Aug 20, 2012 07:31 AM
• • Reply
  

  AidyF

  Star

  9250 Points

  1578 Posts

  Re: Timeout expired

  Aug 20, 2012 07:42 AM|LINK

  The problem is with your SQL, not the code.  If you are processing a lot of data, or using tables with a lot of rows, you might need to write your SQL to be more efficient, or implement indexes to speed up data access.  Other problems that can give timeouts are deadlocks which can be monitored via the Activity Monitor.

• • Reply
  

  joshuait

  Member

  65 Points

  117 Posts

  Re: Timeout expired

  Aug 20, 2012 08:52 AM|LINK

  Hi AidyF,

  I am not retreving more records. It will be less than 100.

  I am retreving data from table A and B as IEnumerable and storing in Session. Then I  bind that Session with ListView. While binding I am again working(retreving data) from table C joining with table A.

  Will this do deadlock? Or will this leads to above told error ?

  Thanks,
  Joshua
  • Edited by joshuait on Aug 20, 2012 08:53 AM
  • Edited by joshuait on Aug 20, 2012 08:53 AM
  • Edited by joshuait on Aug 20, 2012 08:53 AM
• • Reply
  

  AidyF

  Star

  9250 Points

  1578 Posts

  Re: Timeout expired

  Aug 20, 2012 09:16 AM|LINK

  The best way to work on these issues is to use SQL Profiler to trace exactly what is happening, how long things are taking etc.  You can copy the sql being sent to your server and paste it into SQL Management Studio and run it direct to see how it performs, if there are deadlocks, or get SQL Managemenbt Studio to show you the execution plan of the sql too.

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Timeout expired

  Aug 22, 2012 01:18 AM|LINK

  joshuait

  joshuait

  Hi,

  Please try to change your connetion string to——

  Server=.;database=YourDbname;integrated security=sspi

  And please don't forget to set the CommandTimeOut for the LINQ's generated command's instance such as this below：

  using(LinqDataContext dc = new LinqDataContext())
  {
     dc.CommandTimeOut = your value here;
  }
  http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.commandtimeout.aspx

  • Marked as answer by joshuait on Aug 22, 2012 07:14 AM
• • Reply
  

  raghunandcs

  Member

  686 Points

  163 Posts

  Re: Timeout expired

  Aug 22, 2012 06:51 AM|LINK

  Hi,

  Use command.CommandTimeOut=500;

  before Executing Query.

  Hopes Helps You..........

  SEO Vanger