yahoo-eng-team team mailing list archive

[Ilya Pekelny <pekelny@xxxxxxxxx>]

** Also affects: keystone
   Importance: Undecided
       Status: New

** Changed in: keystone
       Status: New => In Progress

** Changed in: keystone
     Assignee: (unassigned) => Ilya Pekelny (i159)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1288916

Title:
  Race in db test cases

Status in OpenStack Identity (Keystone):
  In Progress
Status in Oslo - a Library of Common OpenStack Code:
  Fix Released

Bug description:
  As I understand it, this is a known issue that's being worked, but
  it's failing on a pretty regular basis in the oslo-incubator gate so
  I'm filing a bug to recheck against.  The problem manifests as
  something like the following:

  2014-03-06 17:59:21.354 | FAIL: tests.unit.db.sqlalchemy.test_sqlalchemy.MySQLTraditionalModeTestCase.test_string_too_long
  2014-03-06 17:59:21.355 | tags: worker-1
  2014-03-06 17:59:21.355 | ----------------------------------------------------------------------
  2014-03-06 17:59:21.355 | Empty attachments:
  2014-03-06 17:59:21.356 |   stderr
  2014-03-06 17:59:21.356 |   stdout
  2014-03-06 17:59:21.356 | 
  2014-03-06 17:59:21.357 | pythonlogging:'': {{{INFO [openstack.common.db.sqlalchemy.session] MySQL server mode set to TRADITIONAL}}}
  2014-03-06 17:59:21.357 | 
  2014-03-06 17:59:21.357 | Traceback (most recent call last):
  2014-03-06 17:59:21.358 |   File "tests/unit/db/sqlalchemy/test_sqlalchemy.py", line 278, in setUp
  2014-03-06 17:59:21.358 |     self.test_table.create()
  2014-03-06 17:59:21.358 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/schema.py", line 616, in create
  2014-03-06 17:59:21.359 |     checkfirst=checkfirst)
  2014-03-06 17:59:21.359 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1479, in _run_visitor
  2014-03-06 17:59:21.359 |     conn._run_visitor(visitorcallable, element, **kwargs)
  2014-03-06 17:59:37.780 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1122, in _run_visitor
  2014-03-06 17:59:37.781 |     **kwargs).traverse_single(element)
  2014-03-06 17:59:37.781 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 122, in traverse_single
  2014-03-06 17:59:37.782 |     return meth(obj, **kw)
  2014-03-06 17:59:37.782 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 89, in visit_table
  2014-03-06 17:59:37.782 |     self.connection.execute(schema.CreateTable(table))
  2014-03-06 17:59:37.783 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 662, in execute
  2014-03-06 17:59:37.783 |     params)
  2014-03-06 17:59:37.783 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 720, in _execute_ddl
  2014-03-06 17:59:37.784 |     compiled
  2014-03-06 17:59:37.784 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
  2014-03-06 17:59:37.784 |     context)
  2014-03-06 17:59:37.784 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
  2014-03-06 17:59:37.785 |     exc_info
  2014-03-06 17:59:37.785 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
  2014-03-06 17:59:37.785 |     reraise(type(exception), exception, tb=exc_tb)
  2014-03-06 17:59:37.786 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
  2014-03-06 17:59:37.786 |     context)
  2014-03-06 17:59:37.786 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 324, in do_execute
  2014-03-06 17:59:37.787 |     cursor.execute(statement, parameters)
  2014-03-06 17:59:37.787 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/MySQLdb/cursors.py", line 205, in execute
  2014-03-06 17:59:37.789 |     self.errorhandler(self, exc, value)
  2014-03-06 17:59:37.789 |   File "/home/jenkins/workspace/gate-oslo-incubator-python26/.tox/py26/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  2014-03-06 17:59:37.790 |     raise errorclass, errorvalue
  2014-03-06 17:59:37.790 | OperationalError: (OperationalError) (1050, "Table '__tmp__test__tmp__mode' already exists") '\nCREATE TABLE __tmp__test__tmp__mode (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tbar VARCHAR(255), \n\tPRIMARY KEY (id)\n)\n\n' ()

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