Public bug reported:
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule
-------------------------------------------------------------------------------------
Captured pythonlogging:
~~~~~~~~~~~~~~~~~~~~~~~
2015-08-26 17:13:10,783 WARNING [oslo_config.cfg] Option "verbose" from
group "DEFAULT" is deprecated for removal. Its value may be silently ignored
in the future.
2015-08-26 17:13:10,799 INFO [neutron.manager] Loading core plugin:
neutron.db.db_base_plugin_v2.NeutronDbPluginV2
2015-08-26 17:13:10,800 WARNING [neutron.notifiers.nova] Authenticating to
nova using nova_admin_* options is deprecated. This should be done using an
auth plugin, like password
2015-08-26 17:13:10,802 INFO [neutron.manager] Loading Plugin: qos
2015-08-26 17:13:10,804 INFO
[neutron.services.qos.notification_drivers.manager] Loading message_queue
(Message queue updates) notification driver for QoS plugin
Captured traceback:
~~~~~~~~~~~~~~~~~~~
Traceback (most recent call last):
File "neutron/tests/unit/services/qos/test_qos_plugin.py", line 111, in
test_delete_policy_rule
self.ctxt, self.rule.id, self.policy.id)
File "neutron/services/qos/qos_plugin.py", line 128, in
delete_policy_bandwidth_limit_rule
policy.reload_rules()
File "neutron/objects/qos/policy.py", line 63, in reload_rules
rules = rule_obj_impl.get_rules(self._context, self.id)
File "neutron/objects/qos/rule.py", line 37, in get_rules
rules = rule_cls.get_objects(context, qos_policy_id=qos_policy_id)
File "neutron/objects/base.py", line 122, in get_objects
db_objs = db_api.get_objects(context, cls.db_model, **kwargs)
File "neutron/db/api.py", line 87, in get_objects
.filter_by(**kwargs)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2399, in all
return list(self)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2516, in __iter__
return self._execute_and_instances(context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2531, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 914, in execute
return meth(self, multiparams, params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/sql/elements.py",
line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1146, in _execute_context
context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1139, in _execute_context
context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table:
qos_bandwidth_limit_rules [SQL: u'SELECT qos_bandwidth_limit_rules.id AS
qos_bandwidth_limit_rules_id, qos_bandwidth_limit_rules.qos_policy_id AS
qos_bandwidth_limit_rules_qos_policy_id, qos_bandwidth_limit_rules.max_kbps AS
qos_bandwidth_limit_rules_max_kbps, qos_bandwidth_limit_rules.max_burst_kbps AS
qos_bandwidth_limit_rules_max_burst_kbps \nFROM qos_bandwidth_limit_rules
\nWHERE qos_bandwidth_limit_rules.qos_policy_id = ?'] [parameters: ('7777777',)]
======
Totals
======
Ran: 14 tests in 5.0000 sec.
- Passed: 10
- Skipped: 0
- Expected Fail: 0
- Unexpected Success: 0
- Failed: 4
Sum of execute time for each test: 2.2653 sec.
==============
Worker Balance
==============
- Worker 0 (1 tests) => 0:00:00.388500
- Worker 1 (1 tests) => 0:00:00.390602
- Worker 2 (1 tests) => 0:00:00.362367
- Worker 3 (1 tests) => 0:00:00.396344
- Worker 4 (1 tests) => 0:00:00.125718
- Worker 5 (2 tests) => 0:00:00.163376
- Worker 6 (2 tests) => 0:00:00.164033
- Worker 7 (5 tests) => 0:00:00.282335
Slowest Tests:
Test id
Runtime (s)
---------------------------------------------------------------------------------------------------------------------------
-----------
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_create_policy_rule
0.396
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_add_policy
0.391
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_update_policy_rule
0.389
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule
0.362
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_bandwidth_limit_rules_for_nonexistent_policy
0.145
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_create_policy_rule_for_nonexistent_policy
0.133
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy
0.133
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule_for_nonexistent_policy
0.126
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_bandwidth_limit_rules_for_policy_with_filters
0.044
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_for_nonexistent_policy
0.031
ERROR: InvocationError: '/mnt/data3/opt/stack/neutron/.tox/py27/bin/ostestr
--regex neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin'
_____________________________________________________________________________________________________
summary
_____________________________________________________________________________________________________
ERROR: py27: commands failed
** Affects: neutron
Importance: Undecided
Assignee: yong sheng gong (gongysh)
Status: In Progress
** Changed in: neutron
Assignee: (unassigned) => yong sheng gong (gongysh)
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1488868
Title:
failed to run test_qos_plugin.TestQosPlugin independently
Status in neutron:
In Progress
Bug description:
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule
-------------------------------------------------------------------------------------
Captured pythonlogging:
~~~~~~~~~~~~~~~~~~~~~~~
2015-08-26 17:13:10,783 WARNING [oslo_config.cfg] Option "verbose" from
group "DEFAULT" is deprecated for removal. Its value may be silently ignored
in the future.
2015-08-26 17:13:10,799 INFO [neutron.manager] Loading core plugin:
neutron.db.db_base_plugin_v2.NeutronDbPluginV2
2015-08-26 17:13:10,800 WARNING [neutron.notifiers.nova] Authenticating
to nova using nova_admin_* options is deprecated. This should be done using an
auth plugin, like password
2015-08-26 17:13:10,802 INFO [neutron.manager] Loading Plugin: qos
2015-08-26 17:13:10,804 INFO
[neutron.services.qos.notification_drivers.manager] Loading message_queue
(Message queue updates) notification driver for QoS plugin
Captured traceback:
~~~~~~~~~~~~~~~~~~~
Traceback (most recent call last):
File "neutron/tests/unit/services/qos/test_qos_plugin.py", line 111, in
test_delete_policy_rule
self.ctxt, self.rule.id, self.policy.id)
File "neutron/services/qos/qos_plugin.py", line 128, in
delete_policy_bandwidth_limit_rule
policy.reload_rules()
File "neutron/objects/qos/policy.py", line 63, in reload_rules
rules = rule_obj_impl.get_rules(self._context, self.id)
File "neutron/objects/qos/rule.py", line 37, in get_rules
rules = rule_cls.get_objects(context, qos_policy_id=qos_policy_id)
File "neutron/objects/base.py", line 122, in get_objects
db_objs = db_api.get_objects(context, cls.db_model, **kwargs)
File "neutron/db/api.py", line 87, in get_objects
.filter_by(**kwargs)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2399, in all
return list(self)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2516, in __iter__
return self._execute_and_instances(context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2531, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 914, in execute
return meth(self, multiparams, params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/sql/elements.py",
line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1146, in _execute_context
context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1337, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/util/compat.py",
line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1139, in _execute_context
context)
File
"/mnt/data3/opt/stack/neutron/.tox/py27/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such
table: qos_bandwidth_limit_rules [SQL: u'SELECT qos_bandwidth_limit_rules.id AS
qos_bandwidth_limit_rules_id, qos_bandwidth_limit_rules.qos_policy_id AS
qos_bandwidth_limit_rules_qos_policy_id, qos_bandwidth_limit_rules.max_kbps AS
qos_bandwidth_limit_rules_max_kbps, qos_bandwidth_limit_rules.max_burst_kbps AS
qos_bandwidth_limit_rules_max_burst_kbps \nFROM qos_bandwidth_limit_rules
\nWHERE qos_bandwidth_limit_rules.qos_policy_id = ?'] [parameters: ('7777777',)]
======
Totals
======
Ran: 14 tests in 5.0000 sec.
- Passed: 10
- Skipped: 0
- Expected Fail: 0
- Unexpected Success: 0
- Failed: 4
Sum of execute time for each test: 2.2653 sec.
==============
Worker Balance
==============
- Worker 0 (1 tests) => 0:00:00.388500
- Worker 1 (1 tests) => 0:00:00.390602
- Worker 2 (1 tests) => 0:00:00.362367
- Worker 3 (1 tests) => 0:00:00.396344
- Worker 4 (1 tests) => 0:00:00.125718
- Worker 5 (2 tests) => 0:00:00.163376
- Worker 6 (2 tests) => 0:00:00.164033
- Worker 7 (5 tests) => 0:00:00.282335
Slowest Tests:
Test id
Runtime (s)
---------------------------------------------------------------------------------------------------------------------------
-----------
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_create_policy_rule
0.396
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_add_policy
0.391
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_update_policy_rule
0.389
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule
0.362
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_bandwidth_limit_rules_for_nonexistent_policy
0.145
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_create_policy_rule_for_nonexistent_policy
0.133
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy
0.133
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_delete_policy_rule_for_nonexistent_policy
0.126
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_bandwidth_limit_rules_for_policy_with_filters
0.044
neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin.test_get_policy_for_nonexistent_policy
0.031
ERROR: InvocationError: '/mnt/data3/opt/stack/neutron/.tox/py27/bin/ostestr
--regex neutron.tests.unit.services.qos.test_qos_plugin.TestQosPlugin'
_____________________________________________________________________________________________________
summary
_____________________________________________________________________________________________________
ERROR: py27: commands failed
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1488868/+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
