← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1630826] [NEW] Neutron unit tests failures due to OperationalError: (sqlite3.OperationalError) no such table

 

Public bug reported:

Release: stable/liberty
Tag: 7.0.4

Neutron unit tests are failing inconsistently, every run has different
set of failures, around 300+ tests are failing with this following
error:

{0}
neutron.tests.unit.services.metering.test_metering_plugin.TestMeteringPluginL3AgentSchedulerServicePlugin.test_add_metering_label_rpc_call
[0.428998s] ... FAILED

Captured traceback:
~~~~~~~~~~~~~~~~~~~
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/services/metering/test_metering_plugin.py", line 374, in test_add_metering_label_rpc_call
        set_context=True):
      File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
        return self.gen.next()
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/db/metering/test_metering_db.py", line 94, in metering_label
        description, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/db/metering/test_metering_db.py", line 58, in _make_metering_label
        raise webob.exc.HTTPClientError(code=res.status_int)
    webob.exc.HTTPClientError: The server could not comply with the request since it is either malformed or otherwise incorrect.


Captured pythonlogging:
~~~~~~~~~~~~~~~~~~~~~~~
    2016-09-29 15:33:52,379     INFO [neutron.manager] Loading core plugin: neutron.tests.unit.extensions.test_l3.TestNoL3NatPlugin
    2016-09-29 15:33:52,379     INFO [neutron.manager] Loading Plugin: neutron.services.metering.metering_plugin.MeteringPlugin
    2016-09-29 15:33:52,380     INFO [neutron.manager] Loading Plugin: neutron.tests.unit.extensions.test_l3.TestL3NatAgentSchedulingServicePlugin
    2016-09-29 15:33:52,411  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,472     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:subnet
    2016-09-29 15:33:52,472  WARNING [neutron.quota.resource_registry] subnet is already registered
    2016-09-29 15:33:52,473  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,511     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:subnetpool
    2016-09-29 15:33:52,511  WARNING [neutron.quota.resource_registry] subnetpool is already registered
    2016-09-29 15:33:52,512  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,550     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:network
    2016-09-29 15:33:52,550  WARNING [neutron.quota.resource_registry] network is already registered
    2016-09-29 15:33:52,551  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,589     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:port
    2016-09-29 15:33:52,589  WARNING [neutron.quota.resource_registry] port is already registered
    2016-09-29 15:33:52,593     INFO [neutron.common.config] Config paste file: /home/jenkins/workspace/neutron@2/neutron/tests/etc/api-paste.ini.test
    2016-09-29 15:33:52,596     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:router
    2016-09-29 15:33:52,596  WARNING [neutron.quota.resource_registry] router is already registered
    2016-09-29 15:33:52,597  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,634     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:floatingip
    2016-09-29 15:33:52,635  WARNING [neutron.quota.resource_registry] floatingip is already registered
    2016-09-29 15:33:52,635  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,673  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,709  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
    2016-09-29 15:33:52,773    ERROR [neutron.api.v2.resource] create failed
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
        result = method(request=request, **args)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
        return self._create(request, body, **kwargs)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
        ectxt.value = e.inner_exc
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
        six.reraise(self.type_, self.value, self.tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
        return f(*args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
        plugin)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
        count = QUOTAS.count(context, resource, plugin, tenant_id)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
        return res.count(context, *args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
        context, self.name, tenant_id, lock_for_update=True)
      File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
        result = query.first()
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
        ret = list(self[0:1])
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
        return list(res)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
        return self._execute_and_instances(context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
        result = conn.execute(querycontext.statement, self._params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
        return meth(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
        return connection._execute_clauseelement(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
        compiled_sql, distilled_params
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
        util.raise_from_cause(newraise, exc_info)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
        reraise(type(exception), exception, tb=exc_tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
        cursor.execute(statement, parameters)
    OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'a7e61382-47b8-4d40-bae3-f95981b5637b', 'router', 1, 0)]
    2016-09-29 15:33:52,778    ERROR [neutron.api.v2.resource] create failed
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
        result = method(request=request, **args)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
        return self._create(request, body, **kwargs)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
        ectxt.value = e.inner_exc
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
        six.reraise(self.type_, self.value, self.tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
        return f(*args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
        self._plugin)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 266, in make_reservation
        plugin)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
        count = QUOTAS.count(context, resource, plugin, tenant_id)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
        return res.count(context, *args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
        context, self.name, tenant_id, lock_for_update=True)
      File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
        result = query.first()
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
        ret = list(self[0:1])
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
        return list(res)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
        return self._execute_and_instances(context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
        result = conn.execute(querycontext.statement, self._params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
        return meth(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
        return connection._execute_clauseelement(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
        compiled_sql, distilled_params
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
        util.raise_from_cause(newraise, exc_info)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
        reraise(type(exception), exception, tb=exc_tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
        cursor.execute(statement, parameters)
    OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'a7e61382-47b8-4d40-bae3-f95981b5637b', 'router', 1, 0)]
    2016-09-29 15:33:52,781    ERROR [neutron.api.v2.resource] create failed
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
        result = method(request=request, **args)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
        return self._create(request, body, **kwargs)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
        ectxt.value = e.inner_exc
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
        six.reraise(self.type_, self.value, self.tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
        return f(*args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 521, in _create
        obj = do_create(body)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 503, in do_create


Another test failure

{0}
neutron.tests.unit.plugins.opencontrail.test_contrail_plugin.TestContrailSecurityGroups.test_create_security_group_rule_group_id
[0.773572s] ... FAILED

Captured traceback:
~~~~~~~~~~~~~~~~~~~
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 743, in test_create_security_group_rule_group_id
        with self.security_group(name, description) as sg:
      File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
        return self.gen.next()
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 126, in security_group
        security_group = self._make_security_group(fmt, name, description)
      File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 112, in _make_security_group
        raise webob.exc.HTTPClientError(code=res.status_int)
    webob.exc.HTTPClientError: The server could not comply with the request since it is either malformed or otherwise incorrect.


Captured pythonlogging:
~~~~~~~~~~~~~~~~~~~~~~~
    2016-09-30 12:54:46,024     INFO [neutron.manager] Loading core plugin: neutron.plugins.opencontrail.contrail_plugin.NeutronPluginContrailCoreV2
    2016-09-30 12:54:46,024     INFO [neutron.manager] Service L3_ROUTER_NAT is supported by the core plugin
 2016-09-30 12:54:46,764    ERROR [neutron.api.v2.resource] create failed
    Traceback (most recent call last):
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
        result = method(request=request, **args)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
        return self._create(request, body, **kwargs)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
        ectxt.value = e.inner_exc
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
        six.reraise(self.type_, self.value, self.tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
        return f(*args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
        self._plugin)
   File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 266, in make_reservation
        plugin)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
        count = QUOTAS.count(context, resource, plugin, tenant_id)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
        return res.count(context, *args, **kwargs)
      File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
        context, self.name, tenant_id, lock_for_update=True)
      File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
        result = query.first()
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
        ret = list(self[0:1])
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
        return list(res)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
        return self._execute_and_instances(context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
        result = conn.execute(querycontext.statement, self._params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
        return meth(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
        return connection._execute_clauseelement(self, multiparams, params)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
        compiled_sql, distilled_params
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
        util.raise_from_cause(newraise, exc_info)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
        reraise(type(exception), exception, tb=exc_tb)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
        context)
      File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
        cursor.execute(statement, parameters)
   OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'test-tenant', 'security_group', 1, 0)]

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1630826

Title:
  Neutron unit tests failures due to OperationalError:
  (sqlite3.OperationalError) no such table

Status in neutron:
  New

Bug description:
  Release: stable/liberty
  Tag: 7.0.4

  Neutron unit tests are failing inconsistently, every run has different
  set of failures, around 300+ tests are failing with this following
  error:

  {0}
  neutron.tests.unit.services.metering.test_metering_plugin.TestMeteringPluginL3AgentSchedulerServicePlugin.test_add_metering_label_rpc_call
  [0.428998s] ... FAILED

  Captured traceback:
  ~~~~~~~~~~~~~~~~~~~
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/services/metering/test_metering_plugin.py", line 374, in test_add_metering_label_rpc_call
          set_context=True):
        File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
          return self.gen.next()
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/db/metering/test_metering_db.py", line 94, in metering_label
          description, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/db/metering/test_metering_db.py", line 58, in _make_metering_label
          raise webob.exc.HTTPClientError(code=res.status_int)
      webob.exc.HTTPClientError: The server could not comply with the request since it is either malformed or otherwise incorrect.

  
  Captured pythonlogging:
  ~~~~~~~~~~~~~~~~~~~~~~~
      2016-09-29 15:33:52,379     INFO [neutron.manager] Loading core plugin: neutron.tests.unit.extensions.test_l3.TestNoL3NatPlugin
      2016-09-29 15:33:52,379     INFO [neutron.manager] Loading Plugin: neutron.services.metering.metering_plugin.MeteringPlugin
      2016-09-29 15:33:52,380     INFO [neutron.manager] Loading Plugin: neutron.tests.unit.extensions.test_l3.TestL3NatAgentSchedulingServicePlugin
      2016-09-29 15:33:52,411  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,472     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:subnet
      2016-09-29 15:33:52,472  WARNING [neutron.quota.resource_registry] subnet is already registered
      2016-09-29 15:33:52,473  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,511     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:subnetpool
      2016-09-29 15:33:52,511  WARNING [neutron.quota.resource_registry] subnetpool is already registered
      2016-09-29 15:33:52,512  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,550     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:network
      2016-09-29 15:33:52,550  WARNING [neutron.quota.resource_registry] network is already registered
      2016-09-29 15:33:52,551  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,589     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:port
      2016-09-29 15:33:52,589  WARNING [neutron.quota.resource_registry] port is already registered
      2016-09-29 15:33:52,593     INFO [neutron.common.config] Config paste file: /home/jenkins/workspace/neutron@2/neutron/tests/etc/api-paste.ini.test
      2016-09-29 15:33:52,596     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:router
      2016-09-29 15:33:52,596  WARNING [neutron.quota.resource_registry] router is already registered
      2016-09-29 15:33:52,597  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,634     INFO [neutron.quota.resource_registry] Creating instance of TrackedResource for resource:floatingip
      2016-09-29 15:33:52,635  WARNING [neutron.quota.resource_registry] floatingip is already registered
      2016-09-29 15:33:52,635  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,673  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,709  WARNING [neutron.notifiers.nova] Authenticating to nova using nova_admin_* options is deprecated. This should be done using an auth plugin, like password
      2016-09-29 15:33:52,773    ERROR [neutron.api.v2.resource] create failed
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
          result = method(request=request, **args)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
          return self._create(request, body, **kwargs)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
          ectxt.value = e.inner_exc
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
          six.reraise(self.type_, self.value, self.tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
          return f(*args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
          plugin)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
          count = QUOTAS.count(context, resource, plugin, tenant_id)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
          return res.count(context, *args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
          context, self.name, tenant_id, lock_for_update=True)
        File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
          result = query.first()
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
          ret = list(self[0:1])
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
          return list(res)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
          return self._execute_and_instances(context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
          result = conn.execute(querycontext.statement, self._params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
          return meth(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
          return connection._execute_clauseelement(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
          compiled_sql, distilled_params
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
          util.raise_from_cause(newraise, exc_info)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
          reraise(type(exception), exception, tb=exc_tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
          cursor.execute(statement, parameters)
      OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'a7e61382-47b8-4d40-bae3-f95981b5637b', 'router', 1, 0)]
      2016-09-29 15:33:52,778    ERROR [neutron.api.v2.resource] create failed
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
          result = method(request=request, **args)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
          return self._create(request, body, **kwargs)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
          ectxt.value = e.inner_exc
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
          six.reraise(self.type_, self.value, self.tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
          return f(*args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
          self._plugin)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 266, in make_reservation
          plugin)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
          count = QUOTAS.count(context, resource, plugin, tenant_id)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
          return res.count(context, *args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
          context, self.name, tenant_id, lock_for_update=True)
        File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
          result = query.first()
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
          ret = list(self[0:1])
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
          return list(res)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
          return self._execute_and_instances(context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
          result = conn.execute(querycontext.statement, self._params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
          return meth(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
          return connection._execute_clauseelement(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
          compiled_sql, distilled_params
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
          util.raise_from_cause(newraise, exc_info)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
          reraise(type(exception), exception, tb=exc_tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
          cursor.execute(statement, parameters)
      OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'a7e61382-47b8-4d40-bae3-f95981b5637b', 'router', 1, 0)]
      2016-09-29 15:33:52,781    ERROR [neutron.api.v2.resource] create failed
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
          result = method(request=request, **args)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
          return self._create(request, body, **kwargs)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
          ectxt.value = e.inner_exc
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
          six.reraise(self.type_, self.value, self.tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
          return f(*args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 521, in _create
          obj = do_create(body)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 503, in do_create

  
  Another test failure

  {0}
  neutron.tests.unit.plugins.opencontrail.test_contrail_plugin.TestContrailSecurityGroups.test_create_security_group_rule_group_id
  [0.773572s] ... FAILED

  Captured traceback:
  ~~~~~~~~~~~~~~~~~~~
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 743, in test_create_security_group_rule_group_id
          with self.security_group(name, description) as sg:
        File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
          return self.gen.next()
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 126, in security_group
          security_group = self._make_security_group(fmt, name, description)
        File "/home/jenkins/workspace/neutron@2/neutron/tests/unit/extensions/test_securitygroup.py", line 112, in _make_security_group
          raise webob.exc.HTTPClientError(code=res.status_int)
      webob.exc.HTTPClientError: The server could not comply with the request since it is either malformed or otherwise incorrect.

  
  Captured pythonlogging:
  ~~~~~~~~~~~~~~~~~~~~~~~
      2016-09-30 12:54:46,024     INFO [neutron.manager] Loading core plugin: neutron.plugins.opencontrail.contrail_plugin.NeutronPluginContrailCoreV2
      2016-09-30 12:54:46,024     INFO [neutron.manager] Service L3_ROUTER_NAT is supported by the core plugin
   2016-09-30 12:54:46,764    ERROR [neutron.api.v2.resource] create failed
      Traceback (most recent call last):
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/resource.py", line 83, in resource
          result = method(request=request, **args)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 410, in create
          return self._create(request, body, **kwargs)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 146, in wrapper
          ectxt.value = e.inner_exc
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_utils/excutils.py", line 195, in __exit__
          six.reraise(self.type_, self.value, self.tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/oslo_db/api.py", line 136, in wrapper
          return f(*args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/api/v2/base.py", line 454, in _create
          self._plugin)
     File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 266, in make_reservation
          plugin)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 165, in make_reservation
          count = QUOTAS.count(context, resource, plugin, tenant_id)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/__init__.py", line 239, in count
          return res.count(context, *args, **kwargs)
        File "/home/jenkins/workspace/neutron@2/neutron/quota/resource.py", line 260, in count
          context, self.name, tenant_id, lock_for_update=True)
        File "/home/jenkins/workspace/neutron@2/neutron/db/quota/api.py", line 60, in get_quota_usage_by_resource_and_tenant
          result = query.first()
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2630, in first
          ret = list(self[0:1])
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in __getitem__
          return list(res)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2732, in __iter__
          return self._execute_and_instances(context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2747, in _execute_and_instances
          result = conn.execute(querycontext.statement, self._params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
          return meth(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
          return connection._execute_clauseelement(self, multiparams, params)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
          compiled_sql, distilled_params
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
          util.raise_from_cause(newraise, exc_info)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
          reraise(type(exception), exception, tb=exc_tb)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
          context)
        File "/home/jenkins/workspace/neutron@2/.venv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
          cursor.execute(statement, parameters)
     OperationalError: (sqlite3.OperationalError) no such table: quotausages [SQL: u'SELECT quotausages.resource AS quotausages_resource, quotausages.tenant_id AS quotausages_tenant_id, quotausages.dirty AS quotausages_dirty, quotausages.in_use AS quotausages_in_use, quotausages.reserved AS quotausages_reserved \nFROM quotausages \nWHERE quotausages.tenant_id = ? AND quotausages.resource = ?\n LIMIT ? OFFSET ?'] [parameters: (u'test-tenant', 'security_group', 1, 0)]

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


Follow ups