Skip to content

Instantly share code, notes, and snippets.

@agrare
Created September 27, 2018 15:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save agrare/290494729ce09ac734865269ed92d1d1 to your computer and use it in GitHub Desktop.
Save agrare/290494729ce09ac734865269ed92d1d1 to your computer and use it in GitHub Desktop.
[----] I, [2018-09-27T10:58:32.002812 #30383:2add769085d4] INFO -- : EMS: [ems_0000000000001], id: [41000000000517] Saving EMS Inventory...
[----] E, [2018-09-27T10:58:32.092405 #30383:2add769085d4] ERROR -- : Error when saving InventoryCollection:<GuestDevice>, strategy: local_db_find_missing_references with strategy: local_db_find_missing_references, saver_strategy: default, targeted: true. Message: PG::UndefinedColumn: ERROR: column lans.switch does not exist
LINE 1: ... = "hosts"."id" WHERE "hosts"."ems_id" = $1 AND (("lans"."sw...
^
HINT: Perhaps you meant to reference the column "lans.switch_id".
: SELECT DISTINCT "lans".* FROM "lans" INNER JOIN "switches" ON "lans"."switch_id" = "switches"."id" INNER JOIN "host_switches" ON "switches"."id" = "host_switches"."switch_id" INNER JOIN "hosts" ON "host_switches"."host_id" = "hosts"."id" WHERE "hosts"."ems_id" = $1 AND (("lans"."switch" IS NULL AND "lans"."uid_ems" = 'dvportgroup-69') OR ("lans"."switch" IS NULL AND "lans"."uid_ems" = 'dvportgroup-69')) ORDER BY "lans"."id" ASC LIMIT $2
[----] E, [2018-09-27T10:58:32.092505 #30383:2add769085d4] ERROR -- : MIQ(ManageIQ::Providers::Vmware::InfraManager::Inventory::Saver#save_inventory) EMS: [ems_0000000000001], id: [41000000000517] Save Inventory failed
[----] E, [2018-09-27T10:58:32.092606 #30383:2add769085d4] ERROR -- : [ActiveRecord::StatementInvalid]: PG::UndefinedColumn: ERROR: column lans.switch does not exist
LINE 1: ... = "hosts"."id" WHERE "hosts"."ems_id" = $1 AND (("lans"."sw...
^
HINT: Perhaps you meant to reference the column "lans.switch_id".
: SELECT DISTINCT "lans".* FROM "lans" INNER JOIN "switches" ON "lans"."switch_id" = "switches"."id" INNER JOIN "host_switches" ON "switches"."id" = "host_switches"."switch_id" INNER JOIN "hosts" ON "host_switches"."host_id" = "hosts"."id" WHERE "hosts"."ems_id" = $1 AND (("lans"."switch" IS NULL AND "lans"."uid_ems" = 'dvportgroup-69') OR ("lans"."switch" IS NULL AND "lans"."uid_ems" = 'dvportgroup-69')) ORDER BY "lans"."id" ASC LIMIT $2 Method:[block (2 levels) in <class:LogProxy>]
[----] E, [2018-09-27T10:58:32.092649 #30383:2add769085d4] ERROR -- : /home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `async_exec'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `block in exec_no_cache'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:590:in `block in log'
/home/agrare/.gem/gems/activesupport-5.0.7/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/abstract_adapter.rb:583:in `log'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `exec_no_cache'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/postgresql_adapter.rb:589:in `execute_and_clear'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/postgresql/database_statements.rb:103:in `exec_query'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:373:in `select'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:41:in `select_all'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/connection_adapters/abstract/query_cache.rb:95:in `select_all'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/querying.rb:39:in `find_by_sql'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation.rb:706:in `exec_queries'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/association_relation.rb:32:in `exec_queries'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation.rb:583:in `load'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation.rb:260:in `records'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation/batches.rb:200:in `block in in_batches'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation/batches.rb:198:in `loop'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation/batches.rb:198:in `in_batches'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation/batches.rb:120:in `find_in_batches'
/home/agrare/.gem/gems/activerecord-5.0.7/lib/active_record/relation/batches.rb:58:in `find_each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/index/type/local_db.rb:110:in `populate_index!'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/index/type/local_db.rb:41:in `find'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/index/proxy.rb:160:in `local_db_index_find'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/index/proxy.rb:91:in `find'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection.rb:115:in `find'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_object_lazy.rb:148:in `load_object'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_object_lazy.rb:50:in `load'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_object.rb:62:in `block in attributes'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_object.rb:49:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_object.rb:49:in `attributes'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/saver/base.rb:136:in `block in save!'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/data_storage.rb:11:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection/data_storage.rb:11:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/inventory_collection.rb:92:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/saver/base.rb:135:in `save!'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/saver/base.rb:84:in `save_inventory_collection!'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/base.rb:37:in `save_inventory'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/base.rb:24:in `save_inventory_object_inventory'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:29:in `block (2 levels) in save_collections'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:28:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:28:in `block in save_collections'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:26:in `each'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:26:in `each_with_index'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_collection/topological_sort.rb:26:in `save_collections'
/home/agrare/.gem/gems/inventory_refresh-0.1.1/lib/inventory_refresh/save_inventory.rb:24:in `save_inventory'
/home/agrare/src/manageiq/manageiq/app/models/manageiq/providers/inventory/persister.rb:29:in `persist!'
/home/agrare/src/manageiq/manageiq-providers-vmware/app/models/manageiq/providers/vmware/infra_manager/inventory/saver.rb:86:in `save_inventory'
/home/agrare/src/manageiq/manageiq-providers-vmware/app/models/manageiq/providers/vmware/infra_manager/inventory/saver.rb:42:in `queue_save_inventory'
/home/agrare/src/manageiq/manageiq-providers-vmware/app/models/manageiq/providers/vmware/infra_manager/inventory/collector.rb:228:in `save_inventory'
/home/agrare/src/manageiq/manageiq-providers-vmware/spec/models/manageiq/providers/vmware/infra_manager/inventory/collector_spec.rb:137:in `run_targeted_refresh'
/home/agrare/src/manageiq/manageiq-providers-vmware/spec/models/manageiq/providers/vmware/infra_manager/inventory/collector_spec.rb:53:in `block (4 levels) in <top (required)>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment