----- Original Message -----
El 2016-07-06 11:11, nicolas@devels.es escribió:
Hi Arik,
El 2016-07-06 10:27, Arik Hadas escribió:
Hi,
This is a bit aggressive solution to remove all snapshots with the memory.
Can you confirm that a storage domain that was active while creating the snapshot with memory was removed from the system? This is something that was not covered and could lead to the reported issue.
Some of them were available when we did remove a storage backend, indeed. Some were newer, the problem is that I don't know which one actually failed since when this happened we were in a hurry and needed to upgrade ASAP.
Until we come up with a proper solution, you can use the following query to identify the exact problematic snapshots and remove them before upgrading: select vm_name, snapshots.description as snapshot_name, snapshot_id from snapshots join vm_static on vm_id=vm_guid where CAST(split_part(memory_volume, ',', 1) AS UUID) not in (select id from storage_domain_static);
Thanks. We have another oVirt infrastructure and I see this query is returning one row. I'll report back when we upgrade this second infrastructure and provide some details.
We've upgraded our second oVirt infrastructure as well, here are the steps:
1) I run the query you provided, it returned one row. 2) I tried upgrading to 4.0 without deleting that snapshot: it failed with the error below. 3) I deleted the snapshot 4) Now I tried upgrading again and everything went smoothly.
I'd say this is the same issue, apparently.
Thanks.
Thanks for the update. I opened a bug for this issue [1]. We will probably just remove the memory from this kind of snapshots automatically during the upgrade. [1] https://bugzilla.redhat.com/show_bug.cgi?id=1353219
Regards.
Regards, Arik
----- Original Message -----
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@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 _______________________________________________ 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