----- Original Message -----
> From: "Koen Vanoppen" <vanoppen.koen@gmail.com>
> To: "Omer Frenkel" <ofrenkel@redhat.com>, users@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@redhat.com>:
>
> >
> >
> > ----- Original Message -----
> > > From: "Koen Vanoppen" <vanoppen.koen@gmail.com>
> > > To: "Omer Frenkel" <ofrenkel@redhat.com>, users@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@gmail.com>:
> > >
> > > > 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@redhat.com>:
> > > >
> > > >>
> > > >>
> > > >> ----- Original Message -----
> > > >> > From: "Koen Vanoppen" <vanoppen.koen@gmail.com>
> > > >> > To: users@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@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@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@ovirt.org
> > > >> > http://lists.ovirt.org/mailman/listinfo/users
> > > >> >
> > > >>
> > > >
> > > >
> > >
> >
>