Bug 1560113 - Reporting worker exceeding threshold for default report tied to custom widget
Summary: Reporting worker exceeding threshold for default report tied to custom widget
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Performance
Version: 5.8.0
Hardware: All
OS: All
high
high
Target Milestone: GA
: 5.10.0
Assignee: Keenan Brock
QA Contact: Parthvi Vala
URL:
Whiteboard:
Depends On:
Blocks: 1566526 1566528
TreeView+ depends on / blocked
 
Reported: 2018-03-23 23:49 UTC by Tuan
Modified: 2021-06-10 15:30 UTC (History)
9 users (show)

Fixed In Version: 5.10.0.0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1566526 1566528 (view as bug list)
Environment:
Last Closed: 2019-01-14 16:41:55 UTC
Category: Bug
Cloudforms Team: CFME Core
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Tuan 2018-03-23 23:49:47 UTC
Created attachment 1412350 [details]
evmlog

Description of problem:
Reporting worker exceeding memory threshold. Default report Provisional Activity -by VM attached to custom widget: Provisioning Activity - Provider Info

Memory threshold set for 1.5 GB, memory is exceeding to 4 GB when populating the widget.

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

How reproducible:
Always

Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 3 Keenan Brock 2018-03-28 21:23:33 UTC
Hello Taun,

Can we get a copy of the report.yml for "Default report Provisional Activity -by VM" 
And the dashboard widget: "Provisioning Activity - Provider Info"

Also, do we have a database backup for this customer?

Hard for me to diagnose without seeing the columns for the report, or the data.

If there are no date fields in the report.yml, they may want to take advantage of a widget option that reduces the number of report permutations that are generated:

In the widget.yml file:

    options:
        :timezone_matters: false

Please send across the report.yml, widget.yml, and see if you can get a customer dump.

Thanks,
Keenan

Comment 7 Keenan Brock 2018-04-03 14:34:34 UTC
Taun,

Still looking into this.
Looking to speed up the report by default

Keenan

Comment 11 CFME Bot 2018-04-06 19:00:43 UTC
New commit detected on ManageIQ/manageiq/master:

https://github.com/ManageIQ/manageiq/commit/fc5a68cf74b019ad833c2b301b323a23db77a32a
commit fc5a68cf74b019ad833c2b301b323a23db77a32a
Author:     Keenan Brock <keenan>
AuthorDate: Mon Apr  2 15:04:15 2018 -0400
Commit:     Keenan Brock <keenan>
CommitDate: Mon Apr  2 15:04:15 2018 -0400

    convert Vm#miq_provision_template to has_one

    Provision Activity report uses this field in a where clause
    This change allows the report to run without downloading all data

    https://bugzilla.redhat.com/show_bug.cgi?id=1560113
 app/models/vm_or_template.rb | 6 +-
 spec/models/vm_or_template_spec.rb | 26 +
 2 files changed, 27 insertions(+), 5 deletions(-)

Comment 12 CFME Bot 2018-04-06 19:02:02 UTC
New commit detected on ManageIQ/manageiq/master:

https://github.com/ManageIQ/manageiq/commit/fc5a68cf74b019ad833c2b301b323a23db77a32a
commit fc5a68cf74b019ad833c2b301b323a23db77a32a
Author:     Keenan Brock <keenan>
AuthorDate: Mon Apr  2 15:04:15 2018 -0400
Commit:     Keenan Brock <keenan>
CommitDate: Mon Apr  2 15:04:15 2018 -0400

    convert Vm#miq_provision_template to has_one

    Provision Activity report uses this field in a where clause
    This change allows the report to run without downloading all data

    https://bugzilla.redhat.com/show_bug.cgi?id=1560113
 app/models/vm_or_template.rb | 6 +-
 spec/models/vm_or_template_spec.rb | 26 +
 2 files changed, 27 insertions(+), 5 deletions(-)

Comment 13 Keenan Brock 2018-04-10 15:12:27 UTC
part of today's build

Comment 18 Parthvi Vala 2018-10-04 08:51:41 UTC
Hi,

After looking at the referenced BZs 1556526 and 1566528, it seems like QE doesn't have an environment to test this bug.

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

Thanks,
Parthvi

Comment 19 Sudhir Mallamprabhakara 2019-01-14 16:41:55 UTC
https://bugzilla.redhat.com/show_bug.cgi?id=1566526#c9


Note You need to log in before you can comment on or make changes to this bug.