[ovirt-users] Re: Can't upgrade ovirt 4.4.3 to 4.4.9
Correct. Was added in an upgrade script. There might be a
bug/issue/change
in the order that the upgrade script runs vs create_views_* above.
Adding Aviv and Shirly.
i found this problem at log.
UPDATE 0
2022-01-21 16:02:41,589+0900 Running upgrade sql script
'/usr/share/ovirt-engine-dwh/dbscripts/upgrade/pre_upgrade/set_etl_minimal_version.sql'...
2022-01-21 16:02:41,591+0900 dbfunc_psql_die
--file=/usr/share/ovirt-engine-dwh/dbscripts/upgrade/pre_upgrade/set_etl_minimal_version.sql
********* QUERY **********
INSERT INTO history_configuration(var_name,var_value) SELECT
'MinimalETLVersion','4.4.7' WHERE not exists (SELECT var_name FROM
history_configuration WHERE var_name = 'MinimalETLVersion');
**************************
INSERT 0 0
********* QUERY **********
UPDATE history_configuration SET var_value = '4.4.7' WHERE var_name =
'MinimalETLVersion';
**************************
......
2022-01-21 16:02:43,138+0900 Skipping upgrade script
/usr/share/ovirt-engine-dwh/dbscripts/upgrade/04_04_0040_added_host_count_threads_as_cores.sql,
its version 04040040 is <= current version 04040070
********* QUERY **********
copy (select now()) to stdout with delimiter as '|';
**************************
Sorry for the mess, Thank you
--
Jihwan