[Bug 1314276] [NEW] Mutliple Instance deployment nuetron 2.3.0 (bigswitch plugin) error: havana -ubuntu 13.10 server

[MSA]

Public bug reported:

A single instance deployment works great but with multiple instance
deployment , I am getting neutron ResourceClosedError and some time DB
timeout and  locking error. I am using default neutron version 2.3.0
(havana) in ubuntu 13.10 server with Floodlight (bigswitch restproxy
plugin). Here is the log for neutron-server:\

014-04-29 12:24:07.867 28072 ERROR neutron.api.v2.resource [-] create failed
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource Traceback (most recent call last):
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 84, in resource
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     result = method(request=request, **args)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 405, in create
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     obj = obj_creator(request.context, **kwargs)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/plugins/bigswitch/plugin.py", line 634, in create_port
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     port)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/db/db_base_plugin_v2.py", line 1332, in create_port
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     ips = self._allocate_ips_for_port(context, network, port)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/db/db_base_plugin_v2.py", line 719, in _allocate_ips_for_port
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     result = NeutronDbPluginV2._generate_ip(context, subnets)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/db/db_base_plugin_v2.py", line 462, in _generate_ip
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     range = range_qry.filter_by(subnet_id=subnet['id']).first()
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2278, in first
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     ret = list(self[0:1])
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2145, in __getitem__
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     return list(res)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/loading.py", line 65, in instances
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     fetch = cursor.fetchall()
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 752, in fetchall
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     self.cursor, self.context)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1027, in _handle_dbapi_exception
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     util.reraise(*exc_info)
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 746, in fetchall
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     l = self.process_rows(self._fetchall_impl())
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 715, in _fetchall_impl
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     self._non_result()
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 720, in _non_result
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource     "This result object does not return rows. "
2014-04-29 12:24:07.867 28072 TRACE neutron.api.v2.resource ResourceClosedError: This result object does not return rows. It has been closed automatically.

** Affects: neutron (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to neutron in Ubuntu.
https://bugs.launchpad.net/bugs/1314276

Title:
  Mutliple Instance deployment nuetron 2.3.0 (bigswitch plugin)  error:
  havana -ubuntu 13.10 server

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1314276/+subscriptions