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