Public bug reported: Can not remove network from a speaker: [root@SG-dev-flynn-3-fwaas devstack]# neutron net-create --router:external=True --provider:physical_network provider2 --provider:network_type flat provider2 Created a new network: +---------------------------+--------------------------------------+ | Field | Value | +---------------------------+--------------------------------------+ | admin_state_up | True | | availability_zone_hints | | | availability_zones | | | created_at | 2016-05-23T08:58:06 | | description | | | id | 7bc3ba6a-d295-4823-89c3-141d2828ab36 | | ipv4_address_scope | | | ipv6_address_scope | | | is_default | False | | mtu | 1500 | | name | provider2 | | port_security_enabled | True | | provider:network_type | flat | | provider:physical_network | provider2 | | provider:segmentation_id | | | router:external | True | | shared | False | | status | ACTIVE | | subnets | | | tags | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | | updated_at | 2016-05-23T08:58:06 | +---------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-create --ip-version 4 --local-as 1026 testspeaker3 Created a new bgp_speaker: +-----------------------------------+--------------------------------------+ | Field | Value | +-----------------------------------+--------------------------------------+ | advertise_floating_ip_host_routes | True | | advertise_tenant_networks | True | | id | 87f5e986-3097-4faf-ab3d-47dcdbd429cd | | ip_version | 4 | | local_as | 1026 | | name | testspeaker3 | | networks | | | peers | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | +-----------------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-network-add testspeaker3 provider2 Added network provider2 to BGP speaker testspeaker3. [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-show testspeaker3 +-----------------------------------+--------------------------------------+ | Field | Value | +-----------------------------------+--------------------------------------+ | advertise_floating_ip_host_routes | True | | advertise_tenant_networks | True | | id | 87f5e986-3097-4faf-ab3d-47dcdbd429cd | | ip_version | 4 | | local_as | 1026 | | name | testspeaker3 | | networks | 7bc3ba6a-d295-4823-89c3-141d2828ab36 | | peers | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | +-----------------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-network-remove testspeaker3 provider2 Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-e2c1db4a-e24e-4b2d-a48a-202a8efc7954']
q-svc log: 2016-05-23 04:03:58.772 ERROR neutron.api.v2.resource [req-73efdee9-760e-4895-9bdd-7f92593f1fb7 admin 57f2b5617a7d4b1989e9c0385df4021b] remove_gateway_network failed 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource Traceback (most recent call last): 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/resource.py", line 84, in resource 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource result = method(request=request, **args) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 148, in wrapper 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource ectxt.value = e.inner_exc 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 221, in __exit__ 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource self.force_reraise() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 197, in force_reraise 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource return f(*args, **kwargs) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/base.py", line 219, in _handle_action 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource ret_value = getattr(self._plugin, name)(*arg_list, **kwargs) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 232, in remove_gateway_network 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_info) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 215, in remove_gateway_network 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 402, in _remove_bgp_speaker_network_binding 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 440, in _get_bgp_speaker_network_binding 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id == network_id).one() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2727, in one 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource "Multiple rows were found for one()") 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource MultipleResultsFound: Multiple rows were found for one() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource ** 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/1584661 Title: bgp-speaker-network-remove Failed: internal server error Status in neutron: New Bug description: Can not remove network from a speaker: [root@SG-dev-flynn-3-fwaas devstack]# neutron net-create --router:external=True --provider:physical_network provider2 --provider:network_type flat provider2 Created a new network: +---------------------------+--------------------------------------+ | Field | Value | +---------------------------+--------------------------------------+ | admin_state_up | True | | availability_zone_hints | | | availability_zones | | | created_at | 2016-05-23T08:58:06 | | description | | | id | 7bc3ba6a-d295-4823-89c3-141d2828ab36 | | ipv4_address_scope | | | ipv6_address_scope | | | is_default | False | | mtu | 1500 | | name | provider2 | | port_security_enabled | True | | provider:network_type | flat | | provider:physical_network | provider2 | | provider:segmentation_id | | | router:external | True | | shared | False | | status | ACTIVE | | subnets | | | tags | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | | updated_at | 2016-05-23T08:58:06 | +---------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-create --ip-version 4 --local-as 1026 testspeaker3 Created a new bgp_speaker: +-----------------------------------+--------------------------------------+ | Field | Value | +-----------------------------------+--------------------------------------+ | advertise_floating_ip_host_routes | True | | advertise_tenant_networks | True | | id | 87f5e986-3097-4faf-ab3d-47dcdbd429cd | | ip_version | 4 | | local_as | 1026 | | name | testspeaker3 | | networks | | | peers | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | +-----------------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-network-add testspeaker3 provider2 Added network provider2 to BGP speaker testspeaker3. [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-show testspeaker3 +-----------------------------------+--------------------------------------+ | Field | Value | +-----------------------------------+--------------------------------------+ | advertise_floating_ip_host_routes | True | | advertise_tenant_networks | True | | id | 87f5e986-3097-4faf-ab3d-47dcdbd429cd | | ip_version | 4 | | local_as | 1026 | | name | testspeaker3 | | networks | 7bc3ba6a-d295-4823-89c3-141d2828ab36 | | peers | | | tenant_id | 57f2b5617a7d4b1989e9c0385df4021b | +-----------------------------------+--------------------------------------+ [root@SG-dev-flynn-3-fwaas devstack]# neutron bgp-speaker-network-remove testspeaker3 provider2 Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-e2c1db4a-e24e-4b2d-a48a-202a8efc7954'] q-svc log: 2016-05-23 04:03:58.772 ERROR neutron.api.v2.resource [req-73efdee9-760e-4895-9bdd-7f92593f1fb7 admin 57f2b5617a7d4b1989e9c0385df4021b] remove_gateway_network failed 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource Traceback (most recent call last): 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/resource.py", line 84, in resource 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource result = method(request=request, **args) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 148, in wrapper 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource ectxt.value = e.inner_exc 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 221, in __exit__ 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource self.force_reraise() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 197, in force_reraise 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource return f(*args, **kwargs) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/base.py", line 219, in _handle_action 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource ret_value = getattr(self._plugin, name)(*arg_list, **kwargs) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 232, in remove_gateway_network 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_info) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 215, in remove_gateway_network 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 402, in _remove_bgp_speaker_network_binding 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id) 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/opt/stack/neutron-dynamic-routing/neutron_dynamic_routing/db/bgp_db.py", line 440, in _get_bgp_speaker_network_binding 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource network_id == network_id).one() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2727, in one 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource "Multiple rows were found for one()") 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource MultipleResultsFound: Multiple rows were found for one() 2016-05-23 04:03:58.772 TRACE neutron.api.v2.resource To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1584661/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp