MfdsIngredientSyncJob.RunAsync

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

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

Parameters

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

State

06/21/2026 18:35:38 (+36ms) 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)

+32ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
b5dca4b1

+30m 9ms Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+3ms Scheduled

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

Enqueue at:
06/21/2026 18:35:38

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

+33ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
b5dca4b1

+5m 3.212s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+45ms Scheduled

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

Enqueue at:
06/21/2026 18:05:35

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

+33.152s Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5b5797cfc9-h55ft:1
Worker:
b5dca4b1

+5ms Enqueued

Triggered by recurring job scheduler

Queue:
low

06/21/2026 18:00:01 Created