Fuel for OpenStack

Table 'neutron.ml2_vlan_allocations' doesn't exist

Bug #1427080 reported by Alexei Sheplyakov on 2015-03-02

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Fuel for OpenStack	Fix Released	High	Fuel Library (Deprecated)	Fuel for OpenStack 6.1

Bug Description

2015-03-01 22:24:34.111 19168 INFO neutron.plugins.ml2.managers [-] Loaded mechanism driver names: ['openvswitch']
2015-03-01 22:24:34.112 19168 INFO neutron.plugins.ml2.managers [-] Registered mechanism drivers: ['openvswitch']
2015-03-01 22:24:34.171 19168 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'flat'
2015-03-01 22:24:34.172 19168 INFO neutron.plugins.ml2.drivers.type_flat [-] ML2 FlatTypeDriver initialization complete
2015-03-01 22:24:34.173 19168 INFO neutron.plugins.ml2.managers [-] Initializing driver for type 'vlan'
2015-03-01 22:24:34.215 19168 DEBUG oslo.db.sqlalchemy.session [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION _check_effective_sql_mode /usr/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py:482
2015-03-01 22:24:34.440 19168 DEBUG neutron.openstack.common.lockutils [-] Semaphore / lock released "_create_instance" inner /usr/lib/python2.7/dist-packages/neutron/openstack/common/lockutils.py:252
2015-03-01 22:24:34.442 19168 ERROR neutron.service [-] Unrecoverable error: please check log for details.
2015-03-01 22:24:34.442 19168 TRACE neutron.service Traceback (most recent call last):
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 102, in serve_wsgi
2015-03-01 22:24:34.442 19168 TRACE neutron.service service.start()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 73, in start
2015-03-01 22:24:34.442 19168 TRACE neutron.service self.wsgi_app = _run_wsgi(self.app_name)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/service.py", line 168, in _run_wsgi
2015-03-01 22:24:34.442 19168 TRACE neutron.service app = config.load_paste_app(app_name)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/common/config.py", line 183, in load_paste_app
2015-03-01 22:24:34.442 19168 TRACE neutron.service app = deploy.loadapp("config:%s" % config_path, name=app_name)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
2015-03-01 22:24:34.442 19168 TRACE neutron.service return loadobj(APP, uri, name=name, **kw)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
2015-03-01 22:24:34.442 19168 TRACE neutron.service return context.create()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-03-01 22:24:34.442 19168 TRACE neutron.service return self.object_type.invoke(self)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-03-01 22:24:34.442 19168 TRACE neutron.service **context.local_conf)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-03-01 22:24:34.442 19168 TRACE neutron.service val = callable(*args, **kw)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 28, in urlmap_factory
2015-03-01 22:24:34.442 19168 TRACE neutron.service app = loader.get_app(app_name, global_conf=global_conf)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
2015-03-01 22:24:34.442 19168 TRACE neutron.service name=name, global_conf=global_conf).create()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-03-01 22:24:34.442 19168 TRACE neutron.service return self.object_type.invoke(self)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-03-01 22:24:34.442 19168 TRACE neutron.service **context.local_conf)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-03-01 22:24:34.442 19168 TRACE neutron.service val = callable(*args, **kw)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/auth.py", line 71, in pipeline_factory
2015-03-01 22:24:34.442 19168 TRACE neutron.service app = loader.get_app(pipeline[-1])
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
2015-03-01 22:24:34.442 19168 TRACE neutron.service name=name, global_conf=global_conf).create()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-03-01 22:24:34.442 19168 TRACE neutron.service return self.object_type.invoke(self)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke
2015-03-01 22:24:34.442 19168 TRACE neutron.service return fix_call(context.object, context.global_conf, **context.local_conf)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-03-01 22:24:34.442 19168 TRACE neutron.service val = callable(*args, **kw)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/api/v2/router.py", line 72, in factory
2015-03-01 22:24:34.442 19168 TRACE neutron.service return cls(**local_config)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/api/v2/router.py", line 76, in __init__
2015-03-01 22:24:34.442 19168 TRACE neutron.service plugin = manager.NeutronManager.get_plugin()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 219, in get_plugin
2015-03-01 22:24:34.442 19168 TRACE neutron.service return weakref.proxy(cls.get_instance().plugin)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 213, in get_instance
2015-03-01 22:24:34.442 19168 TRACE neutron.service cls._create_instance()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/lockutils.py", line 249, in inner
2015-03-01 22:24:34.442 19168 TRACE neutron.service return f(*args, **kwargs)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 199, in _create_instance
2015-03-01 22:24:34.442 19168 TRACE neutron.service cls._instance = cls()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 114, in __init__
2015-03-01 22:24:34.442 19168 TRACE neutron.service plugin_provider)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 140, in _get_plugin_instance
2015-03-01 22:24:34.442 19168 TRACE neutron.service return plugin_class()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/plugin.py", line 125, in __init__
2015-03-01 22:24:34.442 19168 TRACE neutron.service self.type_manager.initialize()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/managers.py", line 146, in initialize
2015-03-01 22:24:34.442 19168 TRACE neutron.service driver.obj.initialize()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_vlan.py", line 162, in initialize
2015-03-01 22:24:34.442 19168 TRACE neutron.service self._sync_vlan_allocations()
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/neutron/plugins/ml2/drivers/type_vlan.py", line 105, in _sync_vlan_allocations
2015-03-01 22:24:34.442 19168 TRACE neutron.service for alloc in allocs:
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2412, in __iter__
2015-03-01 22:24:34.442 19168 TRACE neutron.service return self._execute_and_instances(context)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2427, in _execute_and_instances
2015-03-01 22:24:34.442 19168 TRACE neutron.service result = conn.execute(querycontext.statement, self._params)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
2015-03-01 22:24:34.442 19168 TRACE neutron.service return meth(self, multiparams, params)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
2015-03-01 22:24:34.442 19168 TRACE neutron.service return connection._execute_clauseelement(self, multiparams, params)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
2015-03-01 22:24:34.442 19168 TRACE neutron.service compiled_sql, distilled_params
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2015-03-01 22:24:34.442 19168 TRACE neutron.service context)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception
2015-03-01 22:24:34.442 19168 TRACE neutron.service util.raise_from_cause(newraise, exc_info)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-03-01 22:24:34.442 19168 TRACE neutron.service reraise(type(exception), exception, tb=exc_tb)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-03-01 22:24:34.442 19168 TRACE neutron.service context)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-03-01 22:24:34.442 19168 TRACE neutron.service cursor.execute(statement, parameters)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-03-01 22:24:34.442 19168 TRACE neutron.service self.errorhandler(self, exc, value)
2015-03-01 22:24:34.442 19168 TRACE neutron.service File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-03-01 22:24:34.442 19168 TRACE neutron.service raise errorclass, errorvalue
2015-03-01 22:24:34.442 19168 TRACE neutron.service ProgrammingError: (ProgrammingError) (1146, "Table 'neutron.ml2_vlan_allocations' doesn't exist") '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 FOR UPDATE' ()
2015-03-01 22:24:34.442 19168 TRACE neutron.service
2015-03-01 22:24:34.477 19168 CRITICAL neutron [-] ProgrammingError: (ProgrammingError) (1146, "Table 'neutron.ml2_vlan_allocations' doesn't exist") '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 FOR UPDATE' ()

Tags:

Oleksiy Molchanov (omolchanov) on 2015-03-02

Changed in fuel:
assignee:	nobody → Fuel Library Team (fuel-library)
importance:	Undecided → High
status:	New → Confirmed

Revision history for this message

Bogdan Dobrelya (bogdando) wrote on 2015-03-02:

Please provide the environment details, reproduction steps and diagnostic logs

Changed in fuel:
status:	Confirmed → Incomplete

Revision history for this message

OSCI Robot (oscirobot) wrote on 2015-03-02:

DEB package python-mysqldb has been built for project packages/trusty/python-mysqldb
Package version == 1.2.5, package release == ubuntu1

Changeset: https://review.fuel-infra.org/4201
project: packages/trusty/python-mysqldb
branch: 6.1
author: Alexei Sheplyakov
committer: Alexei Sheplyakov
subject: Build python-mysqldb version 1.2.5 for Ubuntu 14.04
status: patchset-created

Files placed on repository:
python-mysqldb-dbg_1.2.5-1~mos6.1_amd64.deb
python-mysqldb_1.2.5-1~mos6.1_amd64.deb

NOTE: Changeset is not merged, created temporary package repository.
DEB repository URL: http://obs-1.mirantis.com:82/trusty-fuel-6.1-stable-4201/ubuntu

Revision history for this message

OSCI Robot (oscirobot) wrote on 2015-03-02:

DEB package python-mysqldb has been built for project packages/trusty/python-mysqldb
Package version == 1.2.5, package release == ubuntu1

Files placed on repository:
python-mysqldb-dbg_1.2.5-1~mos6.1_amd64.deb
python-mysqldb_1.2.5-1~mos6.1_amd64.deb

Changeset merged. Package placed on primary repository
DEB repository URL: http://obs-1.mirantis.com:82/trusty-fuel-6.1-stable/ubuntu

Vladimir Kuklin (vkuklin) on 2015-04-03

Changed in fuel:
status:	Incomplete → Fix Committed

Revision history for this message

Anastasia Palkina (apalkina) wrote on 2015-04-15:

Verified on ISO #304

"build_id": "2015-04-10_22-54-31", "ostf_sha": "c2a76a60ec4ebbd78e508216c2e12787bf25e423", "build_number": "304", "release_versions": {"2014.2-6.1": {"VERSION": {"build_id": "2015-04-10_22-54-31", "ostf_sha": "c2a76a60ec4ebbd78e508216c2e12787bf25e423", "build_number": "304", "api": "1.0", "nailgun_sha": "69547a71abb4696df7e6f44b1f7864b0535f2df7", "openstack_version": "2014.2-6.1", "production": "docker", "python-fuelclient_sha": "9208ff4a08dcb674ce2df132399a5aa3ddfac21c", "astute_sha": "d96a80b63198a578b2c159edbd76048819039eb0", "feature_groups": ["mirantis"], "release": "6.1", "fuelmain_sha": "8daac234aea6ac0a98f27871deec039f74f6fdab", "fuellib_sha": "867028fe78837dc2e4635a2cbb976782856964d0"}}}, "auth_required": true, "api": "1.0", "nailgun_sha": "69547a71abb4696df7e6f44b1f7864b0535f2df7", "openstack_version": "2014.2-6.1", "production": "docker", "python-fuelclient_sha": "9208ff4a08dcb674ce2df132399a5aa3ddfac21c", "astute_sha": "d96a80b63198a578b2c159edbd76048819039eb0", "feature_groups": ["mirantis"], "release": "6.1", "fuelmain_sha": "8daac234aea6ac0a98f27871deec039f74f6fdab", "fuellib_sha": "867028fe78837dc2e4635a2cbb976782856964d0"

Changed in fuel:
status:	Fix Committed → Fix Released

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.