[ovirt-users] Disk's locked of VM

[Vered Volansky]

Sorry, got sent in the middle.

Andy,

What operation did you try to attempt that caused the disks to lock?

You do have a working engine, right?
Your'e supposed to be able to see the Disks' GUIDs under the Disks main tab (Id column).

The images GUIDs are available in the DB (images table) and through vdsClient getVolumesList <sdUUID> <spUUID> [imgUUID]
imgUUID should be the disk's GUID in the engine.
You should be able to get that data from vdsClient as well:
getImagesList <sdUUID>
relevant sql query:
select image_guid, imagestatus from images;

*image status 2 is locked...

The spUUID:
Either the datacenter GUID in the engine, or -
vdsClient -s 0 getConnectedStoragePoolsList, or in the db:
select * from storage_pool;

The StorageDomain's can be retrieved either by DB (bellow) or vdsClient:
getStorageDomainsList <spUUID>  (from above).
sql query:
select storage_name, id from storage_domains where storage_pool_id='<spUUID>';
 
----- Original Message -----
> From: "Andy Michielsen" <andy.michielsen at gmail.com>
> To: "Vered Volansky" <vered at redhat.com>
> Cc: users at ovirt.org
> Sent: Thursday, July 3, 2014 3:09:41 PM
> Subject: Re: [ovirt-users] Disk's locked of VM
> 
> Vered,
> 
> Where can I find the images GUIDs ?
> 
> Kind regards.snapshots' 
> 
> 
> 2014-06-30 17:40 GMT+02:00 Vered Volansky < vered at redhat.com > :
> 
> 
> Or better yet, just use:
> 
> >> <oVirtDir>/share/ovirt-engine/dbscripts/unlock_entity.sh
> 
> I suppose you have the images GUIDs from engine.
> 
> BUT -
> If the images never got released you might want to get to know what got them
> into this in the first place.
> You can send vdsm and engine logs from that period of time if you still got
> them, and we'll take a look.
> 
> Regards,
> Vered
> 
> ----- Original Message -----
> > From: "Vered Volansky" < vered at redhat.com >
> > To: "Andy Michielsen" < andy.michielsen at gmail.com >
> > Cc: users at ovirt.org
> > Sent: Monday, June 30, 2014 6:03:15 PM
> > Subject: Re: [ovirt-users] Disk's locked of VM
> > 
> > 
> > 
> > ----- Original Message -----
> > > From: "Andy Michielsen" < andy.michielsen at gmail.com >
> > > To: "Vered Volansky" < vered at redhat.com >
> > > Cc: users at ovirt.org
> > > Sent: Monday, June 30, 2014 4:57:05 PM
> > > Subject: Re: [ovirt-users] Disk's locked of VM
> > > 
> > > 
> > > 
> > > Hello,
> > > 
> > > How can I connect to my postgress database ?
> > Try this:
> > psql -d engine -U engine .
> > 
> > This is assuming you're using password authentication.
> > If you aren't please send me your pg_hba.conf settings and we'll go forward
> > from there:
> > 
> > Fedora,RHEL /var/lib/pgsql/data/pg_hba.conf
> > Debian /etc/postgresql/*/main/pg_hba.conf
> > Gentoo /etc/postgresql-*/pg_hba.conf
> > 
> > > 
> > > Kind regards.
> > > On Jun 30, 2014 10:10 AM, "Vered Volansky" < vered at redhat.com > wrote:
> > > 
> > > 
> > > Hi Andy,
> > > 
> > > In the DB, try
> > > update images set imagestatus = 1 where imagestatus = 2;
> > > commit;
> > > 
> > > Let me know if this helps.
> > > 
> > > Regards,
> > > Vered
> > > 
> > > ----- Original Message -----
> > > > From: "Andy Michielsen" < andy.michielsen at gmail.com >
> > > > To: users at ovirt.org
> > > > Sent: Friday, June 27, 2014 11:08:47 AM
> > > > Subject: [ovirt-users] Disk's locked of VM
> > > > 
> > > > Hello all,
> > > > 
> > > > Does anyone know how I can check if a VM's disk are indeed locked or
> > > > not.
> > > > The
> > > > engine tell's me they are locked but this is now already 16 day's and
> > > > counting.
> > > > 
> > > > I already restarted every server involved but to no avail.
> > > > 
> > > > I can not remove, change or start the VM as long as the disks are
> > > > locked.
> > > > Can
> > > > I give a command to check the status of this machine in the CLI
> > > > enviroment
> > > > or after connecting to the database and checking a table (Realy don't
> > > > know
> > > > how to do this).
> > > > 
> > > > Kind regards.
> > > > 
> > > > _______________________________________________
> > > > 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
> > 
> 
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>