Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1593910

Summary: 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.
Product: Red Hat OpenStack Reporter: Marius Cornea <mcornea>
Component: openstack-tripleo-heat-templatesAssignee: Emilien Macchi <emacchi>
Status: CLOSED ERRATA QA Contact: Marius Cornea <mcornea>
Severity: medium Docs Contact:
Priority: medium    
Version: 13.0 (Queens)CC: ccamacho, dbecker, emacchi, jstransk, lyarwood, mbultel, mburns, morazi
Target Milestone: z2Keywords: Triaged, ZStream
Target Release: 13.0 (Queens)   
Hardware: All   
OS: All   
Whiteboard:
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 16:37:32 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:
Attachments:
Description Flags
sosreport none

Description Marius Cornea 2018-06-21 20:02:13 UTC
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 20:03:04 UTC
Created attachment 1453601 [details]
sosreport

Comment 4 Carlos Camacho 2018-07-02 12:21:03 UTC
(Triaging, already assigned) Please feel free to remove the Triage keyword if you believe so.

Comment 6 Carlos Camacho 2018-07-05 20:21:41 UTC
Fix in this case should be nova specific, moving the DB tasks to the mysql template.

Comment 20 Joanne O'Flynn 2018-08-15 08:05:18 UTC
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 16:37:32 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-2018:2574