Re: [ovirt-users] Can't start VM after shutdown

Hi, I solved my problem, here are the steps but be carefully if you don't know what the commands did and how to restore from backup don't follow this: - ssh to the host - systemctl stop ovirt-engine - backup the database with "engine-backup" - navigate to the image files - backup the images: sudo -u vdsm rsync -av <uuid> <uuid_backup> - check which one is the backing file: qemu-img info <file> - check for damages: qemu-img check <file> - qemu-img commit <snapshot file> - rename the <snapshot file> + .lease and .meta so it can't be accessed - vmname=srv03 - db=engine - sudo -u postgres psql $db -c "SELECT b.disk_alias, s.description, s.snapshot_id, i.creation_date, s.status, i.imagestatus, i.size, i.image_group_id, i.vm_snapshot_id, i.image_guid, i.parentid, i.active FROM images as i JOIN snapshots AS s ON (i.vm_snapshot_id = s.snapshot_id) LEFT JOIN vm_static AS v ON (s.vm_id = v.vm_guid) JOIN base_disks AS b ON (i.image_group_id = b.disk_id) WHERE v.vm_name = '$vmname' ORDER BY creation_date, description, disk_alias" - note the image_guid and parent_id from the broken snapshot and the active snapshot, the active state is the image_guuid with the parentid 00000000-0000-0000-0000-000000000000 - igid_active=<active uuid> - igid_broken=<broken uuid> - the parentid of the image_guuid of the broken snapshot must be the same as the activ snapshots image_guuid - note the snapshot id - sid_active=<id of the active snapshot with parrent id 000000> - sid_broken=<id of the broken shapshot> - delete the broken snapshot - sudo -u postgres psql $db -c "DELETE FROM snapshots AS s WHERE s.snapshot_id = '$sid_broken'" - pid_new=00000000-0000-0000-0000-000000000000 - sudo -u postgres psql $db -c "SELECT * FROM images WHERE vm_snapshot_id = '$sid_active' AND image_guid = '$igid_broken'" - sudo -u postgres psql $db -c "DELETE FROM images WHERE vm_snapshot_id = '$sid_broken' AND image_guid = '$igid_active'" - sudo -u postgres psql $db -c "SELECT * FROM image_storage_domain_map WHERE image_id = '$igid_broken'" - sudo -u postgres psql $db -c "DELETE FROM image_storage_domain_map WHERE image_id = '$igid_broken'" - sudo -u postgres psql $db -c "UPDATE images SET image_guid = '$igid_active', parentid = '$pid_new' WHERE vm_snapshot_id = '$sid_active' AND image_guid = '$igid_broken'" - sudo -u postgres psql $db -c "SELECT * FROM image_storage_domain_map" - storid=<storage_domain_id> - diskprofileid=<disk_profile_id> - sudo -u postgres psql $db -c "INSERT INTO image_storage_domain_map (image_id, storage_domain_id, disk_profile_id) VALUES ('$igid_broken', '$stor_id', '$diskprofileid')" - check values - sudo -u postgres psql $db -c "SELECT b.disk_alias, s.description, s.snapshot_id, i.creation_date, s.status, i.imagestatus, i.size, i.image_group_id, i.vm_snapshot_id, i.image_guid, i.parentid, i.active FROM images as i JOIN snapshots AS s ON (i.vm_snapshot_id = s.snapshot_id) LEFT JOIN vm_static AS v ON (s.vm_id = v.vm_guid) JOIN base_disks AS b ON (i.image_group_id = b.disk_id) WHERE v.vm_name = '$vmname' ORDER BY creation_date, description, disk_alias"could not change directory to "/root/Backups/oVirt" - check for errors - engine-setup --offline - systemctl start ovirt-engine Now you should have a clean state and a working VM ;-) What was tested: - Power up and down the VM What does not work: - Its not possible to make offline snapshots, online was not tested because I will not getting into such trouble again. It took many hours after the machine is up again. PLEASE be aware and don't destroy your Host and VM !!! cheers gregor On 12/06/16 13:40, Colin Coe wrote: