Re: [ovirt-users] Snapshot issue

From: "Koen Vanoppen" <vanoppen.koen(a)gmail.com&gt; To: "Omer Frenkel" <ofrenkel(a)redhat.com&gt;, users(a)ovirt.org Sent: Wednesday, April 1, 2015 7:53:03 AM Subject: Re: [ovirt-users] Snapshot issue Worked perfectly!!! BIG thanks Omer!!! All my VM's are back up. Nothing lost! SOLVED!!!

2015-03-31 9:53 GMT+02:00 Omer Frenkel <ofrenkel(a)redhat.com&gt;: > > > ----- Original Message ----- > > From: "Koen Vanoppen" <vanoppen.koen(a)gmail.com&gt; > > To: "Omer Frenkel" <ofrenkel(a)redhat.com&gt;, users(a)ovirt.org > > Sent: Tuesday, March 31, 2015 7:35:57 AM > > Subject: Re: [ovirt-users] Snapshot issue > > > > I just wanted to remove the snapshots in ovirt... That's all... And now > > they are locked. Without the possibility to remove, reboot the vm or > cancel > > the snapshots... > > So I'm stuck... How can I change the status of the snapshot in the db, so > > that at least I can remove the VM? And what could be the impact , worst > > case? > > > > i thought you want to save the vm, then the worst case might be data > corruption, > in case something is really wrong with the snapshots and you try to run > the vm. > > more optimistic, in case snapshot is missing in storage but not deleted in > db, > vm would fail to start, then you might be able to just delete the snapshot > (again probably only manually in db) > and recover completely. > > if you just want to delete the vm, worst case would be that you have to > clear manually stuff from the db/storage > > if you decide to change the db, better to have a backup :) > also, i would recommend making it when the engine is down. > > ok, so, first to get the info in the db: > select snapshot_id,description,status from snapshots where status = > 'LOCKED' and vm_id in (select vm_guid from vm_static where vm_name='<vm > name here>'); > > just update it to be 'OK' : > update snapshots set status = 'OK' where snapshot_id = '<snapshot id from > previous query>'; > > also, check there are locked images related to this snapshot: > select image_guid,imagestatus from images where vm_snapshot_id = > '<snapshot id from previous query>' and imagestatus != 1; > > if so, need to unlock it as well: > updates images set imagestatus = 1 where image_guid = '<id of images from > previous query>'; > > > let me know how it went > > > Kind regards, > > > > 2015-03-30 13:46 GMT+02:00 Omer Frenkel <ofrenkel(a)redhat.com&gt;: > > > > > > > > > > > ----- Original Message ----- > > > > From: "Koen Vanoppen" <vanoppen.koen(a)gmail.com&gt; > > > > To: "Omer Frenkel" <ofrenkel(a)redhat.com&gt;, users(a)ovirt.org > > > > Sent: Monday, March 30, 2015 7:44:10 AM > > > > Subject: Re: [ovirt-users] Snapshot issue > > > > > > > > I can't even remove them... Something needs to be done... Any ideas? > > > > > > > > > > not sure i understand what you tried? > > > the 'broken' snapshots are locked, so you can't remove them. > > > as i said, there is no easy and safe way to fix this... > > > you can try to change the status of the snapshot in the db - but i am > not > > > sure what will happen! > > > > > > > 2015-03-25 8:45 GMT+01:00 Koen Vanoppen <vanoppen.koen(a)gmail.com&gt;: > > > > > > > > > Hi Omer, > > > > > > > > > > Thanks for your reply. > > > > > I was cleaning our snapshots on oVirt. So I started deleting > snapshots > > > one > > > > > by one. In total in deleted 10 snapshots. 5 VM's came back up, > without > > > the > > > > > error message, the rest of them are still down with this error > message. > > > > > > > > > > 2015-03-25 7:36 GMT+01:00 Omer Frenkel <ofrenkel(a)redhat.com&gt;: > > > > > > > > > >> > > > > >> > > > > >> ----- Original Message ----- > > > > >> > From: "Koen Vanoppen" <vanoppen.koen(a)gmail.com&gt; > > > > >> > To: users(a)ovirt.org > > > > >> > Sent: Wednesday, March 25, 2015 8:09:17 AM > > > > >> > Subject: Re: [ovirt-users] Snapshot issue > > > > >> > > > > > >> > I'm still not able to start my VM's: > > > > >> > Cannot run VM. The VM is performing an operation on a Snapshot. > > > Please > > > > >> wait > > > > >> > for the operation to finish, and try again... > > > > >> > > > > > >> > I already restarted the vdsm deamons on the hypervisors and > > > restarted > > > > >> the > > > > >> > engine too... Does anybody has any clue how I can solve this > state? > > > > >> > > > > > >> > Kind regards, > > > > >> > > > > > >> > Koen > > > > >> > > > > > >> > 2015-03-24 7:45 GMT+01:00 Koen Vanoppen < > vanoppen.koen(a)gmail.com > > > > : > > > > >> > > > > > >> > > > > > >> > > > > > >> > This is in the logs: > > > > >> > 2015-03-24 07:41:50,436 WARN > > > [org.ovirt.engine.core.bll.RunVmCommand] > > > > >> > (ajp--127.0.0.1-8702-12) [686c18ce] CanDoAction of action RunVm > > > failed > > > > >> for > > > > >> > user Reasons: > > > > >> > > > > VAR__ACTION__RUN,VAR__TYPE__VM,ACTION_TYPE_FAILED_VM_IS_DURING_SNAPSHOT > > > > >> > > > > > >> > Can't I clear all this? Because I Still have several machines > down > > > due > > > > >> the > > > > >> > reason he is still in the "cannot run VM..." state... > > > > >> > > > > > >> > > > > >> this happens because you have a snapshot in status locked, > > > > >> probably you did some operation on snapshot and something went > wrong > > > (it > > > > >> might have failed without clearing the state..) > > > > >> there is no easy and safe way to fix this (you can change the > status > > > of > > > > >> the snapshot in the db but i am not sure what will happen) > > > > >> what action did you do with snapshots on this vm? > > > > >> what was the result? > > > > >> > > > > >> > > > > > >> > > > > > >> > 2015-03-23 8:40 GMT+01:00 Koen Vanoppen < > vanoppen.koen(a)gmail.com > > > > : > > > > >> > > > > > >> > > > > > >> > > > > > >> > Dear all, > > > > >> > > > > > >> > I have the following problem: > > > > >> > > > > > >> > Cannot run VM. The VM is performing an operation on a Snapshot. > > > Please > > > > >> wait > > > > >> > for the operation to finish, and try again. > > > > >> > > > > > >> > It is like this since Friday... How can I resolve this? I really > > > need > > > > >> this vm > > > > >> > to be up again... > > > > >> > > > > > >> > Kind regards, > > > > >> > > > > > >> > Koen > > > > >> > > > > > >> > > > > > >> > > > > > >> > _______________________________________________ > > > > >> > Users mailing list > > > > >> > Users(a)ovirt.org > > > > >> > http://lists.ovirt.org/mailman/listinfo/users > > > > >> > > > > > >> > > > > > > > > > > > > > > > > > > > >