// Id: #8033
using PD_Api.Jobs;
var dashboardKrSnapshotRecalcJob = Activate<DashboardKrSnapshotRecalcJob>();
await dashboardKrSnapshotRecalcJob.ExecuteAsync(40, 173, 884);
| CurrentCulture | |
| CurrentUICulture | |
| RetryCount | |
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 10 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 9 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 8 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 7 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 6 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 5 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 4 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 3 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 2 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 1 of 10: The Command Timeout expired before the operation …
An exception occurred during performance of the job.
The Command Timeout expired before the operation completed.
MySqlConnector.MySqlException: The Command Timeout expired before the operation completed. ---> MySqlConnector.MySqlException: Query execution was interrupted at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 244 --- End of inner exception stack trace --- at MySqlConnector.Core.ResultSet.ScanRowAsync(IOBehavior ioBehavior, Row row, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 252 at MySqlConnector.Core.ResultSet.ReadAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ResultSet.cs:line 207 at MySqlConnector.MySqlDataReader.ReadAsync(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 38 at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.LancamentoRep.GetDadosBrutosPlanejadosKr9Async(List`1 projetosVersaoIds, Nullable`1 ano) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 896 at PD_Api.Infraestructure.Repository.LancamentoRep.GetIndicadorKr9(List`1 projetosIds, Nullable`1 ano, String cacheTag, List`1 projetosVersaoIds) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/Lancamento/LancamentoRep.cs:line 955 at PD_Api.Services.DashboardKr.DashboardKrService.CalcularIndiceAmpereCoreSemCacheAsync(List`1 projetosIds, Nullable`1 ano, List`1 projetosVersaoIds, CancellationToken cancellationToken, Nullable`1 empresaId) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 295 at PD_Api.Services.DashboardKr.DashboardKrService.RecalcularEmpresaAsync(UInt32 empresaId, Usuario usuario, IReadOnlyList`1 projetoIds, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Services/DashboardKr/DashboardKrService.cs:line 190 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 usuarioIniciadorId, Nullable`1 projetoId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)