Bug 1474570

Can you provide the manual steps to reconfiguare the dwh to full collection?

A workaround for this issue will be to add a conf file to ovirt-engine-dwhd.conf.d/
with a prefix greater then 10, like  99-my-scale.conf.

Add to the file the following lines:
DWH_TABLES_KEEP_SAMPLES=24
DWH_TABLES_KEEP_HOURLY=1440
DWH_TABLES_KEEP_DAILY=43800

and restart ovirt-engine-dwhd service

Can you please pass the info in comment 3 to the customer?
Can you create a KBase with this info?

Ido, is this going to be in 4.2.0?

Yes. Sent a patch.

Do we want this fix in 4.1 also ?

The fix for this bug was to revert the patch for https://bugzilla.redhat.com/1365427

The author decided to show the question to the user only when a new database is created, what broke the --reconfigure-dwh-scale option.

https://bugzilla.redhat.com/show_bug.cgi?id=1365427#c2

No sampling scale configurable during --reconfigure-dwh-scale

tested in ovirt-engine-dwh-setup-4.2.1-0.2.beta1.20171026134154.el7ev.noarch

Lukas, can you please describe how did you verify?

I just verified as the following:

1. clean engine-setup
2. engine-setup --reconfigure-dwh-scale with the following output:
[root@localhost ~]# engine-setup --reconfigure-dwh-scale
[ INFO  ] Stage: Initializing
[ INFO  ] Stage: Environment setup
          Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf']
          Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20171207024923-62vxvy.log
          Version: otopi-1.7.6_master (otopi-1.7.6-0.0.master.20171204131110.gitd5016f6.el7.centos)
[ INFO  ] Stage: Environment packages setup
[ INFO  ] Stage: Programs detection
[ INFO  ] Stage: Environment setup
[ INFO  ] Stage: Environment customization
         
          --== PRODUCT OPTIONS ==--
         
         
          --== PACKAGES ==--
         
[ INFO  ] ovirt-provider-ovn already installed, skipping.
[ INFO  ] Checking for product updates...
[ INFO  ] No product updates found
         
          --== NETWORK CONFIGURATION ==--
         
          Setup can automatically configure the firewall on this system.
          Note: automatic configuration of the firewall may overwrite current settings.
          NOTICE: iptables is deprecated and will be removed in future releases
          Do you want Setup to configure the firewall? (Yes, No) [Yes]: 
[ INFO  ] firewalld will be configured as firewall manager.
         
          --== DATABASE CONFIGURATION ==--
         
          The detected DWH database size is 23 MB.
          Setup can backup the existing database. The time and space required for the database backup depend on its size. This process takes time, and in some cases (for instance, when the size is few GBs) may take several hours to complete.
          If you choose to not back up the database, and Setup later fails for some reason, it will not be able to restore the database and all DWH data will be lost.
          Would you like to backup the existing database before upgrading it? (Yes, No) [Yes]: 
          Perform full vacuum on the oVirt engine history
          database ovirt_engine_history@localhost?
          This operation may take a while depending on this setup health and the
          configuration of the db vacuum process.
          See https://www.postgresql.org/docs/9.0/static/sql-vacuum.html
          (Yes, No) [No]: 
         
          --== OVIRT ENGINE CONFIGURATION ==--
         
          Perform full vacuum on the engine database engine@localhost?
          This operation may take a while depending on this setup health and the
          configuration of the db vacuum process.
          See https://www.postgresql.org/docs/9.0/static/sql-vacuum.html
          (Yes, No) [No]: 
         
          --== STORAGE CONFIGURATION ==--
         
         
          --== PKI CONFIGURATION ==--
         
         
          --== APACHE CONFIGURATION ==--
         
         
          --== SYSTEM CONFIGURATION ==--
         
         
          --== MISC CONFIGURATION ==--
         
          Please choose Data Warehouse sampling scale:
          (1) Basic
          (2) Full
          (1, 2)[1]: 2
         
          --== END OF CONFIGURATION ==--
         
[ INFO  ] Stage: Setup validation
...

fix was included only in latest version ovirt-engine-dwh-setup-4.2.1-1.el7ev.noarch

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2018:1487

BZ<2>Jira Resync