yahoo-eng-team team mailing list archive

[Lajos Katona <2067296@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

neutron-dynamic-routing fails even listing bgp speakers:
$ openstack bgp speaker list
HttpException: 500: Server Error for url: http://<local-ip>:9696/networking/v2.0/bgp-speakers, Request Failed: internal server error while processing your request.
$


May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'bgp_speakers.project_id' in 'field list'")
May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource [SQL: SELECT bgp_speakers.name AS bgp_speakers_name, bgp_speakers.local_as AS bgp_speakers_local_as, bgp_speakers.advertise_floating_ip_host_routes AS bgp_speakers_advertise_floating_ip_host_routes, bgp_speakers.advertise_tenant_networks AS bgp_speakers_advertise_tenant_networks, bgp_speakers.ip_version AS bgp_speakers_ip_version, bgp_speakers.id AS bgp_speakers_id, bgp_speakers.project_id AS bgp_speakers_project_id, bgp_speaker_peer_bindings_1.bgp_speaker_id AS bgp_speaker_peer_bindings_1_bgp_speaker_id, bgp_speaker_peer_bindings_1.bgp_peer_id AS bgp_speaker_peer_bindings_1_bgp_peer_id, bgp_speaker_network_bindings_1.bgp_speaker_id AS bgp_speaker_network_bindings_1_bgp_speaker_id, bgp_speaker_network_bindings_1.network_id AS bgp_speaker_network_bindings_1_network_id, bgp_speaker_network_bindings_1.ip_version AS bgp_speaker_network_bindings_1_ip_version
May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource FROM bgp_speakers LEFT OUTER JOIN bgp_speaker_peer_bindings AS bgp_speaker_peer_bindings_1 ON bgp_speakers.id = bgp_speaker_peer_bindings_1.bgp_speaker_id LEFT OUTER JOIN bgp_speaker_network_bindings AS bgp_speaker_network_bindings_1 ON bgp_speakers.id = bgp_speaker_network_bindings_1.bgp_speaker_id]
May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource (Background on this error at: https://sqlalche.me/e/20/e3q8)
May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource 

I see the same issue with master neutron/neutron-lib/n-d-r/oslo.db and by pulling in this patch from ralonsoh:
https://review.opendev.org/c/openstack/neutron-dynamic-routing/+/882940


Full traceback:
https://paste.opendev.org/show/b9Q21OQILjgVv7Su2b28/

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: l3-bgp

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

Title:
  Neutron-dynamic-routing issue with tenant_id/project_id

Status in neutron:
  New

Bug description:
  neutron-dynamic-routing fails even listing bgp speakers:
  $ openstack bgp speaker list
  HttpException: 500: Server Error for url: http://<local-ip>:9696/networking/v2.0/bgp-speakers, Request Failed: internal server error while processing your request.
  $

  
  May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'bgp_speakers.project_id' in 'field list'")
  May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource [SQL: SELECT bgp_speakers.name AS bgp_speakers_name, bgp_speakers.local_as AS bgp_speakers_local_as, bgp_speakers.advertise_floating_ip_host_routes AS bgp_speakers_advertise_floating_ip_host_routes, bgp_speakers.advertise_tenant_networks AS bgp_speakers_advertise_tenant_networks, bgp_speakers.ip_version AS bgp_speakers_ip_version, bgp_speakers.id AS bgp_speakers_id, bgp_speakers.project_id AS bgp_speakers_project_id, bgp_speaker_peer_bindings_1.bgp_speaker_id AS bgp_speaker_peer_bindings_1_bgp_speaker_id, bgp_speaker_peer_bindings_1.bgp_peer_id AS bgp_speaker_peer_bindings_1_bgp_peer_id, bgp_speaker_network_bindings_1.bgp_speaker_id AS bgp_speaker_network_bindings_1_bgp_speaker_id, bgp_speaker_network_bindings_1.network_id AS bgp_speaker_network_bindings_1_network_id, bgp_speaker_network_bindings_1.ip_version AS bgp_speaker_network_bindings_1_ip_version
  May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource FROM bgp_speakers LEFT OUTER JOIN bgp_speaker_peer_bindings AS bgp_speaker_peer_bindings_1 ON bgp_speakers.id = bgp_speaker_peer_bindings_1.bgp_speaker_id LEFT OUTER JOIN bgp_speaker_network_bindings AS bgp_speaker_network_bindings_1 ON bgp_speakers.id = bgp_speaker_network_bindings_1.bgp_speaker_id]
  May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource (Background on this error at: https://sqlalche.me/e/20/e3q8)
  May 27 15:03:22 jammy neutron-server[241079]: ERROR neutron.api.v2.resource 

  I see the same issue with master neutron/neutron-lib/n-d-r/oslo.db and by pulling in this patch from ralonsoh:
  https://review.opendev.org/c/openstack/neutron-dynamic-routing/+/882940

  
  Full traceback:
  https://paste.opendev.org/show/b9Q21OQILjgVv7Su2b28/

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