定期 InvalidCastException 和“服务器未能恢复事务"与林克 [英] Periodic InvalidCastException and "The server failed to resume the transaction" with Linq

问题描述

我在我们的舞台系统上看到了这个，它已经运行了 2-3 天.

I see this on our stage system, after it has been up for 2-3 days.

服务器未能恢复交易.描述:39000000ef."(desc:xxx 每次都增加).

"The server failed to resume the transaction. Desc:39000000ef." (with desc:xxx increasing every time).

堆栈跟踪显示

System.Data.SqlClient.SqlException: The server failed to resume the transaction. Desc:39000000ef.
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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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()
at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at ...

这件事发生后，整个服务器都变得很糟糕.似乎元数据不再在内存中正确表示，因为之后我看到了许多 InvalidCastExceptions.我猜这是因为系统试图将字符串反序列化为 int 字段，因为元数据偏移不正确.

After this has happened the entire server goes to heck. It seems like the metadata is no longer correctly represented in memory, because I see many InvalidCastExceptions afterwards. I'm guessing this is due to the system trying to deserialize a string into an int field because the metadata is offset incorrectly.

即

System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at Read_Order(ObjectMaterializer`1 )
at System.Data.Linq.SqlClient.ObjectReaderCompiler.ObjectReader`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

这是什么意思?

我相当确定数据库没有在系统后更新，而且数据库一直在线.

I'm fairly sure the database wasn't updated behind the systems back, and the database was online the entire time.

此问题一直存在，直到服务器重新启动，之后一切正常.

The problem persists from here on out, until the server is restarted, after which everything works nicely.

如果失败，我是否需要重新建立数据库连接的代码?框架不是自己处理的吗?

Do I need to have code that re-establishes database connection if it fails? Doesn't the framework handle this by itself?

我使用的是 Sql server 2008、IIS 6 和 .Net 3.5SP1

I'm using Sql server 2008, IIS 6, and .Net 3.5SP1

更新:代码结构是这样的:

UPDATE: The code structure does something like this:

var dc = new datacontext()
IList<someobject> objs = dc.GetAllItemsToProcess()
var dc2 = new datacontext();
 foreach( var o in objs ) {
    try {
         var o2 = dc2.someobjects.SingleOrDefault(x=>x.id = o.id);
          // do stuff to o2
         dc2.save();
   } catch() {
          // something failed so restart datacontext()
         dc2 = new datacontext();
    }
}

推荐答案

只是更新:

• 我跟踪了我们使用作为数据源直接传递给报表服务器的 Linq2Sql 实体的错误.

即我们正在做这样的事情:

I.e. we were doing something like this:

List<Order> orderList = orderRepository.getOrders();
ReportViewer rv = new ReportViewer();
rv.LocalReport.DataSources.Add("OrderList", orderList);
rv.Render();

出于某种原因，即使在同一个应用程序域中运行时，这也使数据上下文变得混乱.

For some reason this made the datacontext confused, even when running in the same app-domain.

这篇关于定期 InvalidCastException 和“服务器未能恢复事务"与林克的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！