johnk
  • Posts: 230
  • Joined: 23/04/2013
Forum was working fine for last few days. Today when I loaded the forum, I got this error message:

The forum is down for about 10 hours. Rest of the site is working fine. Any idea what is going on?


Server Error in '/' Application.

The wait operation timed out

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.ComponentModel.Win32Exception: The wait operation timed out

Source Error: 


Line 654:            {
Line 655:              // no transaction
Line 656:              da.Fill(ds);
Line 657:            }
Line 658:

Source File: D:\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs    Line: 656 

Stack Trace: 


[Win32Exception (0x80004005): The wait operation timed out]

[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, Action`1 wrapCloseInAction) +1753986
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5296058
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +558
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +1379
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +175
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88
   YAF.Classes.Data.MsSqlDbAccess.GetDatasetBasic(IDbCommand cmd, Boolean transaction) in d:\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:656
   YAF.Classes.Data.MsSqlDbAccess.GetData(IDbCommand cmd, Boolean transaction) in d:\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:550
   YAF.Types.Interfaces.Data.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd) in d:\yafnet_b2018edf174c\yafsrc\YAF.Types\Interfaces\Data\IDbAccessExtensions.cs:87
   YAF.Providers.Membership.DB.GetUser(String appName, Object providerUserKey, String userName, Boolean userIsOnline) in d:\yafnet_b2018edf174c\yafsrc\YAF.Providers\Membership\DB.cs:418
   YAF.Providers.Membership.YafMembershipProvider.GetUser(String username, Boolean userIsOnline) in d:\yafnet_b2018edf174c\yafsrc\YAF.Providers\Membership\YafMembershipProvider.cs:1011
   YAF.Core.UserMembershipHelper.GetUser(String username, Boolean updateOnlineStatus) in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\UsersRoles\UserMembershipHelper.cs:456
   YAF.Core.UserMembershipHelper.GetUser(Boolean updateOnlineStatus) in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\UsersRoles\UserMembershipHelper.cs:504
   YAF.Core.YafContext.get_User() in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\Context\YafContext.cs:336
   YAF.Core.YafContext.InitUserAndPage() in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\Context\YafContext.cs:426
   YAF.Core.UserPageBase.get_Page() in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\Context\UserPageBase.cs:410
   YAF.Core.UserPageBase.get_PageUserID() in d:\yafnet_b2018edf174c\yafsrc\YAF.Core\Context\UserPageBase.cs:521
   YAF.ForumPageBase.Page_Error(Object sender, EventArgs e) +110
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.TemplateControl.OnError(EventArgs e) +9692434
   System.Web.UI.Page.HandleError(Exception e) +79
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6695
   System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +245
   System.Web.UI.Page.ProcessRequest() +72
   System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
   System.Web.UI.Page.ProcessRequest(HttpContext context) +58
   ASP.forum_default_aspx.ProcessRequest(HttpContext context) +4
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18044


When I logged into SSMS and ran query to load eventlog table, the last seven errors today were the same. Please see details below:

User: Guest
Source: ASP.forum_pages_posts_ascx


Exception
System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   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(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at YAF.Classes.Data.MsSqlDbAccess.GetDatasetBasic(IDbCommand cmd, Boolean transaction) in d:\Website\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:line 656
   at YAF.Classes.Data.MsSqlDbAccess.GetData(IDbCommand cmd, Boolean transaction) in d:\Website\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:line 550
   at YAF.Types.Interfaces.Data.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd) in d:\Website\yafnet_b2018edf174c\yafsrc\YAF.Types\Interfaces\Data\IDbAccessExtensions.cs:line 87
   at YAF.Classes.Data.LegacyDb.message_findunread(Object topicID, Object messageId, Object lastRead, Object showDeleted, Object authorUserID) in d:\Website\yafnet_b2018edf174c\yafsrc\YAF.Classes\YAF.Classes.Data\mssql\LegacyDb.cs:line 4032
   at YAF.Pages.posts.GetFindMessageId(Boolean showDeleted, Int32 userId, Int32& messagePosition)


Since forum is fully down, I cannot go into admin settings to see any error logs. I have to run SQL query to see this.
Sponsor
johnk
  • Posts: 230
  • Joined: 23/04/2013
Whoops, it is working fine now. Not sure what was going on.

BTW, any idea what the errors in eventlog mean (about datetime overflow)?
Users browsing this topic
    Forum Jump  
    • You cannot post new topics in this forum.
    • You cannot reply to topics in this forum.
    • You cannot delete your posts in this forum.
    • You cannot edit your posts in this forum.
    • You cannot create polls in this forum.
    • You cannot vote in polls in this forum.

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved