yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #58350
[Bug 1630826] Re: Neutron unit tests failures due to OperationalError: (sqlite3.OperationalError) no such table
** 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
References
