[ovirt-users] 3.6 -> 4.0 upgrade fails on schema refresh

[Matt .]

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.014 at 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/