advice needed: snapshot DB/table cleanup

2018-08-17 Thread Andrija Panic
HI guys, hi Mike.T., we have removed all NFS and CEPH storages, and are now purely running on SolidFire (KVM). Now I want to do serious snapshot cleanup (for reason explained at the end of email) - since "snapshots" and "snapshot_store_ref" tables are a complete mess (i.e. snapshot is destroyed w

Re: advice needed: snapshot DB/table cleanup

2018-08-17 Thread Daan Hoogland
andrija, On Fri, Aug 17, 2018 at 11:23 AM, Andrija Panic wrote: > HI guys, hi Mike.T., > > we have removed all NFS and CEPH storages, and are now purely running on > SolidFire (KVM). > > Now I want to do serious snapshot cleanup (for reason explained at the end > of email) - since "snapshots" an

Re: advice needed: snapshot DB/table cleanup

2018-08-17 Thread Andrija Panic
Hi Daan, thx for the reply, so yes I would not touch SF just for sake of magic, whatever - otherwise I can remove them in same fashion (. the second "is this the same" - its not -first SQL - I delete from snapshot_store_ref where the template is either DESTROYED or has REMOVED date set in the ma

RE: Combining Apache CloudStack Documentation

2018-08-17 Thread Paul Angus
HI All, My Todo list is pretty much complete, I just need to ask infra to set up a webhook. So to sum up - The consolidated documentation is live athttp://docs.cloudstack.apache.org - The website points to the new documentation location and has links to the 'archived' documentation - The o

Re: advice needed: snapshot DB/table cleanup

2018-08-17 Thread Tutkowski, Mike
Hi Andrija, I like the way you wrote your SQL for the cloud.snapshots_store_ref table. It will make sure SolidFire snapshots remain in that table. Even if some of those are in the Deleted state, that’s OK. Perhaps the system will clean them up as expected in newer versions of CloudStack (otherw