yahoo-eng-team team mailing list archive

[OpenStack Infra <1912579@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.opendev.org/c/openstack/nova/+/771749
Committed: https://opendev.org/openstack/nova/commit/fc77ce191fe9393be815bc32e6da867808dab054
Submitter: "Zuul (22348)"
Branch:    master

commit fc77ce191fe9393be815bc32e6da867808dab054
Author: melanie witt <melwittt@xxxxxxxxx>
Date:   Thu Jan 21 04:14:51 2021 +0000

    Add --sleep option for archive_deleted_rows --until-complete
    
    Currently, when 'nova-manage db archive_deleted_rows' is run with
    the --until-complete option, the process will archive rows in batches
    in a tight loop, which can cause problems in busy environments where
    the aggressive archiving interferes with other requests trying to write
    to the database.
    
    This adds an option for users to specify an amount of time in seconds
    to sleep between batches of rows while archiving with --until-complete,
    allowing the process to be throttled.
    
    Closes-Bug: #1912579
    
    Change-Id: I638b2fa78b81919373e607458e6f68a7983a79aa


** Changed in: nova
       Status: In Progress => Fix Released

-- 
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/1912579

Title:
  nova-manage db archive_deleted_rows with --until-complete runs row
  batches without pausing between iterations

Status in OpenStack Compute (nova):
  Fix Released

Bug description:
  Currently, when 'nova-manage db archive_deleted_rows' is run with the
  --until-complete option, the process will archive rows in batches
  without pausing between iterations, which can cause problems in busy
  environments where the aggressive archiving interferes with other
  requests trying to write to the database.

  We could add a --sleep option for users to be able to specify a sleep
  time in seconds to wait between archives of batches of rows to
  throttle the process.

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