DashboardKrSnapshotRecalcJob.ExecuteAsync

03/27/2026 15:43:04 (+412ms) Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (21543815c651:1)

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)

+2.711s Processing

Server:: 21543815c651:1
Worker:: 9b081600

+1h 50m Enqueued

Triggered by DelayedJobScheduler

+9ms Scheduled

Retry attempt 10 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 15:43:16

+8.184s Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (21543815c651:1)

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)

+14.728s Processing

Server:: 21543815c651:1
Worker:: 9b081600

+40m 20.672s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

Retry attempt 8 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 13:52:26

+89ms Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (e1bd47cb1600:1)

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)

+5.750s Processing

Server:: e1bd47cb1600:1
Worker:: d7dc4e90

+23m 10.950s Enqueued

Triggered by DelayedJobScheduler

+34ms Scheduled

Retry attempt 7 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 13:11:31

+6.208s Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (e1bd47cb1600:1)

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)

+14.779s Processing

Server:: e1bd47cb1600:1
Worker:: d7dc4e90

+12m 48.035s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 6 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 12:47:37

+122ms Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

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)

+3.607s Processing

Server:: 47068fab608f:1
Worker:: 60a1622d

+6m 11.713s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 5 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 12:35:31

+86ms Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

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)

+3.984s Processing

Server:: 47068fab608f:1
Worker:: 837dd749

+1m 48.015s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 4 of 10: Cannot add or update a child row: a foreign key c…

Enqueue at:: 03/27/2026 12:29:45

+23.466s Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

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)

+3.936s Processing

Server:: 47068fab608f:1
Worker:: aa3c7c2d

+1m 6.842s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 3 of 10: Deadlock found when trying to get lock; try resta…

Enqueue at:: 03/27/2026 12:26:16

+49.108s Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

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)

+4.308s Processing

Server:: 47068fab608f:1
Worker:: 7f2e183b

+41.155s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

Retry attempt 2 of 10: The Command Timeout expired before the operation …

Enqueue at:: 03/27/2026 12:24:24

+1m 120ms Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

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)

+4.126s Processing

Server:: 47068fab608f:1
Worker:: a8c3d758

+6.504s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 1 of 10: Lock wait timeout exceeded; try restarting transa…

Enqueue at:: 03/27/2026 12:23:20

+55.321s Failed

An exception occurred during performance of the job.

MySqlConnector.MySqlException (47068fab608f:1)

Lock wait timeout exceeded; try restarting transaction

MySqlConnector.MySqlException: Lock wait timeout exceeded; 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)

+2.201s Processing

Server:: 47068fab608f:1
Worker:: ecdcf0c4

CurrentCulture	`"pt-BR"`
CurrentUICulture	`"pt-BR"`
RetryCount	`10`

DashboardKrSnapshotRecalcJob.ExecuteAsync

Parameters

Requeue Delete State

03/27/2026 15:43:04 (+412ms) Failed

MySqlConnector.MySqlException (21543815c651:1)

+2.711s Processing

+1h 50m Enqueued

+9ms Scheduled

+8.184s Failed

MySqlConnector.MySqlException (21543815c651:1)

+14.728s Processing

+40m 20.672s Enqueued

+5ms Scheduled

+89ms Failed

MySqlConnector.MySqlException (e1bd47cb1600:1)

+5.750s Processing

+23m 10.950s Enqueued

+34ms Scheduled

+6.208s Failed

MySqlConnector.MySqlException (e1bd47cb1600:1)

+14.779s Processing

+12m 48.035s Enqueued

+7ms Scheduled

+122ms Failed

MySqlConnector.MySqlException (47068fab608f:1)

+3.607s Processing

+6m 11.713s Enqueued

+7ms Scheduled

+86ms Failed

MySqlConnector.MySqlException (47068fab608f:1)

+3.984s Processing

+1m 48.015s Enqueued

+7ms Scheduled

+23.466s Failed

MySqlConnector.MySqlException (47068fab608f:1)

+3.936s Processing

+1m 6.842s Enqueued

+7ms Scheduled

+49.108s Failed

MySqlConnector.MySqlException (47068fab608f:1)

+4.308s Processing

+41.155s Enqueued

+5ms Scheduled

+1m 120ms Failed

MySqlConnector.MySqlException (47068fab608f:1)

+4.126s Processing

+6.504s Enqueued

+6ms Scheduled

+55.321s Failed

MySqlConnector.MySqlException (47068fab608f:1)

+2.201s Processing

+111ms Enqueued

03/27/2026 12:21:56 Created

State