Bug 2176836 - OVN migration DB sync fails on controller
Summary: OVN migration DB sync fails on controller
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-neutron
Version: 17.1 (Wallaby)
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: rc
: 17.1
Assignee: Rodolfo Alonso
QA Contact: Ella Shulman
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2023-03-09 12:57 UTC by Ella Shulman
Modified: 2023-08-16 01:14 UTC (History)
8 users (show)

Fixed In Version: openstack-neutron-18.6.1-1.20230324161202.512e1d6.el9ost
Doc Type: No Doc Update
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-08-16 01:14:17 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1927763 0 None None None 2023-03-13 15:33:24 UTC
OpenStack gerrit 790288 0 None MERGED Fix SQLAlchemy warnings with view only relationships 2023-03-21 07:52:24 UTC
Red Hat Issue Tracker OSP-23019 0 None None None 2023-03-09 12:59:06 UTC
Red Hat Product Errata RHEA-2023:4577 0 None None None 2023-08-16 01:14:34 UTC

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


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