Comment 2 for bug 1204456

Revision history for this message
Sukhdev Kapur (sukhdev-8) wrote :

Numerous ml2 tests are failing which seem to be related to this. Following is the list of test that are failing, along with the traceback which is for each of the failed tests:

neutron.tests.unit.ml2.test_agent_scheduler.Ml2AgentSchedulerTestCase
neutron.tests.unit.ml2.test_agent_scheduler.Ml2DhcpAgentNotifierTestCase
neutron.tests.unit.ml2.test_agent_scheduler.Ml2L3AgentNotifierTestCase
neutron.tests.unit.ml2.test_ml2_plugin.TestMl2BasicGet
neutron.tests.unit.ml2.test_ml2_plugin.TestMl2NetworksV2
neutron.tests.unit.ml2.test_ml2_plugin.TestMl2PortBindingHost
neutron.tests.unit.ml2.test_ml2_plugin.TestMl2PortsV2
neutron.tests.unit.ml2.test_ml2_plugin.TestMl2V2HTTPResponse
neutron.tests.unit.ml2.test_security_group.TestMl2SecurityGroups
neutron.tests.unit.ml2.test_security_group.TestMl2SecurityGroupsXML

All of these tests fail with the same traceback log. It seems like this is related to table "ml2_vlan_allocations"

Here is the traceback log:

Traceback (most recent call last):
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/tests/unit/ml2/test_ml2_plugin.py", line 36, in setUp
    super(Ml2PluginV2TestCase, self).setUp(PLUGIN_NAME)
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/tests/unit/test_db_plugin.py", line 122, in setUp
    self.api = APIRouter()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/api/v2/router.py", line 76, in __init__
    plugin = manager.NeutronManager.get_plugin()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/manager.py", line 206, in get_plugin
    return cls.get_instance().plugin
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/manager.py", line 201, in get_instance
    cls._create_instance()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/openstack/common/lockutils.py", line 247, in inner
    retval = f(*args, **kwargs)
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/manager.py", line 195, in _create_instance
    cls._instance = cls()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/manager.py", line 120, in __init__
    self.plugin = plugin_klass()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/plugins/ml2/plugin.py", line 93, in __init__
    self.type_manager.initialize()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/plugins/ml2/managers.py", line 79, in initialize
    driver.obj.initialize()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/plugins/ml2/drivers/type_vlan.py", line 160, in initialize
    self._sync_vlan_allocations()
  File "/home/jenkins/workspace/gate-neutron-python26/neutron/plugins/ml2/drivers/type_vlan.py", line 103, in _sync_vlan_allocations
    for alloc in allocs:
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/home/jenkins/workspace/gate-neutron-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
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' ()