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

[nicolas at devels.es]

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.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/
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users