Description of problem:

Generate applicability tasks go into 'paused' / 'error' state with error:

ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR: insert or update on table "katello_content_facet_errata" violates foreign key constraint "katello_content_facet_errata_ca_id"
DETAIL: Key (content_facet_id)=(16092) is not present in table "katello_content_facets".

Bulk generate applicability for host paused error April 23, 2023 at 07:57:20 PM
Bulk generate applicability for host paused error April 22, 2023 at 08:00:28 PM
Bulk generate applicability for hosts paused error April 22, 2023 at 08:00:13 PM
Bulk generate applicability for hosts paused error April 22, 2023 at 07:59:58 PM

—

• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:675:in
  `async_exec_params'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:675:in
  `block (2 levels) in exec_no_cache'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/dependencies/interlock.rb:48:in
  `block in permit_concurrent_loads'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/share_lock.rb:187:in
  `yield_shares'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/dependencies/interlock.rb:47:in
  `permit_concurrent_loads'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:674:in
  `block in exec_no_cache'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract_adapter.rb:728:in
  `block (2 levels) in log'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in
  `block (2 levels) in synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in
  `handle_interrupt'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in
  `block in synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in
  `handle_interrupt'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in
  `synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract_adapter.rb:727:in
  `block in log'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/notifications/instrumenter.rb:24:in
  `instrument'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract_adapter.rb:718:in
  `log'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:673:in
  `exec_no_cache'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
  `execute_and_clear'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in
  `exec_query'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/database_statements.rb:153:in
  `exec_insert_all'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/query_cache.rb:22:in
  `exec_insert_all'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/insert_all.rb:27:in
  `execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/persistence.rb:243:in
  `upsert_all'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/services/katello/applicability/applicable_content_helper.rb:162:in
  `insert'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/services/katello/applicability/applicable_content_helper.rb:16:in
  `block in calculate_and_import'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in
  `block in transaction'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in
  `block in within_new_transaction'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in
  `block (2 levels) in synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in
  `handle_interrupt'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in
  `block in synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in
  `handle_interrupt'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in
  `synchronize'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in
  `within_new_transaction'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in
  `transaction'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.4.7/lib/active_record/transactions.rb:212:in
  `transaction'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/services/katello/applicability/applicable_content_helper.rb:15:in
  `calculate_and_import'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/models/katello/host/content_facet.rb:109:in
  `calculate_and_import_applicability'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/lib/actions/katello/applicability/hosts/bulk_generate.rb:14:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/lib/actions/katello/applicability/hosts/bulk_generate.rb:11:in
  `each'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/katello-4.3.0.50/app/lib/actions/katello/applicability/hosts/bulk_generate.rb:11:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:582:in
  `block (3 levels) in execute_run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/rails_executor_wrap.rb:14:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.4.7/lib/active_support/execution_wrapper.rb:91:in
  `wrap'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/rails_executor_wrap.rb:13:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action/progress.rb:31:in
  `with_progress_calculation'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action/progress.rb:17:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/load_setting_values.rb:20:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_request_id.rb:15:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_request_id.rb:52:in
  `restore_current_request_id'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_request_id.rb:15:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_timezone.rb:15:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_timezone.rb:44:in
  `restore_curent_timezone'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_timezone.rb:15:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_taxonomies.rb:15:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_taxonomies.rb:45:in
  `restore_current_taxonomies'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_taxonomies.rb:15:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:32:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:27:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware.rb:19:in
  `pass'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_user.rb:15:in
  `block in run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_user.rb:54:in
  `restore_curent_user'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-5.2.3/app/lib/actions/middleware/keep_current_user.rb:15:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/stack.rb:23:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/middleware/world.rb:31:in
  `execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:581:in
  `block (2 levels) in execute_run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:580:in
  `catch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:580:in
  `block in execute_run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:483:in
  `block in with_error_handling'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:483:in
  `catch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:483:in
  `with_error_handling'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:575:in
  `execute_run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/action.rb:296:in
  `execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:18:in
  `block (2 levels) in execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/execution_plan/steps/abstract.rb:167:in
  `with_meta_calculation'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:17:in
  `block in execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:32:in
  `open_action'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:16:in
  `execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/director.rb:69:in
  `execute'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors/sidekiq/worker_jobs.rb:11:in
  `block (2 levels) in perform'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors.rb:18:in
  `run_user_code'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors/sidekiq/worker_jobs.rb:9:in
  `block in perform'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors/sidekiq/worker_jobs.rb:25:in
  `with_telemetry'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors/sidekiq/worker_jobs.rb:8:in
  `perform'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.6.4/lib/dynflow/executors/sidekiq/serialization.rb:27:in
  `perform'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:192:in
  `execute_job'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:165:in
  `block (2 levels) in process'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/middleware/chain.rb:128:in
  `block in invoke'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/middleware/chain.rb:133:in
  `invoke'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:164:in
  `block in process'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:137:in
  `block (6 levels) in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/job_retry.rb:109:in
  `local'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:136:in
  `block (5 levels) in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq.rb:37:in
  `block in '"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:132:in
  `block (4 levels) in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:250:in
  `stats'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:127:in
  `block (3 levels) in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/job_logger.rb:8:in
  `call'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:126:in
  `block (2 levels) in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/job_retry.rb:74:in
  `global'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:125:in
  `block in dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/logging.rb:48:in
  `with_context'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/logging.rb:42:in
  `with_job_hash_context'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:124:in
  `dispatch'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:163:in
  `process'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:83:in
  `process_one'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/processor.rb:71:in
  `run'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/util.rb:16:in
  `watchdog'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/sidekiq-5.2.10/lib/sidekiq/util.rb:25:in
  `block in safe_thread'"
• "/opt/theforeman/tfm/root/usr/share/gems/gems/logging-2.3.0/lib/logging/diagnostic_context.rb:474:in
  `block in create_with_logging_context'"

Version-Release number of selected component (if applicable):

Satellite-6.11.4-2