yahoo-eng-team team mailing list archive

[OpenStack Infra <1898634@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.opendev.org/756613
Committed: https://git.openstack.org/cgit/openstack/neutron-dynamic-routing/commit/?id=4212b705386153c5ff9986068c78ee9c7b4fbe4c
Submitter: Zuul
Branch:    master

commit 4212b705386153c5ff9986068c78ee9c7b4fbe4c
Author: Nate Johnston <nate.johnston@xxxxxxxxxx>
Date:   Wed Oct 7 21:56:49 2020 -0400

    Fix outerjoin to comply with SQLAlchemy 1.3 strictness
    
    The outerjoin in neutron_dynamic_routing/db/bgp_db.py does not meet
    with the stricter new standards in SQLAlchemy 1.3, so this finds a
    more compliant form.
    
    [1] https://docs.sqlalchemy.org/en/13/changelog/migration_13.html#query-join-handles-ambiguity-in-deciding-the-left-side-more-explicitly
    
    Change-Id: I603a2febb1755b6db17e6ac9cb22015a1f3336d4
    Closes-Bug: #1898634


** Changed in: neutron
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1898634

Title:
  BGP peer is not working

Status in neutron:
  Fix Released

Bug description:
  I´m trying to configure dynamic routing, but when I associate provider
  network with the bgp speaker I start to receive these errors:

  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server Traceback (most recent call last):
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib/python3.6/site-packages/oslo_messaging/rpc/server.py", line 165, in _process_incoming
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     res = self.dispatcher.dispatch(message)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib/python3.6/site-packages/oslo_messaging/rpc/dispatcher.py", line 276, in dispatch
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     return self._do_dispatch(endpoint, method, ctxt, args)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib/python3.6/site-packages/oslo_messaging/rpc/dispatcher.py", line 196, in _do_dispatch
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     result = func(ctxt, **new_args)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/local/lib/python3.6/site-packages/neutron_dynamic_routing/api/rpc/handlers/bgp_speaker_rpc.py", line 65, in get_bgp_speakers
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     return self.plugin.get_bgp_speakers_for_agent_host(context, host)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/local/lib/python3.6/site-packages/neutron_dynamic_routing/db/bgp_dragentscheduler_db.py", line 263, in get_bgp_speakers_for_agent_host
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     context, binding['bgp_speaker_id'])
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/local/lib/python3.6/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 165, in get_bgp_speaker_with_advertised_routes
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     bgp_speaker_id)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/local/lib/python3.6/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 479, in get_routes_by_bgp_speaker_id
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     bgp_speaker_id)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/local/lib/python3.6/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 673, in _get_central_fip_host_routes_by_bgp_speaker
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     l3_db.Router.id == router_attrs.router_id)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2259, in outerjoin
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     from_joinpoint=from_joinpoint,
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "<string>", line 2, in _join
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/base.py", line 220, in generate
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     fn(self, *args[1:], **kw)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2414, in _join
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     left, right, onclause, prop, create_aliases, outerjoin, full
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2437, in _join_left_to_right
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     ) = self._join_determine_implicit_left_side(left, right, onclause)
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2526, in _join_determine_implicit_left_side
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server     "Can't determine which FROM clause to join "
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.
  2020-10-05 16:56:13.028 2304845 ERROR oslo_messaging.rpc.server


  
  I made manual installation, ussuri. Couldn´t find any workaround.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1898634/+subscriptions