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.
Hi MSA
Thanks for taking the time to report this bug in Ubuntu; Its possible that this bug has already been fixed either in an SRU or in a later Ubuntu release (Icehouse on 14.04 for example).
Please could you re-test and see if this is still a problem for you; if so please can you run apport-collect 1314276 so that this bug report gets populated with relevant system information.
Thanks!