← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1216851] Re: nova unit tests occasionally fail migration tests for mysql and postgres

 

Proposed fix: https://review.openstack.org/#/c/60021/

** Changed in: openstack-ci
       Status: Incomplete => Invalid

** Changed in: nova
     Assignee: (unassigned) => Roman Podoliaka (rpodolyaka)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1216851

Title:
  nova unit tests occasionally fail migration tests for mysql and
  postgres

Status in OpenStack Compute (Nova):
  Confirmed
Status in OpenStack Core Infrastructure:
  Invalid

Bug description:
  http://logs.openstack.org/80/43580/1/check/gate-nova-
  python27/ae0cd74/console.html

  013-08-26 09:18:25.324 | ======================================================================
  2013-08-26 09:18:25.324 | FAIL: nova.tests.db.test_migrations.TestNovaMigrations.test_postgresql_opportunistically
  2013-08-26 09:18:25.325 | tags: worker-0
  2013-08-26 09:18:25.325 | ----------------------------------------------------------------------
  ...
  2013-08-26 09:18:25.338 | 172 -> 173... 
  2013-08-26 09:18:25.339 | Deleted duplicated row with id: 2 from table: key_pairs
  2013-08-26 09:18:25.339 | Deleted duplicated row with id: 1 from table: key_pairs
  2013-08-26 09:18:25.339 | done
  2013-08-26 09:18:25.339 | Failed to migrate to version 173 on engine Engine(postgresql+psycopg2://openstack_citest:openstack_citest@localhost/openstack_citest)
  2013-08-26 09:18:25.339 | }}}
  2013-08-26 09:18:25.339 | 
  2013-08-26 09:18:25.340 | Traceback (most recent call last):
  2013-08-26 09:18:25.340 |   File "/home/jenkins/workspace/gate-nova-python27/nova/tests/db/test_migrations.py", line 175, in test_postgresql_opportunistically
  2013-08-26 09:18:25.340 |     self._test_postgresql_opportunistically()
  2013-08-26 09:18:25.340 |   File "/home/jenkins/workspace/gate-nova-python27/nova/tests/db/test_migrations.py", line 358, in _test_postgresql_opportunistically
  2013-08-26 09:18:25.340 |     self._walk_versions(engine, False, False)
  2013-08-26 09:18:25.340 |   File "/home/jenkins/workspace/gate-nova-python27/nova/tests/db/test_migrations.py", line 379, in _walk_versions
  2013-08-26 09:18:25.341 |     self._migrate_up(engine, version, with_data=True)
  2013-08-26 09:18:25.341 |   File "/home/jenkins/workspace/gate-nova-python27/nova/tests/db/test_migrations.py", line 444, in _migrate_up
  2013-08-26 09:18:25.341 |     check(engine, data)
  2013-08-26 09:18:25.341 |   File "/home/jenkins/workspace/gate-nova-python27/nova/tests/db/test_migrations.py", line 1233, in _check_173
  2013-08-26 09:18:25.341 |     insert.execute(duplicate_keypair)
  2013-08-26 09:18:25.341 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2841, in execute
  2013-08-26 09:18:25.341 |     return e._execute_clauseelement(self, multiparams, params)
  2013-08-26 09:18:25.342 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2453, in _execute_clauseelement
  2013-08-26 09:18:25.342 |     return connection._execute_clauseelement(elem, multiparams, params)
  2013-08-26 09:23:49.057 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
  2013-08-26 09:23:49.057 |     compiled_sql, distilled_params
  2013-08-26 09:23:49.057 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1732, in _execute_context
  2013-08-26 09:23:49.057 |     self._commit_impl()
  2013-08-26 09:23:49.057 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1280, in _commit_impl
  2013-08-26 09:23:49.057 |     self._handle_dbapi_exception(e, None, None, None, None)
  2013-08-26 09:23:49.058 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1828, in _handle_dbapi_exception
  2013-08-26 09:23:49.058 |     self._autorollback()
  2013-08-26 09:23:49.058 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1345, in _autorollback
  2013-08-26 09:23:49.058 |     self._rollback_impl()
  2013-08-26 09:23:49.058 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1265, in _rollback_impl
  2013-08-26 09:23:49.058 |     self._handle_dbapi_exception(e, None, None, None, None)
  2013-08-26 09:23:49.058 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1262, in _rollback_impl
  2013-08-26 09:23:49.059 |     self.engine.dialect.do_rollback(self.connection)
  2013-08-26 09:23:49.059 |   File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 300, in do_rollback
  2013-08-26 09:23:49.059 |     connection.rollback()
  2013-08-26 09:23:49.059 | InterfaceError: (InterfaceError) connection already closed None None

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1216851/+subscriptions