Gian,

What version of CloudStack are you running?

I recall (quite a long time ago), there was a bug where volumes and snapshots weren't getting cleaned up correctly. 
If I recall correctly, that was somewhere around 4.2.

- Si

________________________________________
From: Gian Paolo Buono <gianpaolo.buono@gesca.it>
Sent: Tuesday, March 15, 2016 6:10 AM
To: users@cloudstack.apache.org
Subject: Re: [Where are the snapshot file]

Thank you it's correct :) , but now I have another question..

 From console of CloudStack I have deleted a snapshot, on the database the status is changed in Destroyed but the file it's stil on secondary storage:

ls -ltr d8736bdb-22c6-46fe-a27e-0ee5dc99a867.vhd
-rw-r--r-- 1 root root 1271296512 Mar 11 04:02 d8736bdb-22c6-46fe-a27e-0ee5dc99a867.vhd

Also in snapshots view sometimes the status is allocated...but what does it mean ?


Best Regards

On 03/15/2016 11:15 AM, Stavros Konstantaras wrote:

Hi Gian,

If you run the following query in MySQL and check the column “install_path” you will find the location of snapshot file in secondary storage:
<select * from cloud.snapshot_store_ref;>

I hope that it helps you.

Best Regards
Stavros


----------------------------
Stavros Konstantaras
Science faculty Research IT support (FEIOG)
University of Amsterdam, Science Park 904, 1098 XH

Fingerprint: E5E5 9B19 D1CD 88CD 4763  3465 A8DC 7C92 330F D59A



On 15 Mar 2016, at 11:11, Gian Paolo Buono <gianpaolo.buono@gesca.it><mailto:gianpaolo.buono@gesca.it> wrote:

Hi all, how can I know where are the snapshot file (vhd) on the
secondary storage ? Is there a mysql query ?

Kind regards