Hangfire Dashboard

NotificarPromocaoJob.ExecuteAsync

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

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

Parameters

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

State

07/10/2026 23:32:32 (+108ms) Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (c94a1d8a9b70: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 781
   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 878
   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)

+14.372s Processing

Server:
c94a1d8a9b70:1
Worker:
a0f698ef

+1h 52m Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/10/2026 23:33:13

+108ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (c94a1d8a9b70: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 781
   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 878
   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)

+13.371s Processing

Server:
c94a1d8a9b70:1
Worker:
a6ad4f41

+1h 12m Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

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

Enqueue at:
07/10/2026 21:39:06

+134ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (c94a1d8a9b70: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 781
   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 878
   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)

+10.729s Processing

Server:
c94a1d8a9b70:1
Worker:
fe248ba4

+40m 23.275s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/10/2026 20:27:29

+240ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (02068b0218cd: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 781
   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 878
   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)

+7.844s Processing

Server:
02068b0218cd:1
Worker:
a470dc57

+23m 14.628s Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

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

Enqueue at:
07/10/2026 19:46:38

+532ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (02068b0218cd: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 781
   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 878
   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.396s Processing

Server:
02068b0218cd:1
Worker:
e661d144

+12m 47.076s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/10/2026 19:21:57

+271ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (be8f0fb65045: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 781
   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 878
   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)

+10.824s Processing

Server:
be8f0fb65045:1
Worker:
a37a1fdf

+6m 6.323s Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

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

Enqueue at:
07/10/2026 19:10:24

+360ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (be8f0fb65045: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 781
   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 878
   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)

+10.547s Processing

Server:
be8f0fb65045:1
Worker:
a37a1fdf

+4m 5.887s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/10/2026 19:02:55

+347ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (1498d4e89600: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 781
   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 878
   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.642s Processing

Server:
1498d4e89600:1
Worker:
01bef9fc

+1m 39.621s Enqueued

Triggered by DelayedJobScheduler

+13ms Scheduled

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

Enqueue at:
07/10/2026 18:58:16

+264ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (1498d4e89600: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 781
   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 878
   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.910s Processing

Server:
1498d4e89600:1
Worker:
f8043c8a

+9.050s Enqueued

Triggered by DelayedJobScheduler

+8ms Scheduled

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

Enqueue at:
07/10/2026 18:57:56

+312ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (1498d4e89600: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 781
   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 878
   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.946s Processing

Server:
1498d4e89600:1
Worker:
8e2d626e

+6.943s Enqueued

Triggered by DelayedJobScheduler

+6ms Scheduled

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

Enqueue at:
07/10/2026 18:57:54

+185ms Failed

An exception occurred during performance of the job.

Microsoft.EntityFrameworkCore.DbUpdateException (1498d4e89600: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 781
   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 878
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at PD_Api.Jobs.NotificarPromocaoJob.ExecuteAsync(UInt32 projetoId, UInt32 usuarioPromotorId, UInt32 empresaId, String faseDestino) in /home/vsts/work/1/s/PD_Api/Jobs/NotificarPromocaoJob.cs:line 61
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.214s Processing

Server:
1498d4e89600:1
Worker:
28f5bf78

+29ms Enqueued

07/10/2026 18:57:15 Created