System.Data.EntityException:底层提供程序提交失败

问题描述

使用实体框架，我昨晚在我的一个应用程序中收到了许多以下异常:

Using Entity Framework, I received a number of the following exceptions last night in one of my applications:

System.Data.EntityException: The underlying provider failed on Commit. ---> 
System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior 
to completion of the operation or the server is not responding.     
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()     
    at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
    at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()     
    at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()     
    at System.Data.SqlClient.TdsParserStateObject.ReadByte()     
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler,SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     
    at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)     
    at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
    at System.Data.SqlClient.SqlInternalTransaction.Commit()     
    at System.Data.SqlClient.SqlTransaction.Commit()
    at System.Data.EntityClient.EntityTransaction.Commit()     
    --- End of inner exception stack trace ---     
    at System.Data.EntityClient.EntityTransaction.Commit()     
    at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)     
    at System.Data.Entity.Internal.InternalContext.SaveChanges()     
    at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()

这个错误的有趣之处在于数据实际上已写入数据库.我在 MS 网站上找到了一篇相关帖子似乎表明这是与网络相关的错误.

What's interesting about this error is that the data was actually written to the database. I found a related post on a MS site that seemed to indicate that this was a network related error.

我可以寻求帮助的几个问题是:

A few questions that I could use assistance on are:

1. 我有什么方法可以解决这个错误?
2. 它很可能与网络有关还是数据库可能是嫌疑人?
3. 如何从代码中判断交易是否真的完成了?
4. 我应该针对此错误查询数据库以检查是否成功还是简单地重试事务?
5. 如果我重试事务，如何使用实体框架自动完成，或者我只是简单地捕获/重试?
6. 我还应该查看哪些其他项目?

提前致谢.

更新

使用 Ignite for SQL 我们能够确定来自另一个组的辅助 SQL 进程正在垄断CPU 阻止我们的应用程序正常运行.简而言之，我们正在推进添加辅助服务器，以防止两个团队之间进一步发生冲突.

Using Ignite for SQL we were able to determine that a secondary SQL process from another group was monopolizing the CPU preventing our application from functioning properly. In short, we're moving forward with adding a secondary server to prevent further conflicts between the two teams.

关于异常仍然有趣的是，交易实际上成功而不是失败.

What's still interesting about the exception is that the transaction actually succeeded rather than failed.

推荐答案

我敢打赌，来自事务提交命令的成功响应未发送(或发送速度不够快)导致您的代码出现异常.一个有点疯狂的边缘案例.此类异常并不一定意味着命令的实际执行失败，只是存在A 失败.

My bet is that the success response from the transaction commit command was not sent (or not sent fast enough) causing an exception in your code. A kinda crazy edge case. Exceptions of this kind dont necessarily mean that the actual execution of the command failed just that there was A failure.

同样，如果从网络服务调用发送响应时出现问题，也不一定意味着没有应用该调用的任何副作用.

In the same way if there was a problem sending the response from a webservice call it wouldn't necessarily imply that any side effects of that call were not applied.

这篇关于System.Data.EntityException:底层提供程序提交失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！