yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1584661] [NEW] bgp-speaker-network-remove Failed: internal server error

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: flynnmmm <flynn.miao@xxxxxxxxxx>
Date: Mon, 23 May 2016 09:05:33 -0000
Reply-to: Bug 1584661 <1584661@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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
Follow ups

[Bug 1584661] Re: bgp-speaker-network-remove Failed: internal server error
From: OpenStack Infra, 2016-05-25