命令超时SQL Server 2014 +实体框架 [英] Command timeout SQL Server 2014 + Entity Framework
问题描述
我已经在我的新电脑上安装了SQL Server 2014,它一直工作,直到我重新启动了我的电脑,现在我收到这个错误。
I have installed SQL Server 2014 on my new PC yesterday, it was working until I restarted my PC, now I am getting this error.
我已经开始/重新启动SQL Server服务等。
I have started / restarted SQL Server services etc..
我仍然可以从Management Studio连接。
I can still connect from Management Studio.
将EF模型添加到我的asp.net项目,它可以列出数据库和获取表来生成EF模型,但是由于这个超时异常,我无法对数据库做任何事情,数据库几乎是空的(只有1个表中有1个用户),而我执行简单的查询(如select,add)
When adding EF model to my asp.net project, it can list databases and get tables to generate EF model, but I can't do anything with the database because of this timeout exception, database is almost empty (only 1 table with 1 user in) and I am executing simple queries (like select, add)
using(var db = new TestEntities())
{
var _user = db.Users.FirstOrDefault(); // timeout exception
}
未处理的异常:系统。 Data.Entity.Core.EntityCommandExecutionException:执行命令定义时发生错误。查看内部例外情况。 ---> System.Data.SqlClient.SqlException:超时过期。在完成操作或服务器之前经过的超时时间没有响应。 ---> System.ComponentModel.Win32Exception:等待操作超时
---内部异常堆栈跟踪结束---
在System.Data.SqlClient.SqlConnection。 OnError(SqlException异常,Boolean breakConnection,Action1 wrapCloseInAction)
1 wrapCloseInAction)
在System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常,Boolean breakConnection,Action
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj,Boolean callerHasConnectionLock,Boolean asyncClose)
在System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,SqlCommand cmdHandler,SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler ,TdsParserStateObject stateObj,Boolean& dataReady)
在System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在System.Data.SqlClient.SqlDataReader.get_MetaData()
在System.Data.SqlClient .SqlCommand.Finish ExecuteReader(SqlDataReader ds,RunBehavior runBehavior,String resetOptionsString)
在System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,RunBehavior runBehavior,Boolean returnStream,Boolean async,Int32 timeout,Task&任务,Boolean asyncWrite,SqlDataReader ds,Boolean describeParameterEncryptionRequest)
在System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior,Boolean returnStream,String method,TaskCompletionSource1完成,Int32超时,Task& task,Boolean asyncWrite)
1 c)
在System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior,Boolean returnStream,String方法)
在System.Data.SqlClient.SqlCommand.ExecuteReader( CommandBehavior行为,String方法)
在System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior行为)
在System.Data.Common.DbCommand.ExecuteReader(CommandBehavior行为)
在System.Data .Entity.Infrastructure.Interception.DbCommandDispatcher。< Reader> b__c(DbCommand t,DbCommandInterceptionContext
在System.Data.Entity.Infrastructure.Interceptio n.InternalDispatcher1.Dispatch [TTarget,TInterceptionContext,TResult](TTarget target,Func
3操作,TInterceptionContext interceptionContext,Action3执行,Action
3执行)
在System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommandInterceptionContext interceptionContext)
在System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader( CommandBehavior行为)
在System.Data.Common.DbCommand.ExecuteReader(CommandBehavior行为)
在System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand,CommandBehavior行为)
---内部异常堆栈跟踪结束---
在System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand,CommandBehavior行为)
在System.Data。 Entity.Core.Objects.I nternal.ObjectQueryExecutionPlan.Execute [TResultType](ObjectContext context,ObjectParameterCollection parameterValues)
在System.Data.Entity.Core.Objects.ObjectQuery1. c__DisplayClass7。< GetResults> b__6 ()
1 func,IDbExecutionStrategy executionStrategy,Boolean startLocalTransaction,Boolean releaseConnectionOnSuccess)
在System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction [T](Func
在系统.Data.Entity.Core.Objects.ObjectQuery1. c__DisplayClass7。< GetResults> b__5()
1操作)
在System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute [TResult] (Func
在System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable
1 forMergeOption)$在System.Data.Entity.Core.Objects.ObjectQuery中的
1. System.Linq.Enumerable.Single [TSource](IEnumerable
。System.Data中的< System.Collections.Generic.IEnumerable< T> .GetEnumerator> b__0()
。 Entity.Internal.LazyEnumerator1源)中的
1序列)
$ System.Data.Entity.Core中的
。 Object.ELinq.ObjectQueryProvider。< GetElementFunction> b__3 [TResult](IEnumerable
在System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle [TResult]( IEnumerable1查询,表达式queryRoot)
1源) p>
在System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute [TResult](表达式表达式)
在System.Data.Entity.Internal.Linq.DbQueryProvider.Execute [TResult](表达式表达式)
在System.Linq.Queryable.Count [TSource](IQueryable
Unhandled Exception: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 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.ExecuteReader(CommandBehavior behavior) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext
1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func
3 operation, TInterceptionContext interceptionContext, Action3 executing, Action
3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Entity.Core.Objects.ObjectQuery1.<>c__DisplayClass7.<GetResults>b__6() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func
1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery1.<>c__DisplayClass7.<GetResults>b__5() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func
1 operation) at System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable
1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() at System.Data.Entity.Internal.LazyEnumerator
1.MoveNext() at System.Linq.Enumerable.Single[TSource](IEnumerable1 source) at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable
1 sequence) at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable1 query, Expression queryRoot) at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression) at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.Count[TSource](IQueryable
1 source)
推荐答案
设置超时命令
可能还有另一个问题
并测试一个简单的选择喜欢select @@ versino
And test a simple select like select @@versino
这篇关于命令超时SQL Server 2014 +实体框架的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!