Bug 2170683 - [16.2] Nova DB archiving not working with thousands of records
Summary: [16.2] Nova DB archiving not working with thousands of records
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 16.2 (Train)
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: z6
: 16.2 (Train on RHEL 8.4)
Assignee: melanie witt
QA Contact: OSP DFG:Compute
URL:
Whiteboard:
Depends On: 2170685
Blocks: 2168206
TreeView+ depends on / blocked
 
Reported: 2023-02-16 22:26 UTC by melanie witt
Modified: 2023-11-08 19:19 UTC (History)
16 users (show)

Fixed In Version: openstack-nova-20.6.2-2.20230814165222.8a24acd.el8ost
Doc Type: Bug Fix
Doc Text:
Before this update, the `db archive` command did not handle large-scale databases efficiently because of the way the command processed child tables. The `db archive` command did not make significant progress, even if you specified a high value for `max_rows` and ran the command repeatedly over long periods of time. With this update, the database archiving code handles large-scale databases with a high number of deleted rows more efficiently, and the `db archive` command makes more predictable progress on large-scale databases.
Clone Of: 2168206
: 2170685 (view as bug list)
Environment:
Last Closed: 2023-11-08 19:18:31 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
OpenStack gerrit 877055 0 None MERGED testing: Fix and robustify archive_deleted_rows test 2023-07-17 15:28:59 UTC
OpenStack gerrit 877056 0 None MERGED database: Archive parent and child rows "trees" one at a time 2023-07-17 15:28:59 UTC
Red Hat Issue Tracker OSP-22475 0 None None None 2023-02-16 22:28:39 UTC
Red Hat Product Errata RHBA-2023:6307 0 None None None 2023-11-08 19:19:07 UTC

Comment 13 errata-xmlrpc 2023-11-08 19:18:31 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (Red Hat OpenStack Platform 16.2.6 (Train) bug fix and enhancement advisory), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2023:6307
Note You need to log in before you can comment on or make changes to this bug.