nova-manage archive_deleted_rows date limit
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Wishlist
|
Jake Yip |
Bug Description
Description
===========
Currently we have a large number of rows in our nova databases, which will greatly benefit from `nova-manage archive_
Reading the code, however, reveals that there is no ability to do that. Currently, it has a --max-rows, but there are certain shortcomings with this option
1) related records are archived inconsistently. Due to foreign keys, it has to archive fk tables first. It will take up to `--max-rows` from the first table it encounters, working its way through all tables eventually reaching `instances` table last. What this means, is that instances is always archived last. An instance might have all of it's information in fk tables archived before itself is.
2) there is no ability to keep records up to certain timerange ago.
We are working on an in-house patch to achieve this. If this is of use to the community I'd be happy to work on this to be included upstream.
Environment
===========
We are running Newton Nova
tags: | added: cells nova-manage |
Changed in nova: | |
assignee: | nobody → Surya Seetharaman (tssurya) |
importance: | Undecided → Wishlist |
Changed in nova: | |
importance: | Wishlist → Low |
Changed in nova: | |
status: | New → Confirmed |
Changed in nova: | |
assignee: | Surya Seetharaman (tssurya) → nobody |
Changed in nova: | |
assignee: | nobody → Jake Yip (waipengyip) |
It it true that we do not have a way of archiving records according to the time of deletion, the "delete_at" field could be used along with adding a new tag to nova-manage archive_ deleted_ rows. The points mentioned by the reporter for wanting this are noted and it would certainly be helpful to delete time range based records.