Hangfire Dashboard

NotificarPromocaoJob.ExecuteAsync

The job is finished. It will be removed automatically 01/01/0001 00:00:00. 
// Id: #46844
using PD_Api.Jobs;

var notificarPromocaoJob = Activate<NotificarPromocaoJob>();
await notificarPromocaoJob.ExecuteAsync(951, 86, 40, "Projeto");

Parameters

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

State

07/17/2026 00:42:52 (+235ms) Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.003s Processing

Server:
82ebd4e45f48:1
Worker:
ad0b5f9e

+1h 53m Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 10 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/17/2026 00:42:29

+104ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.527s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+1h 10m Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 9 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 22:50:27

+108ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.520s Processing

Server:
82ebd4e45f48:1
Worker:
5882e6f2

+44m 44.683s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

Retry attempt 8 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 21:38:44

+103ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3.718s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+23m 28.680s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 7 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:55:22

+109ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3.036s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+12m 43.501s Enqueued

Triggered by DelayedJobScheduler

+9ms Scheduled

Retry attempt 6 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:30:33

+107ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.950s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+4m 12.232s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 5 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:18:43

+103ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3.030s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+4m 12.681s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 4 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:13:18

+105ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.595s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+2m 12.901s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 3 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:09:11

+102ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.344s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+1m 57.786s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

Retry attempt 2 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:06:24

+106ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.329s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+1m 27.970s Enqueued

Triggered by DelayedJobScheduler

+52ms Scheduled

Retry attempt 1 of 10: An error occurred while saving the entity changes…

Enqueue at:
07/16/2026 20:04:35

+434ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (82ebd4e45f48:1)

An error occurred while saving the entity changes. See the inner exception for details.

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> MySqlConnector.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`smartpdi_homolog`.`notificacao`, CONSTRAINT `fk_notificacao_notificacao_origem` FOREIGN KEY (`notificacao_origem_id`) REFERENCES `notificacao_origem` (`notificacao_origem_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.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.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, 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.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at PD_Api.Infraestructure.Context.MainDBContext.SaveChangesAsync(CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 788
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 62
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Infraestructure.Context.MainDBContext.RunInTransactionAsync(Func`1 operations, Func`1 errorCallback, CancellationToken cancellationToken) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 68
   at PD_Api.Jobs.NotificarPromocaoJob.<>c__DisplayClass3_1.<<ExecuteAsync>b__0>d.MoveNext() in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 100
--- End of stack trace from previous location ---
   at PD_Api.Infraestructure.Context.MainDBContext.ExecturaComOutraEmpresaAsync(UInt32 outraEmpresaId, Func`1 func) in /home/vsts/work/1/s/PD_Api/Infraestructure/Context/MainDBContext.cs:line 885
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.332s Processing

Server:
82ebd4e45f48:1
Worker:
6815b562

+27ms Enqueued

07/16/2026 20:03:57 Created