[Bug 1429739] Re: neutron-server does not start: OperationalError: (OperationalError) no such table: ml2_vlan_allocations
Larry Michel
larry.michel at canonical.com
Wed Nov 11 23:22:21 UTC 2015
I hit similar issue in trusty. The following error is repeated multiple
times in server.log:
2015-11-11 20:20:40.238 9354 TRACE neutron File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-11-11 20:20:40.238 9354 TRACE neutron cursor.execute(statement, parameters)
2015-11-11 20:20:40.238 9354 TRACE neutron OperationalError: (OperationalError) no such table: ml2_vlan_allocations u'SELECT ml2_vlan_allocations.physical_network AS ml2_vlan_allocations
_physical_network, ml2_vlan_allocations.vlan_id AS ml2_vlan_allocations_vlan_id, ml2_vlan_allocations.allocated AS ml2_vlan_allocations_allocated \nFROM ml2_vlan_allocations' ()
2015-11-11 20:20:40.238 9354 TRACE neutron
2015-11-11 20:20:41.166 9371 ERROR neutron.service [-] Unrecoverable error: please check log for details.
2015-11-11 20:20:41.166 9371 TRACE neutron.service Traceback (most recent call last):
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 102, in serve_wsgi
2015-11-11 20:20:41.166 9371 TRACE neutron.service service.start()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 73, in start
2015-11-11 20:20:41.166 9371 TRACE neutron.service self.wsgi_app = _run_wsgi(self.app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 168, in _run_wsgi
2015-11-11 20:20:41.166 9371 TRACE neutron.service app = config.load_paste_app(app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/common/config.py", line 183, in load_paste_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service app = deploy.loadapp("config:%s" % config_path, name=app_name)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
2015-11-11 20:20:41.166 9371 TRACE neutron.service return loadobj(APP, uri, name=name, **kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
2015-11-11 20:20:41.166 9371 TRACE neutron.service return context.create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-11-11 20:20:41.166 9371 TRACE neutron.service **context.local_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-11-11 20:20:41.166 9371 TRACE neutron.service val = callable(*args, **kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 28, in urlmap_factory
2015-11-11 20:20:41.166 9371 TRACE neutron.service app = loader.get_app(app_name, global_conf=global_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service name=name, global_conf=global_conf).create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-11-11 20:20:41.166 9371 TRACE neutron.service **context.local_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-11-11 20:20:41.166 9371 TRACE neutron.service val = callable(*args, **kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/auth.py", line 71, in pipeline_factory
2015-11-11 20:20:41.166 9371 TRACE neutron.service app = loader.get_app(pipeline[-1])
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
2015-11-11 20:20:41.166 9371 TRACE neutron.service name=name, global_conf=global_conf).create()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-11-11 20:20:41.166 9371 TRACE neutron.service return self.object_type.invoke(self)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke
2015-11-11 20:20:41.166 9371 TRACE neutron.service return fix_call(context.object, context.global_conf, **context.local_conf)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-11-11 20:20:41.166 9371 TRACE neutron.service val = callable(*args, **kw)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/api/v2/router.py", line 72, in factory
2015-11-11 20:20:41.166 9371 TRACE neutron.service return cls(**local_config)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/api/v2/router.py", line 76, in __init__
2015-11-11 20:20:41.166 9371 TRACE neutron.service plugin = manager.NeutronManager.get_plugin()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 219, in get_plugin
2015-11-11 20:20:41.166 9371 TRACE neutron.service return weakref.proxy(cls.get_instance().plugin)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 213, in get_instance
2015-11-11 20:20:41.166 9371 TRACE neutron.service cls._create_instance()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/lockutils.py", line 249, in inner
2015-11-11 20:20:41.166 9371 TRACE neutron.service return f(*args, **kwargs)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 199, in _create_instance
2015-11-11 20:20:41.166 9371 TRACE neutron.service cls._instance = cls()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 114, in __init__
2015-11-11 20:20:41.166 9371 TRACE neutron.service plugin_provider)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 140, in _get_plugin_instance
2015-11-11 20:20:41.166 9371 TRACE neutron.service return plugin_class()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/plugin.py", line 124, in __init__
2015-11-11 20:20:41.166 9371 TRACE neutron.service self.type_manager.initialize()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/managers.py", line 146, in initialize
2015-11-11 20:20:41.166 9371 TRACE neutron.service driver.obj.initialize()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_vlan.py", line 162, in initialize
2015-11-11 20:20:41.166 9371 TRACE neutron.service self._sync_vlan_allocations()
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_vlan.py", line 105, in _sync_vlan_allocations
2015-11-11 20:20:41.166 9371 TRACE neutron.service for alloc in allocs:
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2412, in __iter__
2015-11-11 20:20:41.166 9371 TRACE neutron.service return self._execute_and_instances(context)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2427, in _execute_and_instances
2015-11-11 20:20:41.166 9371 TRACE neutron.service result = conn.execute(querycontext.statement, self._params)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
2015-11-11 20:20:41.166 9371 TRACE neutron.service return meth(self, multiparams, params)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
2015-11-11 20:20:41.166 9371 TRACE neutron.service return connection._execute_clauseelement(self, multiparams, params)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
2015-11-11 20:20:41.166 9371 TRACE neutron.service compiled_sql, distilled_params
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2015-11-11 20:20:41.166 9371 TRACE neutron.service context)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2015-11-11 20:20:41.166 9371 TRACE neutron.service util.raise_from_cause(newraise, exc_info)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-11-11 20:20:41.166 9371 TRACE neutron.service reraise(type(exception), exception, tb=exc_tb)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-11-11 20:20:41.166 9371 TRACE neutron.service context)
2015-11-11 20:20:41.166 9371 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-11-11 20:20:41.166 9371 TRACE neutron.service cursor.execute(statement, parameters)
2015-11-11 20:20:41.166 9371 TRACE neutron.service OperationalError: (OperationalError) no such table: ml2_vlan_allocations u'SELECT ml2_vlan_allocations.physical_network AS ml2_vlan_all
ocations_physical_network, ml2_vlan_allocations.vlan_id AS ml2_vlan_allocations_vlan_id, ml2_vlan_allocations.allocated AS ml2_vlan_allocations_allocated \nFROM ml2_vlan_allocations' ()
2015-11-11 20:20:41.166 9371 TRACE neutron.service
2015-11-11 20:20:41.175 9371 CRITICAL neutron [-] OperationalError: (OperationalError) no such table: ml2_vlan_allocations u'SELECT ml2_vlan_allocations.physical_network AS ml2_vlan_allo
cations_physical_network, ml2_vlan_allocations.vlan_id AS ml2_vlan_allocations_vlan_id, ml2_vlan_allocations.allocated AS ml2_vlan_allocations_allocated \nFROM ml2_vlan_allocations' ()
2015-11-11 20:20:41.175 9371 TRACE neutron Traceback (most recent call last):
--
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/1429739
Title:
neutron-server does not start: OperationalError: (OperationalError) no
such table: ml2_vlan_allocations
To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1429739/+subscriptions
More information about the Ubuntu-server-bugs
mailing list