none
ASP.Net MVC 3 with SQL SERVER 2008 R2 - Fatal Error 9001 RRS feed

  • Question

  • I have a website written in ASP.NET MVC and .Net 4.0 hosted on a shared server running SQL Server 2008 R2. The Website has worked pretty much without problems for weeks.

    Last week-end I started getting a Fatal Error 9001 after log in. I have queried the problem with the host's helpdesk for the last week, but the support team there is adamant that there is nothing wrong, nothing at all, with their server and that the problem lies either with the website or is specific to the .Net 4.0. framework.

    I have been provided with the following error trace by them:

    Event code: 3005 
    Event message: An unhandled exception has occurred. 
    Event time: 11/23/2012 6:50:03 AM 
    Event time (UTC): 11/23/2012 12:50:03 PM 
    Event ID: 55fd03ff030d4d05bf791aa57b726df4 
    Event sequence: 8 
    Event occurrence: 1 
    Event detail code: 0 
     
    Application information: 
        Application domain: /LM/W3SVC/9891/ROOT-1-129981485984030000 
        Trust level: Full 
        Application Virtual Path: / 
        Application Path: C:\ClientSites\friedemannallgayer.com\httpdocs\ 
        Machine name: ASPHOST94 
     
    Process information: 
        Process ID: 87868 
        Process name: w3wp.exe 
        Account name: ASPHOST94\IWPD_293(friedemann) 
     
    Exception information: 
        Exception type: SqlException 
        Exception message: Warning: Fatal error 9001 occurred at Nov 23 2012  6:50AM. Note the error and time, and contact your system administrator.
       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()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader)
       at System.Data.SqlClient.SqlDataReader.Close()
       at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate)
       at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
       at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password)
       at PapaFilmsDB.Models.AccountMembershipService.ValidateUser(String userName, String password) in C:\Users\david.DOMAIN_GIS\Dropbox\Programming\PapaFilmsDB\PapaFilmsDB_20121029\PapaFilmsDB\Data\Models\AccountModels.cs:line 119
       at PapaFilmsDB.Controllers.AccountController.LogOn(LogOnModel model, String returnUrl) in C:\Users\david.DOMAIN_GIS\Dropbox\Programming\PapaFilmsDB\PapaFilmsDB_20121029\PapaFilmsDB\Controllers\AccountController.cs:line 40
       at lambda_method(Closure , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
       at System.Web.Mvc.Controller.ExecuteCore()
       at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
       at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
       at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
       at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()
       at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f)
       at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action)
       at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
       at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     
     
    Request information: 
        Request URL: 
    http://www.friedemannallgayer.com/Account/LogOn?ReturnUrl=/ 
        Request path: /Account/LogOn 
        User host address: 93.219.156.103 
        User:  
        Is authenticated: False 
        Authentication Type:  
        Thread account name: ASPHOST94\IWPD_293(friedemann) 
     
    Thread information: 
        Thread ID: 9 
        Thread account name: ASPHOST94\IWPD_293(friedemann) 
        Is impersonating: False 
        Stack trace:    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()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader)
       at System.Data.SqlClient.SqlDataReader.Close()
       at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate)
       at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
       at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password)
       at PapaFilmsDB.Models.AccountMembershipService.ValidateUser(String userName, String password) in C:\Users\david.DOMAIN_GIS\Dropbox\Programming\PapaFilmsDB\PapaFilmsDB_20121029\PapaFilmsDB\Data\Models\AccountModels.cs:line 119
       at PapaFilmsDB.Controllers.AccountController.LogOn(LogOnModel model, String returnUrl) in C:\Users\david.DOMAIN_GIS\Dropbox\Programming\PapaFilmsDB\PapaFilmsDB_20121029\PapaFilmsDB\Controllers\AccountController.cs:line 40
       at lambda_method(Closure , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
       at System.Web.Mvc.Controller.ExecuteCore()
       at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
       at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
       at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
       at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()
       at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f)
       at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action)
       at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
       at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    The part I do not get is that this is actually the second time this error occurs. Both times I have not made any change to the website for weeks before the error occurs.

    In both cases the error ended up resolving itself. In this instance my website started working again today. I checked again on Friday evening and the website was not working. I did not make any changes at all to the site itself since the error first happened. Today the website works again as usual.

    I have made sure that the DB size is below the allowed quota and that I am not running out of space on the server.

    Both times my website has been down for about a week before starting to work again. I really would like to know why this happens? Whether or not it is a website error or a server problem? What can be done to avoid this happening or at least fix it without having to wait for some unknown factor to work itself out.

    Monday, November 26, 2012 4:21 AM

All replies