Public bug reported:
Example:
vmware_nsx.tests.unit.services.qos.test_nsxv3_notification.TestQosNsxV3Notification.test_policy_delete_profile
--------------------------------------------------------------------------------------------------------------
Captured traceback-1:
~~~~~~~~~~~~~~~~~~~~~
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/fixtures/fixture.py", line 125, in
cleanUp
return self._cleanups(raise_errors=raise_first)
File "/usr/lib/python2.7/dist-packages/fixtures/callmany.py", line 89, in
__call__
reraise(error[0], error[1], error[2])
File "/usr/lib/python2.7/dist-packages/fixtures/callmany.py", line 83, in
__call__
cleanup(*args, **kwargs)
File
"/usr/lib/python2.7/dist-packages/neutron/tests/unit/testlib_api.py", line 98,
in <lambda>
self.addCleanup(lambda: self._delete_from_schema(engine))
File
"/usr/lib/python2.7/dist-packages/neutron/tests/unit/testlib_api.py", line 83,
in _delete_from_schema
conn.execute(table.delete())
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
914, in execute
return meth(self, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line
323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1146, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line
203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1139, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such
table: nsxv_lbaas_l7policy_bindings [SQL: u'DELETE FROM
nsxv_lbaas_l7policy_bindings']
Captured traceback:
~~~~~~~~~~~~~~~~~~~
Traceback (most recent call last):
File "vmware_nsx/tests/unit/services/qos/test_nsxv3_notification.py",
line 44, in setUp
super(TestQosNsxV3Notification, self).setUp()
File
"/usr/lib/python2.7/dist-packages/neutron/tests/unit/services/qos/base.py",
line 23, in setUp
super(BaseQosTestCase, self).setUp()
File "vmware_nsx/tests/unit/nsx_v3/test_plugin.py", line 170, in setUp
ext_mgr=ext_mgr)
File
"/usr/lib/python2.7/dist-packages/neutron/tests/unit/db/test_db_base_plugin_v2.py",
line 132, in setUp
self.api = router.APIRouter()
File "/usr/lib/python2.7/dist-packages/neutron/api/v2/router.py", line
77, in __init__
manager.init()
File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 291, in
init
NeutronManager.get_instance()
File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 241, in
get_instance
cls._create_instance()
File "/usr/lib/python2.7/dist-packages/oslo_concurrency/lockutils.py",
line 274, in inner
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 227, in
_create_instance
cls._instance = cls()
File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 131, in
__init__
plugin_provider)
File "/usr/lib/python2.7/dist-packages/neutron/manager.py", line 164, in
_get_plugin_instance
return plugin_class()
File
"/usr/lib/python2.7/dist-packages/neutron/quota/resource_registry.py", line
127, in wrapper
return f(*args, **kwargs)
File "vmware_nsx/plugins/nsx_v3/plugin.py", line 205, in __init__
self._process_security_group_logging()
File "vmware_nsx/plugins/nsx_v3/plugin.py", line 479, in
_process_security_group_logging
utils.spawn_n(process_security_group_logging)
File "/usr/lib/python2.7/dist-packages/mock/mock.py", line 1062, in
__call__
return _mock_self._mock_call(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/mock/mock.py", line 1128, in
_mock_call
ret_val = effect(*args, **kwargs)
File "vmware_nsx/tests/unit/nsx_v/test_plugin.py", line 3298, in <lambda>
c_utils.spawn_n = mock.Mock(side_effect=lambda f: f())
File "vmware_nsx/plugins/nsx_v3/plugin.py", line 466, in
process_security_group_logging
sg_logging.LOGGING])
File "vmware_nsx/plugins/nsx_v3/plugin.py", line 3171, in
get_security_groups
default_sg=default_sg)
File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 166, in
wrapped
return method(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 95, in
wrapped
setattr(e, '_RETRY_EXCEEDED', True)
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220,
in __exit__
self.force_reraise()
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196,
in force_reraise
six.reraise(self.type_, self.value, self.tb)
File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 91, in
wrapped
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in
wrapper
ectxt.value = e.inner_exc
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220,
in __exit__
self.force_reraise()
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196,
in force_reraise
six.reraise(self.type_, self.value, self.tb)
File "/usr/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in
wrapper
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 131, in
wrapped
traceback.format_exc())
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220,
in __exit__
self.force_reraise()
File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196,
in force_reraise
six.reraise(self.type_, self.value, self.tb)
File "/usr/lib/python2.7/dist-packages/neutron/db/api.py", line 126, in
wrapped
return f(*dup_args, **dup_kwargs)
File "/usr/lib/python2.7/dist-packages/neutron/db/securitygroups_db.py",
line 157, in get_security_groups
page_reverse=page_reverse)
File "/usr/lib/python2.7/dist-packages/neutron/db/common_db_mixin.py",
line 276, in _get_collection
for c in query]
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2761, in __iter__
return self._execute_and_instances(context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2776, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
914, in execute
return meth(self, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line
323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1146, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line
203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1139, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such
table: securitygroups [SQL: u'SELECT securitygroups.project_id AS
securitygroups_project_id, securitygroups.id AS securitygroups_id,
securitygroups.name AS securitygroups_name, securitygroups.standard_attr_id AS
securitygroups_standard_attr_id, standardattributes_1.id AS
standardattributes_1_id, standardattributes_1.resource_type AS
standardattributes_1_resource_type, standardattributes_1.description AS
standardattributes_1_description, standardattributes_1.revision_number AS
standardattributes_1_revision_number, standardattributes_1.created_at AS
standardattributes_1_created_at, standardattributes_1.updated_at AS
standardattributes_1_updated_at,
nsx_extended_security_group_properties_1.security_group_id AS
nsx_extended_security_group_properties_1_security_group_id,
nsx_extended_security_group_properties_1.logging AS
nsx_extended_security_group_properties_1_logging,
nsx_extended_security_group_properties_1.p
rovider AS nsx_extended_security_group_properties_1_provider,
nsx_extended_security_group_properties_1.policy AS
nsx_extended_security_group_properties_1_policy \nFROM securitygroups LEFT
OUTER JOIN standardattributes AS standardattributes_1 ON
standardattributes_1.id = securitygroups.standard_attr_id LEFT OUTER JOIN
nsx_extended_security_group_properties AS
nsx_extended_security_group_properties_1 ON securitygroups.id =
nsx_extended_security_group_properties_1.security_group_id']
** Affects: vmware-nsx (Ubuntu)
Importance: Medium
Status: Triaged
** Changed in: vmware-nsx (Ubuntu)
Status: New => Triaged
** Changed in: vmware-nsx (Ubuntu)
Importance: Undecided => Medium
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1676712
Title:
random sqlite related failure during unit testing
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/vmware-nsx/+bug/1676712/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
