NotificarPromocaoJob.ExecuteAsync

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

var notificarPromocaoJob = Activate<NotificarPromocaoJob>();
await notificarPromocaoJob.ExecuteAsync(1279, 100, 40, "Chamada");

Parameters

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

State

07/19/2026 08:10:49 (+242ms) Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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)

+218ms Processing

Server:
b9eba6ccb994:1
Worker:
cf12c68d

+1h 52m Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 08:10:17

+105ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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)

+11.841s Processing

Server:
b9eba6ccb994:1
Worker:
99570357

+1h 10m Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

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

Enqueue at:
07/19/2026 06:18:07

+106ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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)

+11.248s Processing

Server:
b9eba6ccb994:1
Worker:
ee4e4dbd

+40m 26.880s Enqueued

Triggered by DelayedJobScheduler

+9ms Scheduled

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

Enqueue at:
07/19/2026 05:07:56

+100ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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)

+6.168s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+23m 28.543s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

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

Enqueue at:
07/19/2026 04:27:42

+106ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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.858s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+12m 42.051s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 04:02:41

+214ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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.720s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+6m 12.285s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 03:49:36

+100ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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.128s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+1m 57.079s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

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

Enqueue at:
07/19/2026 03:43:51

+125ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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.008s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+12.061s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

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

Enqueue at:
07/19/2026 03:42:54

+100ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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 System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.916s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+1m 57.206s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 03:40:57

+106ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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.891s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+34.457s Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

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

Enqueue at:
07/19/2026 03:39:44

+151ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (b9eba6ccb994: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_dev`.`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 789
   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 886
   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)

+5.302s Processing

Server:
b9eba6ccb994:1
Worker:
cf12c68d

+480ms Enqueued

07/19/2026 03:39:16 Created