并发控制

2019独角兽企业重金招聘Python工程师标准>>>

在进行一个并发任务时，出现发下错误日志：

根据排查，原因是，每个任务是并发发起的，但检查到没有初始化 地理范围时，立即进行初始化，应该只需一个任务进行即可，但实际上是多个任务同时进行，导致事务锁死在 表锁（更新锁）中，更新检测代码即可避免此问题。

2018-11-20 09:50:18,314 [37] ERROR IBeam.TourStatistic.Objects.TeamStatisticTaskOfTeamGroupType [(null)] - 执行执行团队来源地匹配任务时出错：Csla.DataPortalException: DataPortal.Update 失败 (NHibernate.TransactionException: An error occured when trying to dispose the transaction ---> NHibernate.TransactionException: Transaction not connected, or was disconnected
   在 NHibernate.Transaction.AdoTransaction.CheckNotZombied()
   在 NHibernate.Transaction.AdoTransaction.Rollback()
   在 Castle.ActiveRecord.TransactionScope.PerformDisposal(ICollection`1 sessions)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Castle.ActiveRecord.TransactionScope.PerformDisposal(ICollection`1 sessions)
   在 Castle.ActiveRecord.Framework.Scopes.AbstractScope.Dispose()
   在 IBeam.MDAA.Objects.GeographicBoundary.InitCommand.DataPortal_Execute()
   在 lambda_method(Closure , Object , Object[] )
   在 Csla.Reflection.MethodCaller.CallMethod(Object obj, DynamicMethodHandle methodHandle, Boolean hasParameters, Object[] parameters)) ---> Csla.Reflection.CallMethodException: InitCommand.DataPortal_Execute 调用函数失败 ---> NHibernate.TransactionException: An error occured when trying to dispose the transaction ---> NHibernate.TransactionException: Transaction not connected, or was disconnected
   在 NHibernate.Transaction.AdoTransaction.CheckNotZombied()
   在 NHibernate.Transaction.AdoTransaction.Rollback()
   在 Castle.ActiveRecord.TransactionScope.PerformDisposal(ICollection`1 sessions)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Castle.ActiveRecord.TransactionScope.PerformDisposal(ICollection`1 sessions)
   在 Castle.ActiveRecord.Framework.Scopes.AbstractScope.Dispose()
   在 IBeam.MDAA.Objects.GeographicBoundary.InitCommand.DataPortal_Execute()
   在 lambda_method(Closure , Object , Object[] )
   在 Csla.Reflection.MethodCaller.CallMethod(Object obj, DynamicMethodHandle methodHandle, Boolean hasParameters, Object[] parameters)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Csla.Reflection.MethodCaller.CallMethod(Object obj, DynamicMethodHandle methodHandle, Boolean hasParameters, Object[] parameters)
   在 Csla.Reflection.MethodCaller.CallMethod(Object obj, String method, Boolean hasParameters, Object[] parameters)
   在 Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Csla.DataPortal.Update[T](T obj)
   在 IBeam.MDAA.Objects.GeographicBoundary.Exists()
   在 IBeam.MDAA.Objects.GeographicBoundaryList.GetByName(String name, Int32 maxResult)
   在 IBeam.TourStatistic.Objects.TravelTeam.GetOriginFromGB(String gbName) 位置 d:\07 工程项目\GitLocal\IBeamTourStatistic\IBeamTourStatisticOjbects\Objects\01基础数据\TravelTeam.cs:行号 1860
   在 IBeam.TourStatistic.Objects.TravelTeam.MatchOriginFrom() 位置 d:\07 工程项目\GitLocal\IBeamTourStatistic\IBeamTourStatisticOjbects\Objects\01基础数据\TravelTeam.cs:行号 1888
   在 IBeam.TourStatistic.Objects.TeamSourceCityMatch.<DoMatchByDate>b__2(TravelTeam travelTeam) 位置 d:\07 工程项目\GitLocal\IBeamTourStatistic\IBeamTourStatisticOjbects\Objects\02匹配模式\01TeamSourceCityMatch.cs:行号 140
2018-11-20 09:50:19,563 [43] WARN  NHibernate.Util.ADOExceptionReporter [(null)] - System.Data.SqlClient.SqlException (0x80131904): 事务(进程 ID 67)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 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.TryHasMoreRows(Boolean& moreRows)
   在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   在 System.Data.SqlClient.SqlDataReader.Read()
   在 NHibernate.Driver.NHybridDataReader.Read()
   在 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   在 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
   在 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

转载于:https://my.oschina.net/u/141646/blog/2878574