bgp-speaker-network-remove Failed: internal server error

Bug #1584661 reported by flynnmmm
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Undecided
Steve Ruan

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

Steve Ruan (ruansx)
Changed in neutron:
assignee: nobody → steve (ruansx)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron-dynamic-routing (master)

Fix proposed to branch: master
Review: https://review.openstack.org/320204

Changed in neutron:
status: New → In Progress
Revision history for this message
vikram.choudhary (vikschw) wrote :
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/mitaka)

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/320240

Akihiro Motoki (amotoki)
tags: added: mitaka-backport-potential
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron-dynamic-routing (master)

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 <email address hidden>
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
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/mitaka)

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/323789

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on neutron (stable/mitaka)

Change abandoned by Ihar Hrachyshka (<email address hidden>) on branch: stable/mitaka
Review: https://review.openstack.org/320240
Reason: Abandoning due to incorrect Change-Id.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/mitaka)

Reviewed: https://review.openstack.org/323789
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=f995169289acdb778270298dc8e9aff431c11a64
Submitter: Jenkins
Branch: stable/mitaka

commit f995169289acdb778270298dc8e9aff431c11a64
Author: steve.ruan <email address hidden>
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
    (cherry picked from commit 908feafbe5c9607eb4538a2d2154d4e724b99b9e)

tags: added: in-stable-mitaka
Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote : Fix included in openstack/neutron 8.1.2

This issue was fixed in the openstack/neutron 8.1.2 release.

tags: removed: mitaka-backport-potential
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers