[Users] VM is locked. Export never finishes

[Vered Volansky]

For future unlocking you may also use packaging/dbscrips/unlock_entity.sh, which should be cleaner.

----- Original Message -----
> From: "Vered Volansky" <vered at redhat.com>
> To: "Vered Volansky" <vered at redhat.com>
> Cc: "Rob Abshear" <rabshear at citytwist.net>, users at ovirt.org
> Sent: Wednesday, October 30, 2013 9:07:18 AM
> Subject: Re: [Users] VM is locked.  Export never finishes
> 
> Yep, that's imagestatus column under images table.
> 
> Regards,
> Vered
> 
> ----- Original Message -----
> > From: "Vered Volansky" <vered at redhat.com>
> > To: "Rob Abshear" <rabshear at citytwist.net>
> > Cc: users at ovirt.org
> > Sent: Wednesday, October 30, 2013 7:45:35 AM
> > Subject: Re: [Users] VM is locked.  Export never finishes
> > 
> > You can't update a view. It has to be a table.
> > The table you're looking for is called images, if I'm not mistaken. I can't
> > currently log into my db to verify the name.
> > 
> > Regards,
> > Vered
> > 
> > ----- Original Message -----
> > > From: "Rob Abshear" <rabshear at citytwist.net>
> > > To: users at ovirt.org
> > > Sent: Tuesday, October 29, 2013 5:46:29 PM
> > > Subject: [Users] VM is locked.  Export never finishes
> > > 
> > > I was exporting an image to move it to another domain.  It has been
> > > running for hours now, and I don't think it will finish.  I tried
> > > unlocking the image manually using the following commands:
> > > 
> > > psql -d engine -U postgres
> > > 
> > > SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM
> > > vm_images_view where imagestatus = 2);
> > > 
> > > SELECT image_guid from vm_images_view where imagestatus=2;
> > > 
> > > Update vm_images_view SET imagestatus=1 where image_guid =
> > > e275ff80-9633-4304-890d-1bbf8d7217e4
> > > 
> > > The first two commands run fine, and I can get the guid of the image.
> > > But the last command just dumps me back to the command prompt and the
> > > image remains locked.
> > > 
> > > 
> > > 
> > > --
> > > 
> > > 
> > > *NADA Convention & Expo*:  January 24-27, 2014 - New Orleans, LA - Booth
> > > 5001
> > > <http://www.bbb.org/south-east-florida/business-reviews/advertising-agencies/citytwist-in-boca-raton-fl-90033448><http://www.bbb.org/south-east-florida/business-reviews/advertising-agencies/citytwist-in-boca-raton-fl-90033448>
> > > _______________________________________________
> > > Users mailing list
> > > Users at ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> > > 
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> > 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>