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

Bug 2241138

Summary: generate-inventory fails to define mysql host when stack name is not overcloud
Product: Red Hat OpenStack Reporter: Roman Safronov <rsafrono>
Component: openstack-neutronAssignee: Arnau Verdaguer <averdagu>
Status: CLOSED ERRATA QA Contact: Eran Kuris <ekuris>
Severity: medium Docs Contact:
Priority: medium    
Version: 17.1 (Wallaby)CC: averdagu, chrisw, scohen
Target Milestone: z2Keywords: Triaged
Target Release: 17.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-neutron-18.6.1-17.1.20231025110804.85ff760.el9ost Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2024-01-16 14:31:05 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:

Description Roman Safronov 2023-09-28 08:35:06 UTC
Description of problem:
Found on attempt to perform ovs2ovn migration on an environment after ffu (which had stack name different from 'overcloud')
After running ovn_migration.sh generate-inventory the resulted file had one of the hosts not configured properly (ip for ansible_host not set)
...
[mysql]
ansible_host= ansible_ssh_user=tripleo-admin ansible_become=true
...

This happens because of a bug in ovn_migration.sh script
Line 189
mysql_node=$(get_group_hosts "$inventory_file" overcloud_mysql | head -n1)
should be replaced with this
mysql_node=$(get_group_hosts "$inventory_file" ${STACK_NAME}_mysql | head -n1)

See the attached tripleo-ansible-inventory.yaml file


Version-Release number of selected component (if applicable):
RHOS-17.1-RHEL-8-20230907.n.1
openstack-neutron-ovn-migration-tool-18.6.1-1.20230518200974.el9ost.noarch

How reproducible:
100%

Steps to Reproduce:
1. Deploy an ovs environment with stack name that differs from 'overcloud'. I used an environment after 16.2-to-17.1 ffu job that had stack name qe-Cloud-0
2. Specify environment variables according to the stack name, i.e in my case I set
export STACK_NAME=qe-Cloud-0
export OVERCLOUDRC_FILE=~/qe-Cloud-0rc
3. Try to generate hosts_for_migration file by running ovn_migration.sh generate-inventory

Actual results:
In the resulted hosts_for_migration file a mysql host does not have ansible_host ip address configured. This causes issues during ovn migration, some tasks can't connect to a host.

Expected results:
All ansible_hosts in hosts_for_migration file have ip addresses configured properly

Additional info:

Comment 16 errata-xmlrpc 2024-01-16 14:31:05 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 (Red Hat OpenStack Platform 17.1.2 bug fix and enhancement 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-2024:0209