Bug 1614478 - FFWD: After upgrade, nova cell0 needs to be updated to remove bind_address and add proper database URL
Summary: FFWD: After upgrade, nova cell0 needs to be updated to remove bind_address an...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates
Version: 13.0 (Queens)
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: z7
: 13.0 (Queens)
Assignee: Lukas Bezdicka
QA Contact: Ronnie Rasouli
URL:
Whiteboard:
Depends On: 1651136
Blocks: 1716447
TreeView+ depends on / blocked
 
Reported: 2018-08-09 17:16 UTC by Darin Sorrentino
Modified: 2019-07-10 13:04 UTC (History)
6 users (show)

Fixed In Version: openstack-tripleo-heat-templates-8.3.1-34.el7ost
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1716447 (view as bug list)
Environment:
Last Closed: 2019-07-10 13:03:16 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1830706 0 None None None 2019-05-28 09:45:57 UTC
OpenStack gerrit 661735 0 'None' 'MERGED' '[FFWD] Fix cell0 database uri' 2019-12-06 16:40:56 UTC
Red Hat Product Errata RHBA-2019:1738 0 None None None 2019-07-10 13:04:57 UTC

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


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