yahoo-eng-team team mailing list archive

[melanie witt <1877189@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

nova.task_log database records are related to the server usage audit log
API [1] which is dependent on the [DEFAULT]/instance_usage_audit config
option being set to True (it defaults to False). Enablement of the
config option causes nova-compute to emit notifications which are
consumed by OpenStack Telemetry. When the config option is enabled,
records will be periodically created in the nova.task_log table. And
there is no cleanup of the records in nova.

I started a ML thread about the server usage audit log API awhile back
[2] and the conclusion was that deprecating or removing the API isn't
practical as there are systems in the wild still using it, so the best
action to take for now is to create a nova-manage command for cleaning
up old nova.task_log records.

I brought up the proposal in a nova meeting [3] and in the nova channel
[4] and the consensus was to treat it as a Wishlist bug so that it can
be backported upstream.

So this is a bug for the work to add a new 'nova-manage db
purge_task_log' command that offers a --before <datetime> option.

[1] http://eavesdrop.openstack.org/irclogs/%23openstack-nova/%23openstack-nova.2019-09-06.log.html#t2019-09-06T14:19:50
[2] http://lists.openstack.org/pipermail/openstack-discuss/2019-September/009245.html
[3] http://eavesdrop.openstack.org/meetings/nova/2019/nova.2019-10-17-14.00.log.html#l-306
[4] http://eavesdrop.openstack.org/irclogs/%23openstack-nova/%23openstack-nova.2019-10-17.log.html#t2019-10-17T14:54:39

** Affects: nova
     Importance: Wishlist
     Assignee: melanie witt (melwitt)
         Status: Confirmed


** Tags: nova-manage

** Changed in: nova
   Importance: Undecided => Wishlist

** Changed in: nova
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1877189

Title:
  nova.task_log database records are never deleted

Status in OpenStack Compute (nova):
  Confirmed

Bug description:
  nova.task_log database records are related to the server usage audit
  log API [1] which is dependent on the [DEFAULT]/instance_usage_audit
  config option being set to True (it defaults to False). Enablement of
  the config option causes nova-compute to emit notifications which are
  consumed by OpenStack Telemetry. When the config option is enabled,
  records will be periodically created in the nova.task_log table. And
  there is no cleanup of the records in nova.

  I started a ML thread about the server usage audit log API awhile back
  [2] and the conclusion was that deprecating or removing the API isn't
  practical as there are systems in the wild still using it, so the best
  action to take for now is to create a nova-manage command for cleaning
  up old nova.task_log records.

  I brought up the proposal in a nova meeting [3] and in the nova
  channel [4] and the consensus was to treat it as a Wishlist bug so
  that it can be backported upstream.

  So this is a bug for the work to add a new 'nova-manage db
  purge_task_log' command that offers a --before <datetime> option.

  [1] http://eavesdrop.openstack.org/irclogs/%23openstack-nova/%23openstack-nova.2019-09-06.log.html#t2019-09-06T14:19:50
  [2] http://lists.openstack.org/pipermail/openstack-discuss/2019-September/009245.html
  [3] http://eavesdrop.openstack.org/meetings/nova/2019/nova.2019-10-17-14.00.log.html#l-306
  [4] http://eavesdrop.openstack.org/irclogs/%23openstack-nova/%23openstack-nova.2019-10-17.log.html#t2019-10-17T14:54:39

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1877189/+subscriptions