Bug 1421265

Summary: nova-manage db sync broke between RHOSP 9 => RHOSP 10 update
Product: Red Hat OpenStack Reporter: David Hill <dhill>
Component: openstack-novaAssignee: melanie witt <mwitt>
Status: CLOSED ERRATA QA Contact: Gabriel Szasz <gszasz>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 10.0 (Newton)CC: awaugama, berrange, dasmith, eglynn, jjoyce, kchamart, mwitt, sbauza, sferdjao, sgordon, srevivo, vromanso
Target Milestone: z3Keywords: Rebase, Triaged, ZStream
Target Release: 10.0 (Newton)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-nova-14.0.4-1.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-06-28 15:22:52 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 David Hill 2017-02-10 19:09:29 UTC 
Description of problem:
"openstack undercloud upgrade" broke with the following:
undercloud)$ nova-manage db syncWARNING: cell0 mapping not found - not syncing cell0.error: There are still 33 unmigrated records in the compute_nodes table. Migration cannot continue until all records have been migrated.

We worked around it with the following:
echo "delete from compute_nodes where deleted_at is not null; " | mysql -D nova


Version-Release number of selected component (if applicable):


How reproducible:
This time only

Steps to Reproduce:
1. Update from RHOSP 9 to RHOSP 10 where compute nodes were deleted
2.
3.

Actual results:
Fails

Expected results:
Succeeds

Additional info:
Comment 8 errata-xmlrpc 2017-06-28 15:22:52 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/RHSA-2017:1595