** Changed in: neutron
       Status: Incomplete => Invalid

-- 
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:
  Invalid

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to