Just tried to upgrade my engine from 4.4.10.6 -> 4.5.0 on CentOS Stream 8.
I relized I missed the step of updating to the very latest version of
4.4.10 around the same time it failed and left things in somewhat of a bad
state, so I just built a new Rocky 8.6 host and restored my backup there.
Update from 4.4.10.6 to 4.4.10.7 there went fine. 4.4.10.7 -> 4.5.0 fails
with the same error, however:
[ ERROR ] schema.sh: FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh
failed
This appears to be the relevant section of the log:
psql:/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql:22: NOTICE: column
"default_value" of relation "vdc_options" already exists, skipping
psql:/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql:1454: ERROR:
column "default_value" contains null values
CONTEXT: SQL statement "ALTER TABLE vdc_options ALTER COLUMN default_value SET NOT
NULL"
PL/pgSQL function fn_db_change_column_null(character varying,character
varying,boolean) line 10 at EXECUTE
FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql
2022-06-01 01:10:03,015-0700 ERROR
otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:530
schema.sh: FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql
2022-06-01 01:10:03,016-0700 DEBUG otopi.context context._executeMethod:145
method exception
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in
_executeMethod
method['method']()
File
"/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py",
line 532, in _misc
raise RuntimeError(_('Engine schema refresh failed'))
RuntimeError: Engine schema refresh failed
2022-06-01 01:10:03,017-0700 ERROR otopi.context
context._executeMethod:154 Failed to execute stage 'Misc configuration': Engine
schema refresh failed
Any ideas?
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/[email protected]/message/FENABEXHA4P3PHHLT6WMK6TMWEPJSRLO/
