Open Closed

AbpDbConcurrencyException on InsertAndGetId() method #11259


0
Leonardo.Willrich created

Prerequisites

  • What is your product type (Angular or MVC)? MVC
  • What is product framework type (.net framework or .net core)? .Net CORE 3.1

If issue related with ABP Framework

  • What is ABP Framework version? 9.0.1

In some cases, in production enviroment, the server is throwing exception AbpDbConcurrencyException on InsertAndGetId() method.

I cannot reproduce this error and I have no idea what is wrong. It doesn't happen always, it is intermittent.

I wonder if there is some way to figure out what is wrong and fix it.

Exception: Abp.Domain.Uow.AbpDbConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions. ---> Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: Database operation expected to affect 1 row(s) but actually affected 0 row(s). Data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions. at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ThrowAggregateUpdateConcurrencyException(Int32 commandIndex, Int32 expectedRowsAffected, Int32 rowsAffected) at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetWithoutPropagationAsync(Int32 commandIndex, RelationalDataReader reader, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Abp.EntityFrameworkCore.AbpDbContext.SaveChangesAsync(CancellationToken cancellationToken) --- End of inner exception stack trace --- at Abp.EntityFrameworkCore.AbpDbContext.SaveChangesAsync(CancellationToken cancellationToken) at Abp.Zero.EntityFrameworkCore.AbpZeroCommonDbContext3.SaveChangesAsync(CancellationToken cancellationToken) at Abp.EntityFrameworkCore.Repositories.EfCoreRepositoryBase3.InsertAndGetIdAsync(TEntity entity) at Abp.Domain.Uow.UnitOfWorkInterceptor.InternalInterceptAsynchronous[TResult](IInvocation invocation) at ASL.iAPIS.ApiaryProjectCustomApp.ApiaryActionsService.CreateTasksInternalAsync(CreateTaskDto createTasks, List1 templateTasks, TaskStatus taskStatus) in E:\Products\iAPISWeb\iapisprod14sep\head\iAPIS_9.0.1\src\ASL.iAPIS.Application\ApiaryProjectCustomApp\ApiaryActionsService.cs:line 473 at ASL.iAPIS.ApiaryProjectCustomApp.ApiaryActionsService.CreateTasksAsync(CreateTaskDto createTasks, Boolean updateCache) in E:\Products\iAPISWeb\iapisprod14sep\head\iAPIS_9.0.1\src\ASL.iAPIS.Application\ApiaryProjectCustomApp\ApiaryActionsService.cs:line 767


3 Answer(s)
  • 0
    ismcagdas created
    Support Team

    Hi @Leonardo.Willrich

    Is it possible to share related app service method code with us as well ?

  • 0
    Leonardo.Willrich created

    Hi,

    It is a huge code that calls several methods from different classes/services. It would be easier having a remote session and I can show where is the entry point and where is the line throwing the exception, if it is possible.

  • 0
    ismcagdas created
    Support Team

    Hi,

    Could you send it to (just the entry app service method will be enough I guess) info@aspnetzero.com ? By the way, it is not a good practice to call one app service from another app service. Since there is interception when calling an app service, it might cause such problems.