Hi James, or anyone else affected :),

Charmed neutron-api 2024.1/candidate 603 with the
neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin enabled in
Jammy installs the Python package neutron-dynamic-routing 24.0.0.

Running openstack bgp commands like:

$ openstack bgp speaker list
HttpException: 500: Server Error for url: 
https://<neutron-api-url>:9696/v2.0/bgp-speakers, Request Failed: internal 
server error while processing your request.

Results in neutron-server errors related to the db migration:

2025-02-26 16:03:37.001 2160977 ERROR neutron.api.v2.resource [None 
req-521be947-1151-4c91-8f1d-e10221dce71d 74c58b5bb8b545899d86a2b85c0ea155 
274e915f24ff4547a2571b67bd404083 - - 990c9869587
44b8295fa51f5c6bf41cb 990c986958744b8295fa51f5c6bf41cb] index failed: No 
details.: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) 
(1054, "Unknown column 'bgp_speakers.projec
t_id' in 'field list'")                                                         
                                                                                
      
[SQL: SELECT bgp_speakers.project_id AS bgp_speakers_project_id, 
bgp_speakers.id AS bgp_speakers_id, bgp_speakers.name AS bgp_speakers_name, 
bgp_speakers.local_as AS bgp_speakers_local_as, b
gp_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_speaker
s.ip_version AS bgp_speakers_ip_version, 
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_bind
ings_1_network_id, bgp_speaker_network_bindings_1.ip_version AS 
bgp_speaker_network_bindings_1_ip_version           
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]

full traceback in: https://paste.ubuntu.com/p/v5rvnNZmvJ/

Is there a PPA with the fix for Jammy so I can try manually reinstalling
the package and re-enabling the bgp plugin?


Many thanks!

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2090992

Title:
  [SRU] alembic database migrations missing from package

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/2090992/+subscriptions


-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to