Bug 1512705

Summary:	vmdb size constantly increasing 1+gb a day
Product:	Red Hat CloudForms Management Engine	Reporter:	Satoe Imaishi <simaishi>
Component:	Appliance	Assignee:	Nick Carboni <ncarboni>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Alex Newman <anewman>
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	5.8.0	CC:	abellott, anewman, dajohnso, fdewaley, gtanzill, jhardy, ncarboni, niroy, obarenbo
Target Milestone:	GA	Keywords:	TestOnly, ZStream
Target Release:	5.9.0
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:	5.9.0.15	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1510484	Environment:
Last Closed:	2018-03-06 15:07:48 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1510484
Bug Blocks:

Comment 2 CFME Bot 2017-11-29 20:22:34 UTC

New commit detected on ManageIQ/manageiq/gaprindashvili:
https://github.com/ManageIQ/manageiq/commit/bf567e7197ed1f2c993efc9c6ab647a5513de8a6

commit bf567e7197ed1f2c993efc9c6ab647a5513de8a6
Author:     Gregg Tanzillo <gtanzill>
AuthorDate: Wed Nov 8 21:51:00 2017 -0500
Commit:     Satoe Imaishi <simaishi>
CommitDate: Tue Nov 14 17:16:30 2017 -0500

    Merge pull request #16425 from carbonin/add_disabled_tag_value_purging
    
    Add purging for vim_performance_tag_values with disabled tags
    (cherry picked from commit c8e9b92ffd6a6dfecaf4aceded7857509d32fe62)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1512705

 tools/purge_orphaned_tag_values.rb | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

Comment 3 CFME Bot 2018-01-03 17:21:56 UTC

New commit detected on ManageIQ/manageiq/gaprindashvili:
https://github.com/ManageIQ/manageiq/commit/253a0125507a82124f52179362ae79bdfc08c88f

commit 253a0125507a82124f52179362ae79bdfc08c88f
Author:     Jason Frey <fryguy9>
AuthorDate: Tue Jan 2 13:44:30 2018 -0500
Commit:     Satoe Imaishi <simaishi>
CommitDate: Wed Jan 3 11:28:37 2018 -0500

    Merge pull request #16582 from gtanzillo/tag-values
    
    Build VimPerformanceTagValues for utilization charts by tags on the fly
    (cherry picked from commit bd2fa2fca0d419795e437aa44e1c76af128a97c1)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1512705

 app/models/vim_performance_tag.rb       | 35 ++++++++++++++++++---------------
 app/models/vim_performance_tag_value.rb | 10 +++++-----
 2 files changed, 24 insertions(+), 21 deletions(-)

Comment 4 CFME Bot 2018-01-03 17:22:02 UTC

New commit detected on ManageIQ/manageiq/gaprindashvili:
https://github.com/ManageIQ/manageiq/commit/14cda459997bb190811a61e93a933ad6a07fc6c7

commit 14cda459997bb190811a61e93a933ad6a07fc6c7
Author:     Jason Frey <fryguy9>
AuthorDate: Tue Jan 2 14:54:51 2018 -0500
Commit:     Satoe Imaishi <simaishi>
CommitDate: Wed Jan 3 11:31:10 2018 -0500

    Merge pull request #16692 from gtanzillo/dont-generate-tage-values
    
    Stop generating `vim_performance_tag_values` rows
    (cherry picked from commit 2c1b7a437241c1a8617ac8780795d06d5dd881fb)
    
    Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1512705
    Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1530713

 app/models/metric/ci_mixin/rollup.rb                        |  1 -
 app/models/storage.rb                                       |  2 --
 .../connection_adapters/miq_postgres_adapter.rb             |  4 ----
 .../connection_adapters/miq_postgres_legacy_adapter.rb      |  4 ----
 spec/models/vim_performance_tag_spec.rb                     |  2 --
 tools/metrics_populate_retro_tags.rb                        | 13 -------------
 6 files changed, 26 deletions(-)