2019-10-17 19:27:23 |
Viktor Michalek |
bug |
|
|
added bug |
2019-10-17 19:27:58 |
Viktor Michalek |
description |
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 in-operational, this can be easily checked by trying to create BGP speaker within openstack infrastructure; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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 held during neutron_bgp_dragent container boostrap phase. |
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 in-operational, this can be easily checked by trying to create BGP speaker within openstack infrastructure; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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 held during neutron_bgp_dragent container boostrap phase. |
|
2019-10-17 19:28:23 |
Viktor Michalek |
kolla: assignee |
|
Viktor Michalek (viktormichalek) |
|
2019-10-17 19:29:42 |
Viktor Michalek |
description |
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 in-operational, this can be easily checked by trying to create BGP speaker within openstack infrastructure; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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 held during neutron_bgp_dragent container boostrap phase. |
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; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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 held during neutron_bgp_dragent container boostrap phase. |
|
2019-10-17 19:34:04 |
Viktor Michalek |
description |
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; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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 held during neutron_bgp_dragent container boostrap phase. |
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; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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_bgp_dragent container. |
|
2019-10-17 19:34:54 |
Viktor Michalek |
description |
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; command:
root@clients:/opt# neutron bgp-speaker-create --ip-version 4 --local-as 1234 bgpspeaker
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_bgp_dragent container. |
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_bgp_dragent container. |
|
2019-10-17 19:39:03 |
OpenStack Infra |
kolla: status |
New |
In Progress |
|
2019-11-20 12:03:57 |
Viktor Michalek |
description |
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_bgp_dragent container. |
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. |
|
2019-11-25 10:30:59 |
OpenStack Infra |
kolla: status |
In Progress |
Fix Released |
|
2019-12-02 09:51:40 |
OpenStack Infra |
tags |
|
in-stable-train |
|
2020-05-19 09:06:19 |
Mark Goddard |
nominated for series |
|
kolla/ussuri |
|
2020-05-19 09:06:19 |
Mark Goddard |
bug task added |
|
kolla/ussuri |
|
2020-05-19 09:06:25 |
Mark Goddard |
kolla/ussuri: importance |
Undecided |
Medium |
|
2020-05-19 09:06:29 |
Mark Goddard |
kolla/ussuri: milestone |
|
10.0.0 |
|
2020-05-19 09:06:52 |
Mark Goddard |
nominated for series |
|
kolla/train |
|
2020-05-19 09:06:52 |
Mark Goddard |
bug task added |
|
kolla/train |
|
2020-05-19 09:06:57 |
Mark Goddard |
kolla/train: status |
New |
Fix Released |
|
2020-05-19 09:06:59 |
Mark Goddard |
kolla/train: importance |
Undecided |
Medium |
|