NotificarPromocaoJob.ExecuteAsync

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

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

Parameters

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

State

07/19/2026 08:38:36 (+102ms) 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)

+323ms Processing

Server:
b9eba6ccb994:1
Worker:
0c04f40f

+1h 50m 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:39:20

+103ms 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)

+12.242s Processing

Server:
b9eba6ccb994:1
Worker:
bd89758b

+1h 12m Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 06:46:40

+153ms 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.631s Processing

Server:
b9eba6ccb994:1
Worker:
cf12c68d

+44m 38.566s 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:34:03

+113ms 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)

+9.703s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+23m 25.390s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

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

Enqueue at:
07/19/2026 04:49:32

+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)

+6.296s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+12m 41.240s 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:27:02

+243ms 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)

+4.932s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+6m 26.042s Enqueued

Triggered by DelayedJobScheduler

+5ms Scheduled

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

Enqueue at:
07/19/2026 04:13:39

+239ms 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)

+4.275s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+3m 40.901s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 04:07:00

+108ms 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)

+4.332s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+10.751s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

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

+108ms 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)

+4.227s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+10.988s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 04:03:45

+103ms 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.988s Processing

Server:
b9eba6ccb994:1
Worker:
8c96ae2f

+32.379s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/19/2026 04:03:11

+104ms 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.571s Processing

Server:
b9eba6ccb994:1
Worker:
cf12c68d

+505ms Enqueued

07/19/2026 04:02:34 Created