From: "Rob Abshear" <rabshear(a)citytwist.net&gt; 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

From: "Vered Volansky" <vered(a)redhat.com&gt; To: "Vered Volansky" <vered(a)redhat.com&gt; Cc: "Rob Abshear" <rabshear(a)citytwist.net&gt;, users(a)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(a)redhat.com&gt; > To: "Rob Abshear" <rabshear(a)citytwist.net&gt; > Cc: users(a)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(a)citytwist.net&gt; > > 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 > > > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users