** 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

-- 
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

Reply via email to