Hi,
We have had a similar issue when upgrading, digging into it we found out
that this was caused by snapshots that had the "Save memory" option
enabled. We finally ended up deleting any snapshot that had this option
enabled and then we tried to upgrade, this time the process went smooth.
Hope this helps.
Regards.
El 2016-07-05 18:49, Matt . escribió:
OK some update on this.
Removed the db-migrate-script package and reinstalled ovirt-engine and
ovirt-engine-setup.
I still have that error and this is the loggingpart:
CONTEXT: SQL statement "DROP INDEX IF EXISTS
idx_vm_static_template_version_name; CREATE INDEX
idx_vm_static_template_version_nam$
PL/pgSQL function fn_db_create_index(character varying,character
varying,text,text) line 12 at EXECUTE statement
psql:/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0140_convert_memory_snapshots_to_disks.sql:93:
ERROR:
insert or update on table "image_storage_domain_map" violates foreign
key constraint
"fk_image_storage_domain_map_storage_domain_static"
DETAIL: Key (storage_domain_id)=(006552b0-cae3-4ccb-9baa-ee8c3b8e42cf)
is not present in table "storage_domain_static".
FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0140_convert_memory_snapshots_to_disks.sql
2016-07-05 19:40:29 ERROR
otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
schema._misc:313 schema.sh: FATAL:
sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0140_convert_memory_snapshots_to_disks.sql
2016-07-05 19:40:29 DEBUG otopi.context context._executeMethod:142
method exception
Traceback (most recent call last):
File "/usr/lib/python2.7/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 315, in _misc
raise RuntimeError(_('Engine schema refresh failed'))
RuntimeError: Engine schema refresh failed
Any idea ?
2016-07-05 15:25 GMT+02:00 Matt . <yamakasi....@gmail.com>:
I just found out that the file
04_00_0140_convert_memory_snapshots_to_disks.sql
is not located in:
/usr/share/ovirt-engine/dbscripts/upgrade/
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
