Neutron BGP dynamic routing agent requires db migration

[Viktor Michalek]

Neutron BGP dynamic routing agent requires database migration to be done for its proper function. Currently this operation is not held resulting in neutron-bgp-dragent inoperational, this can be easily checked by trying to create BGP speaker within openstack infrastructure; by command:

root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker

which returns code 504 and following entry occours in neutron-server.log:

2019-10-17 12:38:56.489 19 ERROR neutron.api.v2.resource oslo_db.exception.DBError: (pymysql.err.InternalError) (1054, "Unknown column 'project_id' in 'field list'") [SQL: 'INSERT INTO bgp_speakers (project_id, id, name, local_as, advertise_floating_ip_host_routes, advertise_tenant_networks, ip_version) VALUES (%(project_id)s, %(id)s, %(name)s, %(local_as)s, %(advertise_floating_ip_host_routes)s, %(advertise_tenant_networks)s, %(ip_version)s)'] [parameters: {'project_id': '79e726b2e8de4a95a11814dc5b9eecd0', 'id': 'd5391064-0421-443f-8192-09f78e2ed002', 'name': 'bgpspeaker', 'local_as': '1234', 'advertise_floating_ip_host_routes': 1, 'advertise_tenant_networks': 1, 'ip_version': 4}] (Background on this error at: http://sqlalche.me/e/2j85)

For proper function, database migration operation should be done during boostrap phase of neutron_server container.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/689244
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=89372f0c5f312c222fe769a2aab8d1fce445dd84
Submitter: Zuul
Branch: master

commit 89372f0c5f312c222fe769a2aab8d1fce445dd84
Author: Viktor Michalek <email address hidden>
Date: Thu Oct 17 15:18:14 2019 +0200

    Neutron: apply db migration for BGP dynamic routing agent

    Change-Id: Id84d5a1b3c70c0260b85ed7c24aa7f1e007c12d6
    Closes-Bug: 1848572

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/train
Review: https://review.opendev.org/695880

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/695880
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=b421830c763317d33ff1454701ac7d68bb4321dd
Submitter: Zuul
Branch: stable/train

commit b421830c763317d33ff1454701ac7d68bb4321dd
Author: Viktor Michalek <email address hidden>
Date: Thu Oct 17 15:18:14 2019 +0200

    Neutron: apply db migration for BGP dynamic routing agent

    Change-Id: Id84d5a1b3c70c0260b85ed7c24aa7f1e007c12d6
    Closes-Bug: 1848572
    (cherry picked from commit 89372f0c5f312c222fe769a2aab8d1fce445dd84)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla 9.0.0.0rc2 release candidate.