Bug 1801364

Summary:	[osp 16][upgrades] Instances not visible when hidden=NULL
Product:	Red Hat OpenStack	Reporter:	smooney
Component:	openstack-nova	Assignee:	smooney
Status:	CLOSED ERRATA	QA Contact:	Paras Babbar <pbabbar>
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	16.0 (Train)	CC:	amodi, dasmith, eglynn, gregraka, jamsmith, jhakimra, kchamart, mgarciac, pbabbar, sbauza, sgordon, vromanso
Target Milestone:	async	Keywords:	TestOnly, Triaged, UpgradeBlocker, ZStream
Target Release:	16.0 (Train on RHEL 8.1)
Hardware:	All
OS:	Linux
Whiteboard:
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.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-05-14 12:10:08 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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