// Id: #13317
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.
Too many connections
MySqlConnector.MySqlException: Too many connections at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 at MySqlConnector.Core.ServerSession.SwitchAuthenticationAsync(ConnectionSettings cs, String password, PayloadData payload, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 672 at MySqlConnector.Core.ServerSession.ConnectAsync(ConnectionSettings cs, MySqlConnection connection, Int64 startingTimestamp, ILoadBalancer loadBalancer, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 537 at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int64 startingTimestamp, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 932 at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int64 startingTimestamp, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 938 at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 419 at Microsoft.EntityFrameworkCore.ServerVersion.AutoDetect(String connectionString) at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.CreateDbContextOptions[TContext](IServiceProvider applicationServiceProvider, Action`2 optionsAction) at ResolveService(ILEmitResolverBuilderRuntimeContext, ServiceProviderEngineScope) at ResolveService(ILEmitResolverBuilderRuntimeContext, ServiceProviderEngineScope) at ResolveService(ILEmitResolverBuilderRuntimeContext, ServiceProviderEngineScope) at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(ServiceIdentifier serviceIdentifier, ServiceProviderEngineScope serviceProviderEngineScope) 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 17 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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. ---> System.IO.IOException: Unable to read data from the transport connection: Operation canceled. ---> System.Net.Sockets.SocketException: Operation canceled --- End of inner exception stack trace --- at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketError error, CancellationToken cancellationToken) at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.Tasks.Sources.IValueTaskSource<System.Int32>.GetResult(Int16 token) at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](CancellationToken cancellationToken, Int32 estimatedSize) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at System.Net.Security.SslStream.ReadAsyncInternal[TIOAdapter](Memory`1 buffer, CancellationToken cancellationToken) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at MySqlConnector.Protocol.Serialization.StreamByteHandler.<ReadBytesAsync>g__DoReadBytesAsync|6_2(Memory`1 buffer) in /_/src/MySqlConnector/Protocol/Serialization/StreamByteHandler.cs:line 67 --- End of inner exception stack trace --- at MySqlConnector.Protocol.Serialization.StreamByteHandler.<ReadBytesAsync>g__DoReadBytesAsync|6_2(Memory`1 buffer) in /_/src/MySqlConnector/Protocol/Serialization/StreamByteHandler.cs:line 75 at MySqlConnector.Protocol.Serialization.BufferedByteReader.ReadBytesAsync(IByteHandler byteHandler, ArraySegment`1 buffer, Int32 totalBytesToRead, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/BufferedByteReader.cs:line 34 at MySqlConnector.Protocol.Serialization.ProtocolUtility.ReadPayloadAsync(BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 421 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 882 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 483 at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56 at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 357 at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 350 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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 908 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 967 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 266 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 172 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)