Open Stack

Hi,
that's right. That's that table that points to the physical location of 
the images (note that images are named after their UUIDs)

- Razique

On 14 Nov 2013, at 1:57, Narayanan, Krishnaprasad wrote:

> To be precise enough, you are referring to "Images" table in Glance 
> database. Is this correct?
> I also see an image\_properties table that has a column "deleted" and 
> ID.
>
> From: Razique Mahroua [mailto:razique.mahroua at gmail.com]
> Sent: Donnerstag, 14. November 2013 09:55
> To: Narayanan, Krishnaprasad
> Cc: openstack at lists.openstack.org
> Subject: Re: [Openstack] Removing unused images using Glance APIs
>
>
> Ok, so you can deleted safely the unused ones with the SQL commands.
> As for the physical files on the server (usually 
> /var/lib/glance/images), you need to check that against the Glance 
> database:
> select UUID where deleted =1
> You will retrieve a list of unused UUIDs, and these files can be 
> removed as well
>
> Razique
>
> On 14 Nov 2013, at 0:06, Narayanan, Krishnaprasad wrote:
>
> By removing unused images, I mean here is the extra images in the 
> image store which were supposed to be deleted but they still exist. I 
> want to persist the images that are connected to active instances and 
> base images using which snapshots were created.
>
> -----Original Message-----
> From: Razique Mahroua 
> [mailto:razique.mahroua at gmail.com<mailto:razique.mahroua at gmail.com>]
> Sent: Donnerstag, 14. November 2013 04:08
> To: Narayanan, Krishnaprasad
> Cc: 
> openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
> Subject: Re: [Openstack] Removing unused images using Glance APIs
>
> But didn't you wanted to remove the unused images in the first place?
> if so, then running the SQL commands I gave you will help you to find 
> unused images :)
>
> On 13 Nov 2013, at 16:43, Narayanan, Krishnaprasad wrote:
>
> If I want to retain the base image for launching new VMs, then I may
> lose them. So how do I retain it?
>
> -----Original Message-----
> From: Razique Mahroua 
> [mailto:razique.mahroua at gmail.com<mailto:razique.mahroua at gmail.com>]
> Sent: Donnerstag, 14. November 2013 01:16
> To: Narayanan, Krishnaprasad
> Cc: 
> openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
> Subject: Re: [Openstack] Removing unused images using Glance APIs
>
> Same :)
> as long as the snapshot is created (make sure it's finished though!)
> then you don't need the base image
>
> On 13 Nov 2013, at 16:15, Narayanan, Krishnaprasad wrote:
>
> What happens if there is an snaspshot created but there are no
> instances launched?
>
> From: Razique Mahroua 
> [mailto:razique.mahroua at gmail.com<mailto:razique.mahroua at gmail.com>]
> Sent: Donnerstag, 14. November 2013 01:11
> To: Narayanan, Krishnaprasad
> Cc: 
> openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
> Subject: Re: [Openstack] Removing unused images using Glance APIs
>
> Volumes snap depends on the active instance, that means you don't
> need
> the base image afterwards.
> Just check all actives instances
> select \* from instances where deleted <> 1
> OR :
> select image\_id from instances where deleted = 0
>
> Razique
>
> On 13 Nov 2013, at 15:47, Narayanan, Krishnaprasad wrote:
>
> Hi
>
> If I understand it correctly, this addresses the active instances and
> its images. Can I know how one should take care of instance and
> volume
> snapshots?
>
> Thanks,
> Krishnaprasad
> From: Razique Mahroua
> [mailto:razique.mahroua at gmail.com<mailto:razique.mahroua at gmail.com>razique.mahroua at gmail.com<mailto:razique.mahroua at gmail.com>]
> Sent: Mittwoch, 13. November 2013 14:40
> To: Narayanan, Krishnaprasad
> Cc:
> openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>
> Subject: Re: [Openstack] Removing unused images using Glance APIs
>
> Hi. I think there is not any API for that unfortunately....
> But there is a field into the database that indicates the image ID.
> So
> if you select all active instances and select the unique images ID
> entries, you can compare them against the Glance images. A BASH
> script
> should be sufficient.
>
> Razique
>
> On Wednesday, November 13, 2013, Narayanan, Krishnaprasad wrote:
> Hallo All,
>
> In our testbed we have Openstack ESSEX. I am in the process of
> cleaning up the image store. Can I know are there any APIs in Glance
> or Nova that can help me in this process?
>
> Thanks,
> Krishnaprasad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131114/567715a0/attachment.html>