更新数据库将索引添加到表中,并且EF代码优先-超时已过期。完成之前经过的超时时间

山姆·斯通

当我在包管理器控制台中执行此命令'update-database -verbose'时,出现此错误,并且我找不到增加超时的方法,我尝试将connect timeout = 180添加到app.config(web.config)和上下文对象中也是,但仍然没有任何工作得到错误

超时时间已到。在操作完成之前超时或服务器没有响应。

而且我已经阅读了所有类似的Stack线程

这是完整的错误和命令

update-database -verbose
Using StartUp project 'Biroon'.
Using NuGet project 'Biroon.Data'.
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
Target database is: 'Biroon' (DataSource: raysan144-pc\sql2008, Provider: System.Data.SqlClient, Origin: Configuration).
Applying explicit migrations: [201509060848153_updateduserindexes].
Applying explicit migration: 201509060848153_updateduserindexes.
ALTER TABLE [dbo].[Users] ALTER COLUMN [Email] [nvarchar](50) NULL
ALTER TABLE [dbo].[Users] ALTER COLUMN [Mobile] [nvarchar](11) NULL
CREATE UNIQUE INDEX [IX_Email] ON [dbo].[Users]([Email])
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

   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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
   at System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable`1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection)
   at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass30.<ExecuteStatements>b__2e()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.ExecuteStatements(IEnumerable`1 migrationStatements)
   at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto)
   at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
   at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b()
   at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)
   at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
ClientConnectionId:fa640696-a50b-4cc3-9e69-0e87a28e2993
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
山姆·斯通

我发现我的问题是我想添加唯一索引的字段中有太多空值。为了增加执行超时的时间,实体框架程序包管理器控制台应该在configuration.cs文件中添加CommandTimeout。

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

执行超时已过期。在操作完成之前超时时间已过或服务器没有响应

Mysql备份中的超时已过期-C#

连接超时已过期。尝试使用登录前握手确认时经过的超时时间

超时已过期SQL Server 2012超时时间已过

ORA-00054:资源正忙并且正在使用指定的NOWAIT进行获取或超时已过期

从 VB、NET 更新 SQL Server 时查询超时已过期

由于“获取主题元数据时超时已过期”,因此使用Kafka失败

使用ADO.NET填充数据集时出现错误-超时已过期

直接执行自定义SQL时,查询超时在django-mssql中已过期

超时时间已到。在Azure SQL上完成操作之前经过的超时时间

如何修复信号灯超时时间已过期

向代理请求测试0的元数据时,由于超时,包含1条记录的批次已过期

SqlException超时已过期

VI_ERROR_TMO(-1073807339):在操作完成之前超时已过期

超时时间已到。在操作完成之前超时时间已过,或者服务器没有响应。”

在GCP PubSub中收到任何响应之前,重试了总超时时间

从iis ftp-site完成操作之前经过的超时时间

从池中获取连接之前超时时间已过 - 实体框架

超时时间已到。从池中获取连接之前已经经过了超时时间。

通过将持续时间添加到 SQLite 数据库中的开始日期来更新结束日期

在将盐存储到数据库中之前将盐添加到密码中

如何在Spring Cloud Gateway中设置超时时间?

如何延长Circleci中测试的超时时间?

如何在RDS Postgres中设置查询超时时间

如何增加 Apify 中函数的默认超时时间

您好,如何检查类中的哪些列表中的时间元素已过期?

将数据以及经过验证的数据和未经验证的数据添加到Laravel中的数据库

MVC应用程序获取执行超时已过期

proxy_ajp:错误(70007)指定的超时已过期: