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 <[email protected]> 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp

