Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1593910 - FFU: openstack overcloud ffwd-upgrade run fails when nova services run on a different role than controller - TASK [Create cell0 db] fails with unable to find /root/.my.cnf.
FFU: openstack overcloud ffwd-upgrade run fails when nova services run on a d...
Status: CLOSED ERRATA
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates (Show other bugs)
13.0 (Queens)
All All
medium Severity medium
: z2
: 13.0 (Queens)
Assigned To: Emilien Macchi
Marius Cornea
: Triaged, ZStream
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2018-06-21 16:02 EDT by Marius Cornea
Modified: 2018-08-29 12:38 EDT (History)
8 users (show)

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


Attachments (Terms of Use)
sosreport (18.31 MB, application/x-xz)
2018-06-21 16:03 EDT, Marius Cornea
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
OpenStack gerrit 580393 None None None 2018-07-05 16:21 EDT
OpenStack gerrit 581361 None None None 2018-07-10 09:25 EDT
Red Hat Product Errata RHBA-2018:2574 None None None 2018-08-29 12:38 EDT

  None (edit)
Description Marius Cornea 2018-06-21 16:02:13 EDT
Description of problem:
FFU: openstack overcloud ffwd-upgrade run fails when nova services run on a different role than controller:

2018-06-21 15:03:56,663 p=21084 u=mistral |  TASK [Create cell0 db] *********************************************************
2018-06-21 15:03:56,745 p=21084 u=mistral |  skipping: [192.168.24.18] => {"changed": false, "skip_reason": "Conditional result was False"}
2018-06-21 15:03:59,060 p=21084 u=mistral |  fatal: [192.168.24.10]: FAILED! => {"changed": false, "msg": "unable to find /root/.my.cnf. Exception message: (2002, \"Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)\")"}

Indeed there is no /root/.my.cnf file on this custom role(it's only con controller nodes) and this is required by the mysql_db module:

https://github.com/openstack/tripleo-heat-templates/blob/master/docker/services/nova-api.yaml#L426-L429

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

How reproducible:
100%

Steps to Reproduce:
1. Deploy OSP10 with nova services running on a custom role different than controller
2. Upgrade undercloud to 11/12/13
3. Run ffwd-upgrade prepare
4. Run openstack overcloud ffwd-upgrade run 

Actual results:
Fails during the following task:
https://github.com/openstack/tripleo-heat-templates/blob/master/docker/services/nova-api.yaml#L426-L429

because there is no /root/.my.cnf file on the custom role making it impossible for the mysql_db task to run.

Expected results:
No failure.

Additional info:
Attaching sosreport.
Comment 1 Marius Cornea 2018-06-21 16:03 EDT
Created attachment 1453601 [details]
sosreport
Comment 4 Carlos Camacho 2018-07-02 08:21:03 EDT
(Triaging, already assigned) Please feel free to remove the Triage keyword if you believe so.
Comment 6 Carlos Camacho 2018-07-05 16:21:41 EDT
Fix in this case should be nova specific, moving the DB tasks to the mysql template.
Comment 20 Joanne O'Flynn 2018-08-15 04:05:18 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:37:32 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.