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

[melanie witt]

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.

[melanie witt (melwitt)]

Patch proposed at https://review.opendev.org/c/openstack/nova/+/771749

[OpenStack Infra (hudson-openstack)]

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 address hidden>
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

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/nova 24.0.0.0rc1 release candidate.