Yep, that's imagestatus column under images table. Regards, Vered ----- Original Message -----
From: "Vered Volansky" <vered@redhat.com> To: "Rob Abshear" <rabshear@citytwist.net> Cc: users@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@citytwist.net> To: users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users