yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #39444
[Bug 1274682] Re: Vlans are not cleanly deleted in SQL database leaving stale entries
** No longer affects: neutron
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1274682
Title:
Vlans are not cleanly deleted in SQL database leaving stale entries
Status in Cisco Openstack:
New
Bug description:
Steps to see
- Create the Tenant with subnet ,
- instantiate a VM on the subnet which will create a VLAN using neutron plugin for Nexus .
- Now delete the subnet and the vlan on the switch .
- Create the subnet again , the controller will again allocate the same segmentation id but it will not create the Vlan again on Nexus switch
When looking the SQL database the previous vlan entries are still
present in the database and the controller is not able to assign the
vlans correctly . The workaround is to select a different range of
segmentation ids in the plugin .
Error :
2014-01-29 13:47:03.059 2562 WARNING neutron.db.agentschedulers_db [-] Fail scheduling network {'status': u'ACTIVE', 'subnets': [u'5146ec1e-ad1d-4ca2-9e1d-e9e97126ae05'], 'name': u'External-1', 'provider
:physical_network': u'physnet1', 'admin_state_up': True, 'tenant_id': u'adfdcc7e64904ab1b812ad1cbbf92f1a', 'provider:network_type': u'vlan', 'router:external': False, 'shared': False, 'id': u'd71796ca-d1
0c-4f4d-b742-1e720ce8b94e', 'provider:segmentation_id': 504L}
2014-01-29 13:47:03.078 2562 ERROR neutron.api.v2.resource [-] add_router_interface failed
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource Traceback (most recent call last):
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 84, in resource
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource result = method(request=request, **args)
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 185, in _handle_action
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource return getattr(self._plugin, name)(*arg_list, **kwargs)
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/neutron/plugins/cisco/models/virt_phy_sw_v2.py", line 439, in add_router_interface
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource raise cexc.SubnetNotSpecified()
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource SubnetNotSpecified: No subnet_id specified for router gateway.
2014-01-29 13:47:03.078 2562 TRACE neutron.api.v2.resource
2014-01-29 13:51:28.220 2562 WARNING neutron.db.agentschedulers_db [-] Fail scheduling network {'status': u'ACTIVE', 'subnets': [u'e98ed533-bbc6-44b4-909a-a94992875c3d'], 'name': u'Tenant_coke', 'provide
r:physical_network': u'physnet1', 'admin_state_up': True, 'tenant_id': u'adfdcc7e64904ab1b812ad1cbbf92f1a', 'provider:network_type': u'vlan', 'router:external': False, 'shared': False, 'id': u'f1f0c30c-a
14b-4b33-8212-5b8763dbd594', 'provider:segmentation_id': 503L}
SQL Entries
Old Stale Entries
mysql> SELECT * FROM ovs_network_bindings;
+--------------------------------------+--------------+------------------+-----------------+
| network_id | network_type | physical_network | segmentation_id |
+--------------------------------------+--------------+------------------+-----------------+
| 07f60f68-8482-4972-aa7c-398f4cdf6abd | vlan | physnet1 | 500 |
| 8b034e8d-7b6a-4198-94bd-5278d7934c78 | vlan | physnet1 | 502 |
+--------------------------------------+--------------+------------------+-----------------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM subnets;
+----------------------------------+--------------------------------------+---------+--------------------------------------+------------+------------------+---------------+-------------+--------+
| tenant_id | id | name | network_id | ip_version | cidr | gateway_ip | enable_dhcp | shared |
+----------------------------------+--------------------------------------+---------+--------------------------------------+------------+------------------+---------------+-------------+--------+
| adfdcc7e64904ab1b812ad1cbbf92f1a | 186b1806-2d44-420a-a48e-ea027dcae543 | Inet-1 | 8b034e8d-7b6a-4198-94bd-5278d7934c78 | 4 | 10.111.111.0/24 | 10.111.111.1 | 1 | 0 |
| adfdcc7e64904ab1b812ad1cbbf92f1a | 2fce01d6-6616-4137-a451-d63c80567929 | Ext-Net | 07f60f68-8482-4972-aa7c-398f4cdf6abd | 4 | 192.168.111.0/24 | 192.168.111.1 | 1 | 1 |
+----------------------------------+--------------------------------------+---------+--------------------------------------+------------+------------------+---------------+-------------+--------+
To manage notifications about this bug go to:
https://bugs.launchpad.net/openstack-cisco/+bug/1274682/+subscriptions