Hi @lzap
you are right, there were more logs:
Here is before restart httpd:
2018-09-04T11:03:19 [I|app|] Started GET "/api/hosts?search=name+%3D+%22HOSTNAME.DOMAIN%22" for IP_FOREMAN at 2018-09-04 11:03:19 +0900
2018-09-04T11:03:19 [I|app|eb676] Processing by Api::V2::HostsController#index as JSON
2018-09-04T11:03:19 [I|app|eb676] Parameters: {"search"=>"name = \"HOSTNAME.DOMAIN\"", "apiv"=>"v2", "host"=>{}}
2018-09-04T11:03:19 [I|app|eb676] Current user: foreman_admin (administrator)
2018-09-04T11:03:19 [I|app|eb676] Authorized user admin(Admin User)
2018-09-04T11:03:19 [I|app|eb676] Current user: admin (administrator)
2018-09-04T11:03:20 [I|app|eb676] Rendering api/v2/hosts/index.json.rabl within api/v2/layouts/index_layout
2018-09-04T11:03:20 [I|app|eb676] Rendered api/v2/hosts/index.json.rabl within api/v2/layouts/index_layout (71.8ms)
2018-09-04T11:03:20 [I|app|eb676] Completed 200 OK in 257ms (Views: 77.0ms | ActiveRecord: 39.6ms)
2018-09-04T11:03:20 [I|app|] Started DELETE "/api/hosts/103" for IP_FOREMAN at 2018-09-04 11:03:20 +0900
2018-09-04T11:03:20 [I|app|1ce72] Processing by Api::V2::HostsController#destroy as JSON
2018-09-04T11:03:20 [I|app|1ce72] Parameters: {"apiv"=>"v2", "id"=>"103", "host"=>{}}
2018-09-04T11:03:20 [I|app|1ce72] Current user: foreman_admin (administrator)
2018-09-04T11:03:20 [I|app|1ce72] Authorized user admin(Admin User)
2018-09-04T11:03:20 [I|app|1ce72] Current user: admin (administrator)
2018-09-04T11:03:20 [I|kat|1ce72] DELETE: https://FOREMAN.DOMAIN/pulp/api/v2/consumers/9417b8e2-02ce-47d0-aac4-ad85c04d9959/: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 200: null
2018-09-04T11:03:20 [I|aud|1ce72] destroy event for Host::Base with id 84
2018-09-04T11:03:20 [I|aud|1ce72] destroy event for Host::Base with id 101
2018-09-04T11:03:20 [I|aud|1ce72] destroy event for Nic::Managed with id 105
2018-09-04T11:03:20 [I|app|1ce72] Delete the DNS PTR record for IP_VM/HOSTNAME.DOMAIN
2018-09-03T20:58:48 [I|kat|] POST: https://FOREMAN.DOMAIN/pulp/api/v2/consumers/9417b8e2-02ce-47d0-aac4-ad85c04d9959/actions/content/regenerate_applicability/: {}: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 202: {"spawned_tasks": [{"_href": "/pulp/api/v2/tasks/1a2d19e9-1005-4048-afb1-56af80b5ff6f/", "task_id": "1a2d19e9-1005-4048-afb1-56af80b5ff6f"}], "result": null, "error": null}
2018-09-03T20:58:48 [I|kat|] GET: https://FOREMAN.DOMAIN/pulp/api/v2/tasks/1a2d19e9-1005-4048-afb1-56af80b5ff6f/: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 200: {"exception": null, "task_type": "pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers", "_href": "/pulp/api/v2/tasks/1a2d19e9-1005-4048-afb1-56af80b5ff6f/", "task_id": "1a2d19e9-1005-4048-afb1-56af80b5ff6f", "tags": ["pulp:action:consumer_content_applicability_regeneration"], "finish_time": null, "_ns": "task_status", "start_time": null, "traceback": null, "spawned_tasks": [], "progress_report": {}, "queue": "", "state": "waiting", "worker_name": null, "result": null, "error": null, "_id": {"$oid": "5b8d21f8a0719b8099dd05f5"}, "id": "5b8d21f8a0719b8099dd05f5"}
2018-09-03T20:58:48 [I|kat|] GET: https://FOREMAN.DOMAIN/pulp/api/v2/tasks/1a2d19e9-1005-4048-afb1-56af80b5ff6f/: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 200: {"exception": null, "task_type": "pulp.server.managers.consumer.applicability.regenerate_applicability_for_consumers", "_href": "/pulp/api/v2/tasks/1a2d19e9-1005-4048-afb1-56af80b5ff6f/", "task_id": "1a2d19e9-1005-4048-afb1-56af80b5ff6f", "tags": ["pulp:action:consumer_content_applicability_regeneration"], "finish_time": "2018-09-03T11:58:48Z", "_ns": "task_status", "start_time": "2018-09-03T11:58:48Z", "traceback": null, "spawned_tasks": [], "progress_report": {}, "queue": "reserved_resource_worker-2@FOREMAN.DOMAIN.dq2", "state": "finished", "worker_name": "reserved_resource_worker-2@FOREMAN.DOMAIN", "result": null, "error": null, "_id": {"$oid": "5b8d21f8a0719b8099dd05f5"}, "id": "5b8d21f8a0719b8099dd05f5"}
2018-09-03T20:58:48 [I|app|] Current user: foreman_admin (administrator)
2018-09-03T20:58:50 [I|app|] Current user: foreman_admin (administrator)
2018-09-03T20:58:50 [I|kat|] POST: https://FOREMAN.DOMAIN/pulp/api/v2/consumers/content/applicability/: {"criteria":{"filters":{"id":{"$in":["9417b8e2-02ce-47d0-aac4-ad85c04d9959"]}}},"content_types":["erratum"]}: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 200: []
2018-09-03T20:58:50 [I|kat|] POST: https://FOREMAN.DOMAIN/pulp/api/v2/consumers/content/applicability/: {"criteria":{"filters":{"id":{"$in":["9417b8e2-02ce-47d0-aac4-ad85c04d9959"]}}},"content_types":["rpm"]}: {"content_type"=>"application/json", "accept"=>"application/json"}
Response: 200: []
2018-09-03T21:43:13 [I|app|] Current user: foreman_admin (administrator)
2018-09-03T23:17:42 [I|app|] Current user: foreman_admin (administrator)
2018-09-03T23:49:28 [I|app|] Current user: foreman_admin (administrator)
2018-09-04T06:19:50 [I|app|] Performing CreatePulpDiskSpaceNotifications (Job ID: fe24c3e6-1126-484b-bdc2-4c591249e9ed) from Dynflow(default)
2018-09-04T06:19:50 [I|app|] Performing SendExpireSoonNotifications (Job ID: d1b1267d-ef3d-4767-a1b4-a183eba467ad) from Dynflow(default)
2018-09-04T06:19:50 [I|app|] Enqueued SendExpireSoonNotifications (Job ID: 0e5412ed-bca9-4c29-924a-b08529cebe90) to Dynflow(default) at 2018-09-04 09:19:50 UTC
2018-09-04T06:19:50 [I|app|] Performed SendExpireSoonNotifications (Job ID: d1b1267d-ef3d-4767-a1b4-a183eba467ad) from Dynflow(default) in 108.63ms
2018-09-04T06:19:50 [I|app|] Enqueued CreatePulpDiskSpaceNotifications (Job ID: c0c72a77-7ec0-41d8-a3c5-b77b75bc5a4a) to Dynflow(default) at 2018-09-04 09:19:50 UTC
2018-09-04T06:19:50 [I|app|] Performed CreatePulpDiskSpaceNotifications (Job ID: fe24c3e6-1126-484b-bdc2-4c591249e9ed) from Dynflow(default) in 244.77ms
2018-09-04T06:22:52 [I|app|] Performing CreateRssNotifications (Job ID: df30495c-dda5-4af4-90a6-1f44973e5d24) from Dynflow(default)
2018-09-04T06:23:03 [I|app|] Enqueued CreateRssNotifications (Job ID: 6220bc11-2c5b-4316-9848-4f3da9c307c9) to Dynflow(default) at 2018-09-04 09:23:03 UTC
2018-09-04T06:23:03 [I|app|] Performed CreateRssNotifications (Job ID: df30495c-dda5-4af4-90a6-1f44973e5d24) from Dynflow(default) in 10726.67ms
2018-09-04T11:03:21 [I|app|] Current user: foreman_admin (administrator)
2018-09-04T11:03:21 [I|app|] Current user: foreman_admin (administrator)
2018-09-04T11:03:22 [E|dyn|] PG::UndefinedColumn: ERROR: column katello_subscriptions.product_id does not exist
LINE 1: ...katello_subscriptions"."organization_id" = $1 AND "katello_s...
^
: SELECT "katello_subscriptions".* FROM "katello_subscriptions" WHERE "katello_subscriptions"."organization_id" = $1 AND "katello_subscriptions"."product_id" = $2 LIMIT $3
2018-09-04T11:03:22 [E|dyn|] /opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/opt/rh/rh-ruby24/root/usr/share/ruby/monitor.rb:214:in `mon_synchronize'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/database_statements.rb:371:in `select'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/database_statements.rb:42:in `select_all'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/query_cache.rb:95:in `block in select_all'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/query_cache.rb:118:in `block in cache_sql'
/opt/rh/rh-ruby24/root/usr/share/ruby/monitor.rb:214:in `mon_synchronize'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/query_cache.rb:104:in `cache_sql'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/connection_adapters/abstract/query_cache.rb:95:in `select_all'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/querying.rb:39:in `find_by_sql'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation.rb:678:in `exec_queries'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation.rb:546:in `load'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation.rb:255:in `records'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation/finder_methods.rb:508:in `find_take'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation/finder_methods.rb:100:in `take'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/relation/finder_methods.rb:78:in `find_by'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/querying.rb:7:in `find_by'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activerecord-5.1.6/lib/active_record/core.rb:208:in `find_by'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/models/katello/glue/candlepin/pool.rb:85:in `stacking_subscription'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/models/katello/glue/candlepin/pool.rb:104:in `import_data'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/core_ext/object/try.rb:17:in `public_send'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/core_ext/object/try.rb:17:in `try!'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/core_ext/object/try.rb:6:in `try'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/models/katello/events/import_pool.rb:11:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/katello/event_queue/monitor.rb:111:in `block in act_on_event'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:94:in `as'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:100:in `as_anonymous_admin'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/katello/event_queue/monitor.rb:109:in `act_on_event'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/katello/event_queue/monitor.rb:44:in `block in run'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:74:in `block in assigns'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:73:in `tap'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matchers/abstract.rb:73:in `assigns'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matching.rb:56:in `match_value'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matching.rb:36:in `block in match?'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matching.rb:35:in `each'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matching.rb:35:in `match?'
/opt/theforeman/tfm/root/usr/share/gems/gems/algebrick-0.7.3/lib/algebrick/matching.rb:23:in `match'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/katello/event_queue/monitor.rb:36:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:538:in `block (3 levels) in execute_run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/common/singleton.rb:15:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.4/app/lib/actions/middleware/rails_executor_wrap.rb:14:in `block in run'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/activesupport-5.1.6/lib/active_support/execution_wrapper.rb:85:in `wrap'
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.4/app/lib/actions/middleware/rails_executor_wrap.rb:13:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action/progress.rb:30:in `with_progress_calculation'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action/progress.rb:16:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/middleware/keep_locale.rb:11:in `block in run'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/middleware/keep_locale.rb:22:in `with_locale'
/opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/lib/actions/middleware/keep_locale.rb:11:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.4/app/lib/actions/middleware/keep_current_user.rb:15:in `block in run'
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.4/app/lib/actions/middleware/keep_current_user.rb:43:in `restore_curent_user'
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.4/app/lib/actions/middleware/keep_current_user.rb:15:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:26:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:18:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware.rb:31:in `run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/stack.rb:22:in `call'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/middleware/world.rb:30:in `execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:537:in `block (2 levels) in execute_run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:536:in `catch'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:536:in `block in execute_run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:451:in `block in with_error_handling'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:451:in `catch'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:451:in `with_error_handling'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:531:in `execute_run'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/action.rb:278:in `execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:17:in `block (2 levels) in execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/execution_plan/steps/abstract.rb:162:in `with_meta_calculation'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:16:in `block in execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:30:in `open_action'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/execution_plan/steps/abstract_flow_step.rb:15:in `execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/director.rb:56:in `execute'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/executors/parallel/worker.rb:12:in `block in on_message'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/executors.rb:12:in `run_user_code'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/executors/parallel/worker.rb:11:in `on_message'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/context.rb:46:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/executes_context.rb:7:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-1.1.0/lib/dynflow/actor.rb:26:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/awaits.rb:15:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/sets_results.rb:14:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/buffer.rb:38:in `process_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/buffer.rb:31:in `process_envelopes?'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/buffer.rb:20:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/termination.rb:55:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/removes_child.rb:10:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/abstract.rb:25:in `pass'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/behaviour/sets_results.rb:14:in `on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/core.rb:161:in `process_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/core.rb:95:in `block in on_envelope'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/core.rb:118:in `block (2 levels) in schedule_execution'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/synchronization/mri_lockable_object.rb:38:in `block in synchronize'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/synchronization/mri_lockable_object.rb:38:in `synchronize'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/synchronization/mri_lockable_object.rb:38:in `synchronize'
/opt/theforeman/tfm/root/usr/share/gems/gems/concurrent-ruby-edge-0.2.4/lib/concurrent/actor/core.rb:115:in `block in schedule_execution'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/serialized_execution.rb:18:in `call'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/serialized_execution.rb:96:in `work'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/serialized_execution.rb:77:in `block in call_job'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:348:in `run_task'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:337:in `block (3 levels) in create_worker'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:320:in `loop'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:320:in `block (2 levels) in create_worker'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:319:in `catch'
/opt/theforeman/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:319:in `block in create_worker'
/opt/theforeman/tfm/root/usr/share/gems/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
2018-09-04T11:03:35 [I|app|1ce72] Delete DHCP reservation HOSTNAME.DOMAIN for HOSTNAME.DOMAIN-52:54:00:13:44:a0/IP_VM
2018-09-04T11:03:36 [I|app|1ce72] Processed 2 tasks from queue 'Host::Managed Main', completed 2/2
2018-09-04T11:03:36 [I|aud|1ce72] destroy event for Host::Base with id 103
2018-09-04T11:03:36 [I|app|1ce72] Remove puppet certificate for HOSTNAME.DOMAIN
2018-09-04T11:03:38 [I|app|1ce72] Delete realm entry for HOSTNAME.DOMAIN
2018-09-04T11:03:39 [I|app|1ce72] Delete the autosign entry for HOSTNAME.DOMAIN
2018-09-04T11:03:39 [I|app|1ce72] Removing Compute instance for HOSTNAME.DOMAIN
2018-09-04T11:05:21 [I|app|] Started DELETE "/api/hosts/103" for IP_FOREMAN at 2018-09-04 11:05:21 +0900
2018-09-04T11:05:21 [I|app|c4bb7] Processing by Api::V2::HostsController#destroy as JSON
2018-09-04T11:05:21 [I|app|c4bb7] Parameters: {"apiv"=>"v2", "id"=>"103", "host"=>{}}
2018-09-04T11:05:21 [I|app|c4bb7] Current user: foreman_admin (administrator)
2018-09-04T11:05:21 [I|app|c4bb7] Authorized user admin(Admin User)
2018-09-04T11:05:21 [I|app|c4bb7] Current user: admin (administrator)
2018-09-04T11:05:22 [I|aud|c4bb7] destroy event for Nic::Managed with id 105
2018-09-04T11:06:37 [I|app|] Started GET "/node/FOREMAN.DOMAIN?format=yml" for IP_FOREMAN at 2018-09-04 11:06:37 +0900
2018-09-04T11:06:37 [I|app|b7edf] Processing by HostsController#externalNodes as YML
2018-09-04T11:06:37 [I|app|b7edf] Parameters: {"name"=>"FOREMAN.DOMAIN"}
2018-09-04T11:06:37 [I|app|b7edf] Current user: foreman_api_admin (administrator)
2018-09-04T11:06:38 [I|app|b7edf] Rendering text template
2018-09-04T11:06:38 [I|app|b7edf] Rendered text template (0.0ms)
2018-09-04T11:06:38 [I|app|b7edf] Completed 200 OK in 1524ms (Views: 4.8ms | ActiveRecord: 255.8ms)
2018-09-04T11:06:40 [I|app|] Started POST "/api/hosts/facts" for IP_FOREMAN at 2018-09-04 11:06:40 +0900
2018-09-04T11:06:40 [I|app|19605] Processing by Api::V2::HostsController#facts as JSON
2018-09-04T11:06:40 [I|app|19605] Parameters: {"facts"=>"[FILTERED]", "name"=>"FOREMAN.DOMAIN", "certname"=>"FOREMAN.DOMAIN", "apiv"=>"v2", "host"=>{"certname"=>"FOREMAN.DOMAIN", "name"=>"FOREMAN.DOMAIN"}}
2018-09-04T11:06:40 [I|app|19605] Current user: foreman_api_admin (administrator)
2018-09-04T11:06:41 [I|app|19605] Import facts for 'FOREMAN.DOMAIN' completed. Added: 11, Updated: 24, Deleted 0 facts
2018-09-04T11:06:41 [I|app|19605] Completed 201 Created in 1551ms (Views: 11.2ms | ActiveRecord: 317.2ms)
2018-09-04T11:06:44 [I|app|] Started GET "/node/FOREMAN.DOMAIN?format=yml" for IP_FOREMAN at 2018-09-04 11:06:44 +0900
2018-09-04T11:06:44 [I|app|c71de] Processing by HostsController#externalNodes as YML
2018-09-04T11:06:44 [I|app|c71de] Parameters: {"name"=>"FOREMAN.DOMAIN"}
2018-09-04T11:06:44 [I|app|c71de] Current user: foreman_api_admin (administrator)
2018-09-04T11:06:44 [I|app|c71de] Rendering text template
2018-09-04T11:06:44 [I|app|c71de] Rendered text template (0.0ms)
2018-09-04T11:06:44 [I|app|c71de] Completed 200 OK in 203ms (Views: 0.8ms | ActiveRecord: 26.6ms)
2018-09-04T11:06:45 [I|app|] Started POST "/api/config_reports" for IP_FOREMAN at 2018-09-04 11:06:45 +0900
2018-09-04T11:06:45 [I|app|048f6] Processing by Api::V2::ConfigReportsController#create as JSON
2018-09-04T11:06:45 [I|app|048f6] Parameters: {"config_report"=>"[FILTERED]", "apiv"=>"v2"}
2018-09-04T11:06:45 [I|app|048f6] Current user: foreman_api_admin (administrator)
2018-09-04T11:06:45 [I|app|048f6] Scanning report with: Foreman::PuppetReportScanner
2018-09-04T11:06:45 [I|app|048f6] Imported report for FOREMAN.DOMAIN in 0.17 seconds, status refreshed in 0.12 seconds
2018-09-04T11:06:45 [I|app|048f6] Rendering api/v2/config_reports/create.json.rabl
2018-09-04T11:06:45 [I|app|048f6] Rendered api/v2/config_reports/create.json.rabl (21.0ms)
2018-09-04T11:06:45 [I|app|048f6] Completed 201 Created in 357ms (Views: 43.8ms | ActiveRecord: 78.2ms)
and after I restart httpd:
2018-09-04T11:11:57 [I|app|] Started GET "/api/hosts?search=name+%3D+%22HOSTNAME.DOMAIN%22" for IP_FOREMAN at 2018-09-04 11:11:57 +0900
2018-09-04T11:11:57 [I|app|2b5d6] Processing by Api::V2::HostsController#index as JSON
2018-09-04T11:11:57 [I|app|2b5d6] Parameters: {"search"=>"name = \"HOSTNAME.DOMAIN\"", "apiv"=>"v2", "host"=>{}}
2018-09-04T11:11:57 [I|app|2b5d6] Current user: foreman_admin (administrator)
2018-09-04T11:11:57 [I|app|2b5d6] Authorized user admin(Admin User)
2018-09-04T11:11:57 [I|app|2b5d6] Current user: admin (administrator)
2018-09-04T11:11:58 [I|app|2b5d6] Rendering api/v2/hosts/index.json.rabl within api/v2/layouts/index_layout
2018-09-04T11:11:59 [I|app|2b5d6] Rendered api/v2/hosts/index.json.rabl within api/v2/layouts/index_layout (239.1ms)
2018-09-04T11:11:59 [I|app|2b5d6] Completed 200 OK in 1197ms (Views: 228.8ms | ActiveRecord: 185.3ms)
2018-09-04T11:12:01 [I|app|] Started DELETE "/api/hosts/103" for IP_FOREMAN at 2018-09-04 11:12:01 +0900
2018-09-04T11:12:01 [I|app|89759] Processing by Api::V2::HostsController#destroy as JSON
2018-09-04T11:12:01 [I|app|89759] Parameters: {"apiv"=>"v2", "id"=>"103", "host"=>{}}
2018-09-04T11:12:01 [I|app|89759] Current user: foreman_admin (administrator)
2018-09-04T11:12:01 [I|app|89759] Authorized user admin(Admin User)
2018-09-04T11:12:01 [I|app|89759] Current user: admin (administrator)
2018-09-04T11:12:01 [I|aud|89759] destroy event for Nic::Managed with id 105
2018-09-04T11:12:01 [I|app|89759] Delete the DNS PTR record for IP_VM/HOSTNAME.DOMAIN
2018-09-04T11:12:09 [I|app|89759] Delete DHCP reservation HOSTNAME.DOMAIN for HOSTNAME.DOMAIN-52:54:00:13:44:a0/IP_VM
2018-09-04T11:12:09 [I|app|89759] Processed 2 tasks from queue 'Host::Managed Main', completed 2/2
2018-09-04T11:12:09 [I|aud|89759] destroy event for Host::Base with id 103
2018-09-04T11:12:10 [I|app|89759] Remove puppet certificate for HOSTNAME.DOMAIN
2018-09-04T11:12:12 [I|app|89759] Delete realm entry for HOSTNAME.DOMAIN
2018-09-04T11:12:12 [I|app|89759] Delete the autosign entry for HOSTNAME.DOMAIN
2018-09-04T11:12:12 [I|app|89759] Removing Compute instance for HOSTNAME.DOMAIN
2018-09-04T11:12:14 [I|app|89759] Processed 4 tasks from queue 'Host::Managed Main', completed 6/6
2018-09-04T11:12:14 [I|app|89759] Completed 200 OK in 13065ms (Views: 18.0ms | ActiveRecord: 131.2ms)
probably the relevant part is:
2018-09-04T11:03:22 [E|dyn|] PG::UndefinedColumn: ERROR: column katello_subscriptions.product_id does not exist
LINE 1: ...katello_subscriptions"."organization_id" = $1 AND "katello_s...
^
: SELECT "katello_subscriptions".* FROM "katello_subscriptions" WHERE "katello_subscriptions"."organization_id" = $1 AND "katello_subscriptions"."product_id" = $2 LIMIT $3
About libvirt yes, we are using it.
About katello subscriptions I remember that I’ve uploaded the manifest and an error popped up:
Import Manifest organization
Validation failed: Environments expecting environments used by hosts or inherited (check mismatches report)., Domains expecting domains used by hosts or inherited (check mismatches report)., Smart proxies expecting smart proxies used by hosts or inherited (check mismatches report).
This error did not popped up with foreman 1.17 and ignored since I can download rhel repos anyway.
Thanks for the help,
Alex