Bug 1159142

Summary: [RFE][cinder]: cinder db purge util
Product: Red Hat OpenStack Reporter: RHOS Integration <rhos-integ>
Component: openstack-cinderAssignee: Eric Harney <eharney>
Status: CLOSED ERRATA QA Contact: nlevinki <nlevinki>
Severity: medium Docs Contact:
Priority: medium    
Version: unspecifiedCC: adahms, eharney, markmc, scohen, ssainkar, yeylon
Target Milestone: Upstream M2Keywords: FutureFeature, OtherQA
Target Release: 7.0 (Kilo)   
Hardware: Unspecified   
OS: Unspecified   
URL: https://blueprints.launchpad.net/cinder/+spec/database-purge
Whiteboard: upstream_milestone_kilo-2 upstream_definition_approved upstream_status_implemented
Fixed In Version: openstack-cinder-2015.1.0-2.el7ost Doc Type: Enhancement
Doc Text:
This update adds functionality to 'cinder-manage db' to safely purge old "deleted" data from the Cinder database. This reduces database space usage and improves database performance.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2015-08-05 13:16:34 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description RHOS Integration 2014-10-31 04:07:37 UTC 
Cloned from launchpad blueprint https://blueprints.launchpad.net/cinder/+spec/database-purge.

Description:

Adding functionality to `cinder-manage db` to safely purge "deleted" data. This will have non-optional argument of nDays.
For example `cinder-manage db purge 60` will go into the cinder db, and delete from each table where 'deleted =! 0 and deleted_at > date_sub(NOW(), interval 60 day);'

This is a useful feature as Openstack matures and operators/admins are upgrading over time.

Specification URL (additional information):

None
Comment 7 errata-xmlrpc 2015-08-05 13:16:34 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2015:1548