事务死锁的问题如何解决?
OccurDate:2004-11-2 1:45:11
Source:.Net SqlClient Data Provider
TargetSiteName:ExecuteReader
StackTrace:at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at MicroFarm.Common.Data.MSSqlDataAccess.ExecuteNonQuery(CommandType commandType, String commandText, PersistenceParameterCollection commandParameterCollection) in E:\DEVROOT\MicroFarm\Common\Data\MSSqlDataAccess.vb:line 89
at MicroFarm.Rules.Operator.Law.Insert(Law lawEntity) in E:\DEVROOT\WWWROOT\MicroSpider\Rules\Operator\Law.vb:line 136
Message:事务（进程 ID 53）与另一个进程已被死锁在 lock 资源上，且该事务已被选作死锁牺牲品。请重新运行该事务。
死锁一般是什么情况下才发生?
Source:.Net SqlClient Data Provider
TargetSiteName:ExecuteReader
StackTrace:at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at MicroFarm.Common.Data.MSSqlDataAccess.ExecuteNonQuery(CommandType commandType, String commandText, PersistenceParameterCollection commandParameterCollection) in E:\DEVROOT\MicroFarm\Common\Data\MSSqlDataAccess.vb:line 89
at MicroFarm.Rules.Operator.Law.Insert(Law lawEntity) in E:\DEVROOT\WWWROOT\MicroSpider\Rules\Operator\Law.vb:line 136
Message:事务（进程 ID 53）与另一个进程已被死锁在 lock 资源上，且该事务已被选作死锁牺牲品。请重新运行该事务。
死锁一般是什么情况下才发生?
