Forums

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

This question is not answered

After upgrading to 2008.5 some of the users are getting this time out error while replying to a post.

This happens only for few users but it always happens for them. Though they get this error, the the post is properly saved and visible. What  could be the reason?

Here is the exception log.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

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) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   CommunityServer.Data.ForumsSqlDataProvider.UpdatePostCategories(Int32 sectionID, Int32 postID, String[] categoryList) +302
   CommunityServer.Discussions.Components.Posts.AddPost(ForumPost post, User postAuthor) +73
   CommunityServer.Discussions.Controls.CreateEditForumPostForm.SavePost(Thread post) +91
   CommunityServer.Discussions.Controls.CreateEditForumPostForm.SubmitButton_Click(Object sender, EventArgs e) +180
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

 

All Replies
  • While checking further, I found that this issue is not specific to a user but it happens for all users for some of the forums.

    Please suggest a solution asap.

     

     

     

     

  • We have recently encountered this issue as well. It happens on only one forum though, the largest  of the forums of course.

    Any guidance would be greatly appreciated.


  • Have you run either of the database maintenance scripts recently - cs_system_dbreindex and cs_system_updatestatistics ?

  • I don't know if the scripts have been recently. If we need to I'll have to tell the DBA.

    The interesting part is that using the Quick Reply link works without a hitch. Using the Reply link causes the problem. Any thoughts?


  • no, not done. you want me to try that?

  • Yes.  If you haven't run those recently, give them a go.

  • Hi Sudin,

    We are also facing the same issue. Did you got any solution for this problem?

    Please reply.

    Thanks

    Veer

     

  • Yes, the problem is not occuring now / or at least the frequency is less.

    Not sure what exactly solved the issue. I made some more free diskspace and reindexed the tables.