MfdsIngredientSyncJob.RunAsync

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

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

Parameters

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

State

05/31/2026 18:35:59 (+181ms) Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-5779d66576-hdvtq: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)

+31ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-5779d66576-hdvtq:1
Worker:
35c93ce7

+30m 3.681s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+7ms Scheduled

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

Enqueue at:
05/31/2026 18:35:55

+302ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-6bc6598b87-65hjf: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 System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Object obj, IntPtr* args)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+154ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-6bc6598b87-65hjf:1
Worker:
d940f008

+5m 53.131s Enqueued

Triggered by DelayedJobScheduler

Queue:
low

+6ms Scheduled

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

Enqueue at:
05/31/2026 18:05:01

+124ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (purchaseagent@purchaseagent-purchaseagent-6cfc56fdcc-jvq7n: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)

+867ms Processing

Server:
purchaseagent@purchaseagent-purchaseagent-6cfc56fdcc-jvq7n:1
Worker:
72ffd1c3

+5ms Enqueued

Triggered by recurring job scheduler

Queue:
low

05/31/2026 18:00:00 Created