MfdsIngredientSyncJob.RunAsync

// Id: #44821
using PurchaseAgent.Slices.Tax.Application.GovApi.Mfds;

var mfdsIngredientSyncJob = Activate<MfdsIngredientSyncJob>();
await mfdsIngredientSyncJob.RunAsync(null);

Parameters

RecurringJobId
"govapi.mfds.sync"
Time
1780855205
CurrentCulture
""
RetryCount
2

State

06/07/2026 18:35:41 (+53ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 76
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 51
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+19ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
7dc4e6df

+29m 59.978s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+3ms Scheduled

Retry attempt 2 of 2: 42P01: relation "cosmetic_ingredients" does not e…

Enqueue at:
06/07/2026 18:35:41

+109ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 76
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 51
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+31ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
7dc4e6df

+5m 3.450s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+11ms Scheduled

Retry attempt 1 of 2: 42P01: relation "cosmetic_ingredients" does not e…

Enqueue at:
06/07/2026 18:05:37

+507ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1)

42P01: relation "cosmetic_ingredients" does not exist POSITION: 122

Npgsql.PostgresException: 42P01: relation "cosmetic_ingredients" does not exist

POSITION: 122
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.UpsertAsync(IReadOnlyList`1 ingredients, CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 76
   at PurchaseAgent.Slices.Tax.Application.GovApi.Mfds.MfdsIngredientSyncJob.RunAsync(CancellationToken ct) in /src/src/PurchaseAgent.Slices.Tax/Application/GovApi/Mfds/MfdsIngredientSyncJob.cs:line 51
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+31.704s Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
7dc4e6df

+5ms Enqueued

Triggered by recurring job scheduler

Queue:
low

06/07/2026 18:00:05 Created