Activity log for bug #1848572

Date Who What changed Old value New value Message
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