Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1090914 - MinimalVersionCheck job has incorrect instructions for upgrade of engine & dwh.
MinimalVersionCheck job has incorrect instructions for upgrade of engine & dwh.
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-dwh (Show other bugs)
3.4.0
x86_64 Linux
unspecified Severity medium
: ---
: 3.4.0
Assigned To: Shirly Radco
Barak Dagan
infra
:
Depends On:
Blocks: 1097702 rhev3.4rc
  Show dependency treegraph
 
Reported: 2014-04-24 07:49 EDT by Yaniv Lavi
Modified: 2016-02-10 14:14 EST (History)
10 users (show)

See Also:
Fixed In Version: av8 - rhevm-dwh-3.4.0-8.el6ev.noarch.rpm
Doc Type: Release Note
Doc Text:
After the manager is upgraded to 3.4.0, the ETL Service returns the following error: "You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please upgrade using yum and run ovirt-engine-dwh-setup. Service will now exit." Due to upgrade flow changes in 3.4.0, the user must take one of the following steps: When using only DWH, install rhevm-dwh-setup. When using both DWH and reports, install rhevm-dwh-setup and rhevm-reports-setup. The user must then run engine-setup to update packages to 3.4.0 and start DWH service.
Story Points: ---
Clone Of:
: 1097702 (view as bug list)
Environment:
Last Closed: 2014-06-09 11:18:47 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: Infra
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
dwh log (1.89 KB, application/x-compressed-tar)
2014-05-01 05:29 EDT, Barak Dagan
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
oVirt gerrit 27101 master MERGED history:fixed message in MinimalVersionCheck job Never
oVirt gerrit 27112 ovirt-engine-3.4 MERGED history:fixed message in MinimalVersionCheck job Never
Red Hat Product Errata RHEA-2014:0601 normal SHIPPED_LIVE rhevm-dwh 3.4 bug fix and enhancement update 2014-06-09 15:15:53 EDT

  None (edit)
Description Yaniv Lavi 2014-04-24 07:49:44 EDT
Description of problem:
MinimalVersionCheck job has incorrect instructions for upgrade of engine & dwh. This is due to change to otopi setup and the fact that dwh is a plugin. Need to update the messages.

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

How reproducible:
always

Steps to Reproduce:
1. upgrade engine to 3.4.0
2. start dwh 3.3

Actual results:
error says - "You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please upgrade using yum and run ovirt-engine-dwh-setup. Service will now exit."

Expected results:
should say - "You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please upgrade using yum and run engine-setup again. Service will now exit."

Additional info:
Comment 2 Barak Dagan 2014-05-01 05:28:43 EDT
Verification failed: av8.1:

# rpm -qa | egrep 'rhevm-3|dwh|reports' | grep -v setup
jasperreports-server-pro-5.5.0-6.el6ev.noarch
rhevm-dwh-3.3.2-1.el6ev.noarch
rhevm-reports-3.3.2-3.el6ev.noarch
rhevm-3.4.0-0.16.rc.el6ev.noarch

tail /var/log/ovirt-engine/ovirt-engine-dwhd.log:

2014-05-01 12:16:01|W4Xf4E|yfPOLK|yfPOLK|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|5|tDie|tDie_1|2014-05-01 12:16:01|You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please upgrade using yum and run ovirt-engine-dwh-setup. Service will now exit.|4
2014-05-01 12:16:01|You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please upgrade using yum and run ovirt-engine-dwh-setup. Service will now exit.
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
	at ovirt_engine_dwh.historyetl_3_3.HistoryETL.tRunJob_2Process(HistoryETL.java:5800)
	at ovirt_engine_dwh.historyetl_3_3.HistoryETL$4.run(HistoryETL.java:7772)
2014-05-01 12:16:01|yfPOLK|yfPOLK|yfPOLK|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
2014-05-01 12:16:01|ETL Service Stopped
Comment 3 Barak Dagan 2014-05-01 05:29:42 EDT
Created attachment 891422 [details]
dwh log
Comment 4 Yaniv Lavi 2014-05-04 10:49:14 EDT
Please test 3.4 to 3.4 test by changing the db values manually.
I added a release note for 3.3 that covers the upgrade to 3.4.



Yaniv
Comment 5 Barak Dagan 2014-05-13 07:42:56 EDT
(In reply to Yaniv Dary from comment #4)
> Please test 3.4 to 3.4 test by changing the db values manually.
> I added a release note for 3.3 that covers the upgrade to 3.4.
> 
> 
> 
> Yaniv

Which DB / table holds these records ?
Comment 6 Yaniv Lavi 2014-05-13 07:58:01 EDT
vdc_options in engine.
history_configuartion in ovirt_engine_history.




Yaniv
Comment 7 Barak Dagan 2014-05-13 10:24:19 EDT
Yaniv, 

Doesn't seem to work fixing the DB values:

bash-4.1$ psql -d engine -c "select * from vdc_options where option_name = 'MinimalETLVersion';" | less -S
could not change directory to "/root"
 option_id |    option_name    | option_value | version 
-----------+-------------------+--------------+---------
       238 | MinimalETLVersion | 3.3.3        | general



bash-4.1$ psql -d ovirt_engine_history -c "select * from history_configuration where var_name = 'MinimalETLVersion';" | less -S
could not change directory to "/root"
     var_name      | var_value | var_datetime 
-------------------+-----------+--------------
 MinimalETLVersion | 3.3.3     | 


[root@vm1 ~]# service ovirt-engine-dwhd start
Starting oVirt Engine Dataware House:                      [  OK  ]


[root@vm1 ~]# service ovirt-engine-dwhd status
ovirt-engine-dwhd (pid  17253) is running...
Comment 8 Yaniv Lavi 2014-05-13 10:58:22 EDT
(In reply to Barak Dagan from comment #7)
> Yaniv, 
> 
> Doesn't seem to work fixing the DB values:
> 
> bash-4.1$ psql -d engine -c "select * from vdc_options where option_name =
> 'MinimalETLVersion';" | less -S
> could not change directory to "/root"
>  option_id |    option_name    | option_value | version 
> -----------+-------------------+--------------+---------
>        238 | MinimalETLVersion | 3.3.3        | general
> 
> 
> 
> bash-4.1$ psql -d ovirt_engine_history -c "select * from
> history_configuration where var_name = 'MinimalETLVersion';" | less -S
> could not change directory to "/root"
>      var_name      | var_value | var_datetime 
> -------------------+-----------+--------------
>  MinimalETLVersion | 3.3.3     | 
> 
> 
> [root@vm1 ~]# service ovirt-engine-dwhd start
> Starting oVirt Engine Dataware House:                      [  OK  ]
> 
> 
> [root@vm1 ~]# service ovirt-engine-dwhd status
> ovirt-engine-dwhd (pid  17253) is running...

Are you using the 3.4.0 packages?



Yaniv
Comment 9 Barak Dagan 2014-05-14 03:18:12 EDT
(In reply to Yaniv Dary from comment #8)
> (In reply to Barak Dagan from comment #7)
> > Yaniv, 
> > 
> > Doesn't seem to work fixing the DB values:
> > 
> > bash-4.1$ psql -d engine -c "select * from vdc_options where option_name =
> > 'MinimalETLVersion';" | less -S
> > could not change directory to "/root"
> >  option_id |    option_name    | option_value | version 
> > -----------+-------------------+--------------+---------
> >        238 | MinimalETLVersion | 3.3.3        | general
> > 
> > 
> > 
> > bash-4.1$ psql -d ovirt_engine_history -c "select * from
> > history_configuration where var_name = 'MinimalETLVersion';" | less -S
> > could not change directory to "/root"
> >      var_name      | var_value | var_datetime 
> > -------------------+-----------+--------------
> >  MinimalETLVersion | 3.3.3     | 
> > 
> > 
> > [root@vm1 ~]# service ovirt-engine-dwhd start
> > Starting oVirt Engine Dataware House:                      [  OK  ]
> > 
> > 
> > [root@vm1 ~]# service ovirt-engine-dwhd status
> > ovirt-engine-dwhd (pid  17253) is running...
> 
> Are you using the 3.4.0 packages?
> 
> Yes I am
> 
> Yaniv
Comment 10 Barak Dagan 2014-05-14 05:20:57 EDT
Verification failed on av9:

rhevm-3.4.0-0.18.el6ev.noarch
rhevm-dwh-3.4.0-9.el6ev.noarch
rhevm-dwh-setup-3.4.0-9.el6ev.noarch
rhevm-reports-3.4.0-9.el6ev.noarch
rhevm-reports-setup-3.4.0-9.el6ev.noarch

missing : "*Please upgrade using yum*"


log:
2014-05-14 09:55:46|ETL Service Started
2014-05-14 09:55:46|wEHbwH|XO0g4c|XO0g4c|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|5|tDie|tDie_1|2014-05-14 09:55:46|You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please run engine-setup to upgrade the version. Service will now exit.|4
2014-05-14 09:55:46|You have upgraded your oVirt Engine and now require an upgrade of the ovirt-engine-dwh package. Please run engine-setup to upgrade the version. Service will now exit.
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
        at ovirt_engine_dwh.historyetl_3_4.HistoryETL.tRunJob_2Process(HistoryETL.java:7152)
        at ovirt_engine_dwh.historyetl_3_4.HistoryETL$3.run(HistoryETL.java:9930)
2014-05-14 09:55:46|XO0g4c|XO0g4c|XO0g4c|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
2014-05-14 09:55:46|ETL Service Stopped
Comment 11 Yaniv Lavi 2014-05-14 06:59:52 EDT
(In reply to Barak Dagan from comment #10)
> Verification failed on av9:
> 
> rhevm-3.4.0-0.18.el6ev.noarch
> rhevm-dwh-3.4.0-9.el6ev.noarch
> rhevm-dwh-setup-3.4.0-9.el6ev.noarch
> rhevm-reports-3.4.0-9.el6ev.noarch
> rhevm-reports-setup-3.4.0-9.el6ev.noarch
> 
> missing : "*Please upgrade using yum*"
> 
> 
> log:
> 2014-05-14 09:55:46|ETL Service Started
> 2014-05-14
> 09:55:
> 46|wEHbwH|XO0g4c|XO0g4c|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|5|tDie|t
> Die_1|2014-05-14 09:55:46|You have upgraded your oVirt Engine and now
> require an upgrade of the ovirt-engine-dwh package. Please run engine-setup
> to upgrade the version. Service will now exit.|4
> 2014-05-14 09:55:46|You have upgraded your oVirt Engine and now require an
> upgrade of the ovirt-engine-dwh package. Please run engine-setup to upgrade
> the version. Service will now exit.
> Exception in component tRunJob_2
> java.lang.RuntimeException: Child job running failed
>         at
> ovirt_engine_dwh.historyetl_3_4.HistoryETL.tRunJob_2Process(HistoryETL.java:
> 7152)
>         at
> ovirt_engine_dwh.historyetl_3_4.HistoryETL$3.run(HistoryETL.java:9930)
> 2014-05-14
> 09:55:46|XO0g4c|XO0g4c|XO0g4c|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java
> Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
> 2014-05-14 09:55:46|ETL Service Stopped

This is the correct instructions. otopi will do the update for the user from 3.4 and on.



Yaniv
Comment 12 Barak Dagan 2014-05-14 07:11:23 EDT
Not unless the dwh is upgraded using yum.
Anyway, the returned results are different from the expected.
Comment 13 Barak Dagan 2014-05-15 07:06:29 EDT
Pavel,

Please advice.
Comment 14 Barak Dagan 2014-05-19 06:08:42 EDT
Verified on av9.1. no longer reproducible, will be tested again on 3.5
Comment 15 errata-xmlrpc 2014-06-09 11:18:47 EDT
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.

http://rhn.redhat.com/errata/RHEA-2014-0601.html

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