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.