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(a)citytwist.net>
To: users(a)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-agenci...
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users