← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1488868] [NEW] failed to run test_qos_plugin.TestQosPlugin independently

 

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


Follow ups