sql-server - 网站 fatal error 9001

Question

我知道以前曾在这里问过这个问题，但没有任何建议对我有用。

我在共享服务器上有一个 ASP.NET MVC (v. 3) 网站。该网站已经运行了几个星期，直到我开始收到 Fatal Error 9001登录后直接报错。

因为这是一个共享服务器，所以我只能用数据库做非常有限的事情(而且我对数据库了解不多)。服务台坚持认为他们的服务器没有任何问题。我从他们那里得到了各种建议:

由于空间不足，升级到商业计划

即使 mdb 文件很小，ldb 也可以快速增长。 ldb 文件可能占用了所有空间。我有 100MB 可用空间，数据库大小为 16.5MB。 ldb文件可以占用剩余空间吗？

我的 SQL 查询有问题，我应该检查网站。我正在将 EF 与 linq to sql 一起使用。到目前为止，一切都运行良好......查询中是否有错误导致此类错误？

在 db 日志中看不到任何错误，因此不可能发生此错误。下次它发生时我应该记录它并再次联系。

我在 SO 上发现了一些帖子，建议恢复数据库备份可以解决这个问题。我没有最近的备份，因为 fatal error 9001 不能拿一个新的发生。

我还能做什么/尝试让我的网站再次运行？

更新:

我今天从托管该网站的服务台收到回复。他们告诉我下面的错误信息。

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)

关于 9001 错误，有人能理解这一点吗？他们声称这是我的网站或 .net 4.0 的问题。 .那可能吗？

Answer 1

我今天得到了这个并通过使数据库脱机然后再次联机来“修复”它。它只是治标不治本，所以问题可能会再次出现，但至少数据库可以再次执行写入操作。