[ovirt-users] Issues importing VM from Export Domain

[Wesley Stewart]

I figured out part of it!

After I figured out how to access the DB, I was able to update to correct
entry in the "vm_dynamic" status  to 0.  I did this by:

sudo su postgres

psql engine -c "SELECT vm_guid, vm_name from vm_static WHERE vm_name =
'Clonezilla_Server';"

Returns:0eb29824-f1ca-4d27-bf57-a3ed36c40c18

psql engine -c "update vm_dynamic SET status=0 where
vm_guid='0eb29824-f1ca-4d27-bf57-a3ed36c40c18';"

After this I was able to delete the entry from ovirt. I am not sure why a
disk would not import, but at least I dont have a locked image in the queue
anymore!


On Mon, Aug 14, 2017 at 12:24 AM, Wesley Stewart <wstewart3 at gmail.com>
wrote:

> I was doing some testing and recently rebuilt my homelab using a Xeon-D
> based board.  I did not have anything too important, so I thought this
> would be a good chance to test re-importing my backups and seeing how well
> it works.
>
> I created a new export domain and copied all of my old VM's into this new
> export domain.  But the problem is, the images are in a "Locked" state.
> The console tells me:
>
> Aug 13, 2017 11:59:38 PM
> Failed to import Vm Clonezilla_Server_BACKUP_20170807_010018 to Data
> Center OVIRT-Datacenter, Cluster OVIRT-Cluster
> Aug 13, 2017 11:59:38 PM
> VDSM command DeleteImageGroupVDS failed: Image does not exist in domain:
> u'image=a5c8780e-3166-4801-b71a-1ef7d9b21783, domain=35cd8fab-4347-4201-
> bf4e-4dcbde19fb0f'
> Aug 13, 2017 11:59:37 PM
> VDSM OVIRT-Host command HSMGetAllTasksStatusesVDS failed: low level Image
> copy failed
>
> This happens for all the VMs shown in the Export-Domain.
>
> I also tried the unlock_entity.sh script, but I am having some postgres
> access issues:
>
> unlock_entity.sh -r -t vm -i Clonezilla_Server -s localhost
> psql: FATAL:  no PostgreSQL user name specified in startup packet
> FATAL: Cannot execute sql command: --file=./unlock_entity.sql
>
> I thought I could just poke around the database by running:
>
> psql -d engine -U postgres
>
> But this also fails
> psql: FATAL:  Peer authentication failed for user "postgres"
>
> Was just hoping someone had some suggestions.  I can't event delete this VM!  Thanks!
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170814/446334ef/attachment.html>