查询时偶然会出现异常 返回
银 发布于2020/11/26
SqlSugar.SqlSugarException: English Message : Entity mapping error.Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Chinese Message : 实体与表映射出错。Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at SqlSugar.Check.Exception(Boolean isException, String message, String[] args) at SqlSugar.DbBindAccessory.GetEntityList[T](SqlSugarProvider context, IDataReader dataReader) at SqlSugar.DbBindProvider.DataReaderToList[T](Type type, IDataReader dataReader) at SqlSugar.QueryableProvider`1.GetData[TResult](Boolean isComplexModel, Type entityType, IDataReader dataReader) at SqlSugar.QueryableProvider`1.GetData[TResult](KeyValuePair`2 sqlObj) at SqlSugar.QueryableProvider`1._ToList[TResult]() at SqlSugar.QueryableProvider`1.ToList() at KG.Service.IndividualCustomer.IndividualCustomerGroupService.GetGroupCustom(List`1 groupId, Int32 sort) in D:\NetCoreProject\KG.Api\KG.Service\IndividualCustomer\IndividualCustomerGroupService.cs:line 279 at KG.Service.IndividualCustomer.IndividualCustomerGroupService.AppGet(CustomGroupInputModel input, UserInfoModel user) in D:\NetCoreProject\KG.Api\KG.Service\IndividualCustomer\IndividualCustomerGroupService.cs:line 235 at KG.Api.OpenArea.App.Customer.CustomGroupController.GetGroupItem(CustomGroupInputModel input) in D:\NetCoreProject\KG.Api\KG.Api\OpenArea\App\Customer\CustomGroupController.cs:line 76 at lambda_method(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
热忱回答（6）
-
银 VIP0
2020/11/26
数据库:SqlServer
环境:.net core3.1
版本:5.0.1.2
0 回复 -
银 VIP0
2020/11/26
查询语句:
var list = db.Queryable<IndividualCustomerTbl>()
.Where(a => groupId.Contains(a.GroupId))
.OrderByIF(sort == 1, a => a.CustomNameLetter)
.OrderByIF(sort == 2, a => a.AddTime)
.OrderByIF(sort == 3, a => a.AddTime, OrderByType.Desc)
.OrderByIF(sort == 4, a => a.CultivationTime)
.OrderByIF(sort == 5, a => a.CultivationTime, OrderByType.Desc)
.OrderByIF(sort == 6, a => a.RevisitTime)
.OrderByIF(sort == 7, a => a.RevisitTime, OrderByType.Desc)
.PartitionBy(a => a.GroupId)
.Take(50).ToList();
0 回复 -
银 VIP0
2020/11/26
SqlSugarClient db = new SqlSugarClient(
new ConnectionConfig()
{
ConnectionString = ConfigurationHelper.GetConfigValueByKey("dbConfig:operationDB"),
DbType = DbType.SqlServer,
InitKeyType = InitKeyType.Attribute,//从特性读取主键和自增列信息
IsAutoCloseConnection = true//开启自动释放模式和EF原理一样我就不多解释了
});
0 回复 -
银 VIP0
2020/11/26
要把查询设置成NoLock吗？
0 回复 -
fate stay night VIP0
2020/11/26@银： 参考 这个文章 http://www.donet5.com/Home/Doc?typeId=1224 记录了目前所有偶发性问题的汇总
0 回复 -
银 VIP0
2020/11/26
@fate stay night：好的，谢谢，我看下
0 回复