Bug 1801364 - [osp 16][upgrades] Instances not visible when hidden=NULL
Summary: [osp 16][upgrades] Instances not visible when hidden=NULL
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 16.0 (Train)
Hardware: All
OS: Linux
urgent
urgent
Target Milestone: async
: 16.0 (Train on RHEL 8.1)
Assignee: smooney
QA Contact: Paras Babbar
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-02-10 17:55 UTC by smooney
Modified: 2020-12-21 19:37 UTC (History)
12 users (show)

Fixed In Version: openstack-nova-20.1.1-0.20200209065541.8363905.el8ost
Doc Type: Bug Fix
Doc Text:
This update fixes a bug where where list operations failed to show instances after an upgrade to the Stein release of OpenStack. In deployments with large databases, this bug corrupted instance records, preventing the instances from appearing in list operations. Support for upgrades to Red Hat OpenStack Plaform (RHOSP) 16.0 begins with the release of RHOSP 16.1. RHOSP 16.1 and higher include this fix, so the bug will not affect RHOSP upgrades.
Clone Of:
Environment:
Last Closed: 2020-05-14 12:10:08 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1862205 0 None None None 2020-02-10 17:55:41 UTC
OpenStack gerrit 706582 0 None MERGED Fix instance.hidden migration and querying 2020-07-27 14:28:54 UTC
Red Hat Product Errata RHBA-2020:2154 0 None None None 2020-05-14 12:10:45 UTC

Description smooney 2020-02-10 17:55:41 UTC
During an upgrade of a cloud from Stein to Train, there is a migration which adds the `hidden` field to the database. In that migration, it was assumed that it does not backfill all of the columns.

It was discovered that when the number of instance records in the db exceeds ~ 300K the migration can fail to set all the fields resulting in some instnaces are no longer viable when you do openstack server list.

This was reported and tracked upstream by https://bugs.launchpad.net/nova/+bug/1862205 and addressed upstream by https://review.opendev.org/#/c/706582/

This bugzilla tracks any downstream work that needs to be completed to ensure this is  highlighted in release notes and fix in the next oap 16 async.

Comment 18 errata-xmlrpc 2020-05-14 12:10:08 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, 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-2020:2154


Note You need to log in before you can comment on or make changes to this bug.