Bug 2176836

Summary: OVN migration DB sync fails on controller
Product: Red Hat OpenStack Reporter: Ella Shulman <eshulman>
Component: openstack-neutronAssignee: Rodolfo Alonso <ralonsoh>
Status: CLOSED ERRATA QA Contact: Ella Shulman <eshulman>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 17.1 (Wallaby)CC: apevec, chrisw, jlibosva, lhh, majopela, ralonsoh, scohen, ykarel
Target Milestone: rcKeywords: AutomationBlocker, Triaged
Target Release: 17.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-neutron-18.6.1-1.20230324161202.512e1d6.el9ost Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2023-08-16 01:14:17 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 Ella Shulman 2023-03-09 12:57:24 UTC
Description of problem:
OVN migration playbook fail due to a DB sync that fails. when running the command manually it worked. error from ansible:
TASK [migration : Sync neutron db with OVN db (container) - Run 1] *************
task path: /home/stack/ovn_migration/playbooks/roles/migration/tasks/sync-dbs.yml:7
Thursday 09 March 2023  10:33:24 +0000 (0:00:01.033)       0:31:02.884 ******** 
fatal: [controller-0]: FAILED! => {"changed": true, "cmd": ["podman", "exec", "ea31bb24066c", "neutron-ovn-db-sync-util", "--config-file", "/etc/neutron/neutron.conf", "
--config-file", "/etc/neutron/plugins/ml2/ml2_conf.ini", "--ovn-neutron_sync_mode", "migrate"], "delta": "0:00:11.365370", "end": "2023-03-09 10:33:36.368916", "msg": "n
on-zero return code", "rc": 1, "start": "2023-03-09 10:33:25.003546", "stderr": "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/relationships.py:1994: SAWarning: Sett
ing backref / back_populates on relationship QosNetworkPolicyBinding.port to refer to viewonly relationship Port.qos_network_policy_binding should include sync_backref=F
alse set on the QosNetworkPolicyBinding.port relationship.  (this warning may be suppressed after 10 occurrences)\n  util.warn_limited(\n/usr/lib64/python3.9/site-packag
es/sqlalchemy/orm/relationships.py:1994: SAWarning: Setting backref / back_populates on relationship Tag.standard_attr to refer to viewonly relationship StandardAttribut
e.tags should include sync_backref=False set on the Tag.standard_attr relationship.  (this warning may be suppressed after 10 occurrences)\n  util.warn_limited(", "stder
r_lines": ["/usr/lib64/python3.9/site-packages/sqlalchemy/orm/relationships.py:1994: SAWarning: Setting backref / back_populates on relationship QosNetworkPolicyBinding.
port to refer to viewonly relationship Port.qos_network_policy_binding should include sync_backref=False set on the QosNetworkPolicyBinding.port relationship.  (this war
ning may be suppressed after 10 occurrences)", "  util.warn_limited(", "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/relationships.py:1994: SAWarning: Setting backr
ef / back_populates on relationship Tag.standard_attr to refer to viewonly relationship StandardAttribute.tags should include sync_backref=False set on the Tag.standard_
attr relationship.  (this warning may be suppressed after 10 occurrences)", "  util.warn_limited("], "stdout": "", "stdout_lines": []}


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

How reproducible:
100%

Steps to Reproduce:
1. deploy overcloud with NFV (OVS-DPDK and SR-IOV)
2. create VMs
3. run OVN migration automation

Actual results:
migration fails due to DB sync

Expected results:
Migration works 

Additional info:

Comment 20 errata-xmlrpc 2023-08-16 01:14:17 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 (Release of components for Red Hat OpenStack Platform 17.1 (Wallaby)), 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/RHEA-2023:4577