This rhbz is for the deployment part of the RFE. The --task-log flag should be added to the existing 'nova-manage db archive_deleted_rows' command that runs during the nova_cron cron job.

There are some concerns which require knowledge of Telemetry that we need to consider when adding the --task-log flag. The task_log table records are exposed via nova's /os-instance_usage_audit_log API, which is called by the Telemetry service to collect usage data.

We will need to know before proceeding:

• Does Telemetry still use this API? If not, then we need not care about how long task_log records are retained.

• How long does Telemetry need the task_log records to stay available in nova after they are generated?

By default, if the --before flag is not also used when calling 'nova-manage db archive_deleted_rows', all task_log records will be archived at the time of the call, leaving nothing behind. In order to preserve some task_log records for historical and audit purposes, --task-log must be used along with --before.

[1] https://docs.openstack.org/api-ref/compute/?expanded=list-server-usage-audits-detail#list-server-usage-audits

+++ This bug was initially created as a clone of Bug #1780867 +++

I'm going to use this rhbz for an RFE to add cleanup for nova.task_log database records as a new nova-manage command, as described here:

http://lists.openstack.org/pipermail/openstack-discuss/2019-September/009245.html

This will be done as a Wishlist bug upstream.