Bug 894917

Summary: RFE: Support database row archiving/deletion
Product: Red Hat OpenStack Reporter: Perry Myers <pmyers>
Component: openstack-novaAssignee: David Ripton <dripton>
Status: CLOSED ERRATA QA Contact: Brent Eagles <beagles>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.0 (Folsom)CC: ajeain, dallan, dripton, jkt, markmc, mlopes, ndipanov, nobody, sgordon
Target Milestone: Upstream M1Keywords: FutureFeature, OtherQA
Target Release: 4.0   
Hardware: All   
OS: Linux   
URL: https://blueprints.launchpad.net/nova/+spec/db-archiving
Whiteboard:
Fixed In Version: openstack-nova-2013.2-0.8.b2.el6ost Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-12-19 23:57:14 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:
Bug Depends On: 960644, 1221962    
Bug Blocks: 975499    

Description Perry Myers 2013-01-14 01:41:21 UTC
This tracks upstream blueprint: https://blueprints.launchpad.net/nova/+spec/db-archiving

Comment 1 David Ripton 2013-02-18 18:47:52 UTC
The upstream development work is done for this blueprint; it will be in Grizzly final.

Comment 4 David Ripton 2013-03-05 16:22:27 UTC
There's an upstream bug related to this: https://bugs.launchpad.net/nova/+bug/1137977  Foreign keys mess up archiving.  I need to fix this by Grizzly final.

Comment 5 David Ripton 2013-03-26 15:19:14 UTC
Fixed the upstream bug https://bugs.launchpad.net/nova/+bug/1137977 in upstream commit bb1977718d697565d

They found another RHEL-only test failure bug https://bugs.launchpad.net/nova/+bug/1158828  It appears to be a problem with SQLAlchemy not reliably supporting SQLite foreign key constraints with the old version of SQLite that comes with RHEL 6.4  My upstream fix for that was to just skip the offending unit test if SQLite < 3.7 was detected.  Upstream commit c07ec51dba9b1

The backport needs to also include those two commits.

Comment 6 David Ripton 2013-04-24 18:45:08 UTC
Setting to POST because these commits are already in upstream Grizzly and will naturally get into 3.0.

Comment 12 errata-xmlrpc 2013-12-19 23:57:14 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.

http://rhn.redhat.com/errata/RHEA-2013-1859.html

Comment 13 Red Hat Bugzilla 2023-09-14 01:40:12 UTC
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days