yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1898634] [NEW] BGP peer is not working

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Vinicius Coelho <1898634@xxxxxxxxxxxxxxxxxx>
Date: Mon, 05 Oct 2020 22:05:58 -0000
Reply-to: Bug 1898634 <1898634@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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.

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
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:
  New

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
Follow ups

[Bug 1898634] Re: BGP peer is not working
From: Dr. Jens Harbott, 2023-05-18
[Bug 1898634] Re: BGP peer is not working
From: Nate Johnston, 2020-10-12
[Bug 1898634] Re: BGP peer is not working
From: OpenStack Infra, 2020-10-08