Bug 1541693 - [RFE] nova migration-list table needs the ability to be purged like keystone expired tokens
Summary: [RFE] nova migration-list table needs the ability to be purged like keystone ...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 9.0 (Mitaka)
Hardware: Unspecified
OS: Linux
medium
high
Target Milestone: ---
: ---
Assignee: OSP DFG:Compute
QA Contact: OSP DFG:Compute
URL:
Whiteboard:
Depends On: 1154875 1540637 1595886 1595887
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-02-04 04:31 UTC by rohit londhe
Modified: 2023-03-21 18:44 UTC (History)
12 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-07-07 11:13:13 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker OSP-8788 0 None None None 2022-08-09 11:28:22 UTC

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.


Note You need to log in before you can comment on or make changes to this bug.