Timeout expired. The timeout period elapsed prior to completion of the operatio

yananguo_1985 2010-08-12 07:06:58
ExceptionMessage:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


ExceptionStackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DbSharper.Library.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:\Projects\DbSharper4GoogleCode\trunk\DbSharper\DbSharper.Library\Data\SqlHelper.cs:line 613 at DbSharper.Library.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:\Projects\DbSharper4GoogleCode\trunk\DbSharper\DbSharper.Library\Data\SqlHelper.cs:line 530 at DMedia.Sagitta.Data.Space.DataAccess.XSpace.VisitedUser.Create(VisitedUserItem item, String connectionString) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Data\Space.DataAccess.XSpace.cs:line 26385 at DMedia.Sagitta.Repository.RecentVisitorRepository.RecentVisitorAdd(Int32 userId, Int32 creatorId) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Repository\Space\RecentVisitorRepository.cs:line 58 at DMedia.Sagitta.Service.Site.ChannelService.RecentVisitorAdd(Int32 userId, Int32 creatorId) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Service\Site\ChannelService.cs:line 199 at DMedia.Sagitta.Service.CounterService.UpdateVisitCounter(VisitCounterModel model) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Service\Space\CounterService.cs:line 43 at DMedia.Sagitta.SpaceCore.ActionFilters.SpaceDefaultAttribute.OnActionExecuting(ActionExecutingContext filterContext) in E:\private\037_Sagitta\代码库\DMedia.Sagitta\Src\Sites\Space\Core\ActionFilters\SpaceDefaultAttribute.cs:line 65 at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) 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.MvcHandler.ProcessRequest(HttpContextBase httpContext) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


ExceptionStackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DbSharper.Library.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:\Projects\DbSharper4GoogleCode\trunk\DbSharper\DbSharper.Library\Data\SqlHelper.cs:line 613 at DbSharper.Library.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in D:\Projects\DbSharper4GoogleCode\trunk\DbSharper\DbSharper.Library\Data\SqlHelper.cs:line 530 at DMedia.Sagitta.Data.Space.DataAccess.XSpace.UserVisitedLog.Create(UserVisitedLogItem item, String connectionString) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Data\Space.DataAccess.XSpace.cs:line 26044 at DMedia.Sagitta.Repository.UserVisitedLogRepository.Create(UserVisitedLogModel model) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Repository\Site\UserVisitedLogRepository.cs:line 19 at DMedia.Sagitta.Service.UserService.UserVisitAdd(Int32 userId) in d:\DailyBuild2012\Sagitta.Space\代码库\DMedia.Sagitta\Src\Service\Site\UserService.cs:line 2406 at DMedia.Sagitta.SpaceCore.ActionFilters.SpaceDefaultAttribute.CheckAccessRight(Int32 id, ActionExecutingContext filterContext, Boolean IsCheckAccessRight) in E:\private\037_Sagitta\代码库\DMedia.Sagitta\Src\Sites\Space\Core\ActionFilters\SpaceDefaultAttribute.cs:line 226 at DMedia.Sagitta.SpaceCore.ActionFilters.SpaceDefaultAttribute.OnActionExecuting(ActionExecutingContext filterContext) in E:\private\037_Sagitta\代码库\DMedia.Sagitta\Src\Sites\Space\Core\ActionFilters\SpaceDefaultAttribute.cs:line 45 at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) 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.MvcHandler.ProcessRequest(HttpContextBase httpContext) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


请求高手帮忙查找问题。是由于数据库引起的吗?
...全文
1928 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
yananguo_1985 2010-08-12
  • 打赏
  • 举报
回复
会不会web服务器超时这种情况。
因为在出现这种情况的时候有些人可以访问,但是有些出现访问不了。
Peter200694013 2010-08-12
  • 打赏
  • 举报
回复
数据库连接超时,可能是server问题

以前有个项目,连某个server上数据库老是超时,后来换了server就好了
wuyq11 2010-08-12
  • 打赏
  • 举报
回复
网络不通也引起超时
yananguo_1985 2010-08-12
  • 打赏
  • 举报
回复
有可能是网络引起导致连接超时?
wuyq11 2010-08-12
  • 打赏
  • 举报
回复
超时时间已到。在操作完成之前超时时间已过或服务器未响应
优化sql语句
在查询分析器执行时间,添加索引
using及时关闭
wwfgu00ing 2010-08-12
  • 打赏
  • 举报
回复
服务器没有相应
imfor 2010-08-12
  • 打赏
  • 举报
回复
看不懂,貌似数据库超时。
请描述出现此情况时的你具体的操作,以便他人帮忙解决问题。

62,046

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见,支持健康理性的辩论和互动,反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧