Reviewed:  https://review.openstack.org/320204
Committed: 
https://git.openstack.org/cgit/openstack/neutron-dynamic-routing/commit/?id=908feafbe5c9607eb4538a2d2154d4e724b99b9e
Submitter: Jenkins
Branch:    master

commit 908feafbe5c9607eb4538a2d2154d4e724b99b9e
Author: steve.ruan <rua...@cn.ibm.com>
Date:   Mon May 23 22:28:25 2016 -0500

    Fix bgp-speaker-network-remove error
    
    Table name BgpSpeakerPeerBinding is missing in the filter
    
    Change-Id: Icf3d8f41b64d2813517f3509c440c29c5c36681d
    Closes-Bug: #1584661


** Changed in: neutron
       Status: In Progress => Fix Released

-- 
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:
  Fix Released

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

Reply via email to