Bug 1541693

Summary: [RFE] nova migration-list table needs the ability to be purged like keystone expired tokens
Product: Red Hat OpenStack Reporter: rohit londhe <rlondhe>
Component: openstack-novaAssignee: OSP DFG:Compute <osp-dfg-compute>
Status: CLOSED NOTABUG QA Contact: OSP DFG:Compute <osp-dfg-compute>
Severity: high Docs Contact:
Priority: medium    
Version: 9.0 (Mitaka)CC: berrange, dasmith, eglynn, kchamart, mbooth, mschuppe, pneedle, sbauza, sferdjao, sgordon, srevivo, vromanso
Target Milestone: ---Keywords: FutureFeature, Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-07-07 11:13:13 UTC Type: Bug
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: 1154875, 1540637, 1595886, 1595887    
Bug Blocks:    

Description rohit londhe 2018-02-04 04:31:00 UTC
Description of problem:

Due to multiple migrations of instances as a part of maintenance activity, nova migration-list contains data from the point the system was initially built, this means that there are transactions listed from 2016 till the present day.

Is there any way we can control the size of Nova migrations table?

Version-Release number of selected component (if applicable):


How reproducible:

Migrate instances and check if the record found in nova migration-list can be deleted/removed considering how old they are?

Steps to Reproduce:

# nova migration-list --host <hostname>

Actual results:

Currently, nova migration-list shows entire data right when first migration was performed.

Expected results:
nova migration-list should show the list of migrated instances as per specified date/time 

OR 

Is there any way to remove old migration list record from the database.


Additional info:

Is it possible to delete/remove an old list from the database, Any idea where this list gets stored?

Comment 2 Sylvain Bauza 2018-02-09 16:29:10 UTC
We accepted that problem as a RFE, see the blocking BZ #1540637

Comment 4 Paul Needle 2018-07-07 11:13:13 UTC
Hi all, 

Nova already has a cron job that is supposed to purge data such as that which is described within this Bugzilla.

The cron job does not succeed if /var/log/nova/nova-manage.log is owned by root rather than Nova. Please set ownership of that log file to nova.

Kind regards,
Paul.