// Id: #1145
using PD_Api.Jobs;
var dashboardKrSnapshotRecalcJob = Activate<DashboardKrSnapshotRecalcJob>();
await dashboardKrSnapshotRecalcJob.ExecuteAsync(233, 856, 1);
| CurrentCulture | |
| CurrentUICulture | |
| RetryCount | |
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Cannot add or update a child row: a foreign key c…
An exception occurred during performance of the job.
Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`))
MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`dashboard_kr_projeto_empresa`, CONSTRAINT `fk_dashboard_kr_projeto` FOREIGN KEY (`projeto_id`) REFERENCES `projeto` (`projeto_id`)) at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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: Deadlock found when trying to get lock; try resta…
An exception occurred during performance of the job.
Deadlock found when trying to get lock; try restarting transaction
MySqlConnector.MySqlException: Deadlock found when trying to get lock; try restarting transaction at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 894 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 --- End of inner exception stack trace --- at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 124 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 --- End of inner exception stack trace --- at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 124 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.ExecuteNonQueryAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 309 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRawAsync(DatabaseFacade databaseFacade, String sql, IEnumerable`1 parameters, CancellationToken cancellationToken) at PD_Api.Infraestructure.Repository.DashboardKrProjetoEmpresaRep.UpsertSnapshotAsync(DashboardKrProjetoEmpresaSnapshotDto row, Nullable`1 usuarioAuditoriaId, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Repository/DashboardKrProjetoEmpresaRep.cs:line 132 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 122 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) in /home/vsts/work/1/s/PD_Api/Jobs/DashboardKrSnapshotRecalcJob.cs:line 45 at PD_Api.Jobs.DashboardKrSnapshotRecalcJob.ExecuteAsync(UInt32 empresaId, Nullable`1 projetoId, Nullable`1 usuarioIniciadorId) 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)