Bug 1614478

Summary: FFWD: After upgrade, nova cell0 needs to be updated to remove bind_address and add proper database URL
Product: Red Hat OpenStack Reporter: Darin Sorrentino <dsorrent>
Component: openstack-tripleo-heat-templatesAssignee: Lukas Bezdicka <lbezdick>
Status: CLOSED ERRATA QA Contact: Ronnie Rasouli <rrasouli>
Severity: high Docs Contact:
Priority: high    
Version: 13.0 (Queens)CC: ccamacho, hbrock, jslagle, mburns, sgolovat, shdunne
Target Milestone: z7Keywords: Triaged, ZStream
Target Release: 13.0 (Queens)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-tripleo-heat-templates-8.3.1-34.el7ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1716447 (view as bug list) Environment:
Last Closed: 2019-07-10 13:03:16 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:
Bug Depends On: 1651136    
Bug Blocks: 1716447    

Description Darin Sorrentino 2018-08-09 17:16:42 UTC
Description of problem:

At the completion of the FFU process cell0 still has bind_address as part of the database URL.  This should be changed over to the proper value: 


+---------+--------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+
|   Name  |                 UUID                 |                                                                                                                                Transport URL                                                                                                                                |                                                          Database Connection                                                           |
+---------+--------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+
|  cell0  | 00000000-0000-0000-0000-000000000000 |                                                                                                                                    none:/                                                                                                                                   |                        mysql+pymysql://nova:YpUaGQhmKsJ8WMp6XwVNwUCfk.1.16/nova?bind_address=172.16.1.11                        |
| default | 7f6f88ad-6e9a-4c55-8b8a-1fbba45db9bd | rabbit://guest:e8VjwpFtg7kyq9NQXpEN2Wj2E.localdomain:5672,guest:e8VjwpFtg7kyq9NQXpEN2Wj2E.localdomain:5672,guest:e8VjwpFtg7kyq9NQXpEN2Wj2E.localdomain:5672/?ssl=0 | mysql+pymysql://nova:YpUaGQhmKsJ8WMp6XwVNwUCfk.1.16/nova?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf |
+---------+--------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+


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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 9 Ronnie Rasouli 2019-06-24 13:56:27 UTC
after FFU control plane update, docker nova_api has no  bind_address 
(overcloud) [stack@undercloud-0 ~]$ sudo nova-manage cell_v2 list_cells
+---------+--------------------------------------+-----------------------------------------------------------------------+---------------------------------------------------+
|   Name  |                 UUID                 |                             Transport URL                             |                Database Connection                |
+---------+--------------------------------------+-----------------------------------------------------------------------+---------------------------------------------------+
|  cell0  | 00000000-0000-0000-0000-000000000000 |                                 none:/                                | mysql+pymysql://nova:****@192.168.24.1/nova_cell0 |
| default | fd7310a6-2346-40d8-a47c-b9609d0b1f31 | rabbit://da52a251f094e02774f653e1ea6eac4156893892:****@192.168.24.1// |    mysql+pymysql://nova:****@192.168.24.1/nova    |
+---------+--------------------------------------+-----------------------------------------------------------------------+---------------------------------------------------+


sudo nova-manage cell_v2 list_cells
+---------+--------------------------------------+----------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+
|   Name  |                 UUID                 |                            Transport URL                             |                                                   Database Connection                                                   |
+---------+--------------------------------------+----------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+
|  cell0  | 00000000-0000-0000-0000-000000000000 |                                none:/                                | mysql+pymysql://nova:****@172.17.1.10/nova_cell0?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf |
| default | 400ffe3c-51ee-4731-b9ae-c3b86e67138f | rabbit://guest:****@controller-0.internalapi.localdomain:5672/?ssl=0 |    mysql+pymysql://nova:****@172.17.1.10/nova?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf    |
+---------+--------------------------------------+----------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+

Comment 11 errata-xmlrpc 2019-07-10 13:03:16 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-2019:1738