Bug 1566526

Summary: Reporting worker exceeding threshold for default report tied to custom widget
Product: Red Hat CloudForms Management Engine Reporter: Satoe Imaishi <simaishi>
Component: PerformanceAssignee: Keenan Brock <kbrock>
Status: CLOSED NEXTRELEASE QA Contact: Niyaz Akhtar Ansari <nansari>
Severity: high Docs Contact:
Priority: high    
Version: 5.8.0CC: cpelland, dajohnso, hkataria, jocarter, lavenel, mpovolny, obarenbo, smallamp, tuado
Target Milestone: GAKeywords: ZStream
Target Release: 5.9.2   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: 5.9.2.3 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1560113 Environment:
Last Closed: 2018-05-03 18:36:03 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On: 1560113    
Bug Blocks:    

Comment 2 CFME Bot 2018-04-12 13:21:25 UTC 
New commit detected on ManageIQ/manageiq/gaprindashvili:

https://github.com/ManageIQ/manageiq/commit/bf016cf9fd265b7f9faeb3a3fcaa1f5183d15af4
commit bf016cf9fd265b7f9faeb3a3fcaa1f5183d15af4
Author:     Jason Frey <fryguy9>
AuthorDate: Fri Apr  6 14:59:10 2018 -0400
Commit:     Jason Frey <fryguy9>
CommitDate: Fri Apr  6 14:59:10 2018 -0400

    Merge pull request #17246 from kbrock/vm_template_name

    convert Vm#miq_provision_template to has_one
    (cherry picked from commit eef19e08d460594cad629a022169c2ee1a3a9331)

    https://bugzilla.redhat.com/show_bug.cgi?id=1566526

 app/models/vm_or_template.rb | 6 +-
 lib/miq_expression.rb | 6 +-
 lib/miq_expression/field.rb | 23 +
 spec/lib/miq_expression/field_spec.rb | 37 +
 spec/models/miq_report/search_spec.rb | 2 +-
 spec/models/vm_or_template_spec.rb | 26 +
 6 files changed, 91 insertions(+), 9 deletions(-)
Comment 3 Dave Johnson 2018-04-26 17:42:30 UTC 
Tuan, can you provide a more specific set of reproduction steps so we can verify its now fixed?  Or perhaps you can verify yourself if we provide a appliance?
Comment 4 Tuan 2018-05-01 17:41:15 UTC 
Hello Dave, 
      Sorry for the delay, I confirmed that the customer has since disabled the scheduled widget and runs it's manually. I have also confirmed with Josh that the customer database is too large for us to collect. 

Customer originally was concerned over any workers exceeding thresholds, the ticket was not about this widget/report specifically. I am not quite sure how we would go about reproducing this.
Comment 5 Niyaz Akhtar Ansari 2018-05-03 14:25:05 UTC 
Hi Tuan,

What steps to be perform in order to verify this BZ.
Keenan gave me the widget import file. 
Can you please provide me some steps to verify this bz.

Thanks 
~Niyaz
Comment 6 Tuan 2018-05-03 14:37:23 UTC 
Hello Niyaz,
       Customer originally had widget scheduled. The customer has since turned this off and runs it manually. 

You can import the widget and schedule it or manually run it and check to see if the reporting worker exceeds the memory threshold. I believe their threshold was set at 1.5 GB and the reporting worker was hitting 4 GB.
Comment 7 Tuan 2018-05-03 14:37:49 UTC 
Hello Niyaz,
       Customer originally had widget scheduled. The customer has since turned this off and runs it manually. 

You can import the widget and schedule it or manually run it and check to see if the reporting worker exceeds the memory threshold. I believe their threshold was set at 1.5 GB and the reporting worker was hitting 4 GB.