Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1585765 - FFU: after running openstack overcloud ffwd-upgrade run /var/log/nova/nova-manage.log on controller-0 shows InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'") errors [NEEDINFO]
FFU: after running openstack overcloud ffwd-upgrade run /var/log/nova/nova-ma...
Status: CLOSED ERRATA
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates (Show other bugs)
13.0 (Queens)
Unspecified Unspecified
urgent Severity urgent
: z2
: 13.0 (Queens)
Assigned To: Lee Yarwood
Archit Modi
: ReleaseNotes, Reopened, Triaged, ZStream
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2018-06-04 12:32 EDT by Marius Cornea
Modified: 2018-08-29 12:37 EDT (History)
6 users (show)

See Also:
Fixed In Version: openstack-tripleo-heat-templates-8.0.2-48.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2018-08-29 12:36:45 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
joflynn: needinfo? (lyarwood)


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Launchpad 1775868 None None None 2018-06-08 11:12 EDT
OpenStack gerrit 573740 None master: MERGED tripleo-heat-templates: ffu: Add missing nova-manage db sync for Pike upgrade (I51f40254acee435ed4e60c0e97b5ced86fd67fc2... 2018-07-18 21:56 EDT
Red Hat Product Errata RHBA-2018:2574 None None None 2018-08-29 12:37 EDT

  None (edit)
Description Marius Cornea 2018-06-04 12:32:40 EDT
Description of problem:
FFU: after running openstack overcloud ffwd-upgrade run /var/log/nova/nova-manage.log on controller-0 (the bootstrap one) shows such errors:

2018-06-04 15:52:26.307 424237 ERROR oslo_db.sqlalchemy.exc_filters [req-45a7f7d2-068f-4adc-b27e-f44a64b76d55 - - - - -] DBAPIError exception wrapped from (pymysql.err.InternalError) (1054, u"Unknown column 'services.uuid' in 'field list'") [SQL: u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.uuid AS services_uuid, services.host AS services_host, services.`binary` AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.disabled_reason AS services_disabled_reason, services.last_seen_up AS services_last_seen_up, services.forced_down AS services_forced_down, services.version AS services_version \nFROM services \nWHERE services.deleted = %(deleted_1)s AND services.uuid IS NULL \n LIMIT %(param_1)s'] [parameters: {u'param_1': 50, u'deleted_1': 0}]: InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'")


Version-Release number of selected component (if applicable):
openstack-tripleo-heat-templates-8.0.2-29.el7ost.noarch

How reproducible:
100%

Steps to Reproduce:
1. Deploy OSP10
2. Upgrade undercloud to OSP11/12/13
3. Run openstack overcloud ffwd-upgrade prepare [...]
4. Run openstack overcloud ffwd-upgrade run
5. Wait for the process to finish successfully
6. Log in to controller-0
7. Check /var/log/nova/nova-manage.log

Actual results:
InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'") errors

Expected results:
No errors.

Additional info:
Attaching controller-0 sosreport.
Comment 3 Ollie Walsh 2018-06-08 08:24:36 EDT

*** This bug has been marked as a duplicate of bug 1520463 ***
Comment 20 Joanne O'Flynn 2018-08-15 03:51:39 EDT
This bug is marked for inclusion in the errata but does not currently contain draft documentation text. To ensure the timely release of this advisory please provide draft documentation text for this bug as soon as possible.

If you do not think this bug requires errata documentation, set the requires_doc_text flag to "-".


To add draft documentation text:

* Select the documentation type from the "Doc Type" drop down field.

* A template will be provided in the "Doc Text" field based on the "Doc Type" value selected. Enter draft text in the "Doc Text" field.
Comment 22 errata-xmlrpc 2018-08-29 12:36:45 EDT
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-2018:2574

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