Bug 1782886

Summary:	no vm displayed - multiple relationships found
Product:	Red Hat CloudForms Management Engine	Reporter:	Felix Dewaleyne <fdewaley>
Component:	Providers	Assignee:	Adam Grare <agrare>
Status:	CLOSED INSUFFICIENT_DATA	QA Contact:	Sudhir Mallamprabhakara <smallamp>
Severity:	urgent	Docs Contact:	Red Hat CloudForms Documentation <cloudforms-docs>
Priority:	urgent
Version:	5.9.4	CC:	agrare, dmetzger, fdewaley, jfrey, jhardy, obarenbo
Target Milestone:	GA
Target Release:	cfme-future
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-12-17 16:38:13 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Felix Dewaleyne 2019-12-12 15:00:32 UTC

Description of problem:
no vm displayed in vm infrastructure (classic ui) with multiple relationship error

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

How reproducible:
customer environment

Steps to Reproduce:
1. log in as user
2. go to vm infrastructure explorer


Actual results:
error is raised
[----] I, [2019-12-12T08:12:19.632529 #7409:112c5b8]  INFO -- : Started GET "/vm_infra/explorer" for 127.0.0.1 at 2019-12-12 08:12:19 +0100
[----] I, [2019-12-12T08:12:19.634774 #7409:112c5b8]  INFO -- : Processing by VmInfraController#explorer as HTML
[...]
[----] I, [2019-12-12T08:12:19.753256 #7417:11027e0]  INFO -- : Completed 200 OK in 33ms (Views: 0.2ms | ActiveRecord: 4.1ms)
[----] F, [2019-12-12T08:12:20.673432 #7409:112c5b8] FATAL -- : Error caught: [RuntimeError] Multiple relationships found
/var/www/miq/vmdb/app/models/mixins/relationship_mixin.rb:432:in `relationship'
/var/www/miq/vmdb/app/models/mixins/relationship_mixin.rb:385:in `subtree_rels_arranged'
/opt/rh/cfme-gemset/gems/memoist-0.15.0/lib/memoist.rb:213:in `subtree_rels_arranged'
/var/www/miq/vmdb/app/models/mixins/relationship_mixin.rb:397:in `subtree_arranged'
/opt/rh/cfme-gemset/gems/memoist-0.15.0/lib/memoist.rb:213:in `subtree_arranged'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder_vms_and_templates.rb:18:in `relationship_tree'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/full_tree_builder.rb:20:in `tree'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder_vandt.rb:23:in `block in x_get_tree_roots'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder_vandt.rb:23:in `collect!'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder_vandt.rb:23:in `x_get_tree_roots'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder.rb:242:in `x_get_tree_objects'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder.rb:209:in `x_build_tree'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder.rb:143:in `build_tree'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/presenters/tree_builder.rb:26:in `initialize'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/controllers/application_controller/feature.rb:28:in `new'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/controllers/application_controller/feature.rb:28:in `build_tree'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/controllers/mixins/vm_show_mixin.rb:30:in `block in explorer'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/controllers/mixins/vm_show_mixin.rb:30:in `collect'
/opt/rh/cfme-gemset/bundler/gems/cfme-ui-classic-ffe20d38326d/app/controllers/mixins/vm_show_mixin.rb:30:in `explorer'
/opt/rh/cfme-gemset/gems/actionpack-5.0.6/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.6/lib/abstract_controller/base.rb:188:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.6/lib/action_controller/metal/rendering.rb:30:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.6/lib/abstract_controller/callbacks.rb:20:in `block in process_action'

(production.log)

Expected results:
vms display

Additional info:
database being acquired (75gb). fix_vm_relationship.rb ran, issue still present.
steps extracted from the logs, customer didn't confirm.