TestCapabilities.test_capability Database Locked

Bug #1343636 reported by Auston McReynolds
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Expired
Low
Unassigned

Bug Description

2014-07-17 21:05:10.689 | No handlers could be found for logger "trove.guestagent.backup.backupagent"
2014-07-17 21:05:11.334 | No handlers could be found for logger "trove.guestagent.strategies.storage.swift"
2014-07-17 21:05:16.306 | No handlers could be found for logger "trove.guestagent.backup.backupagent"
2014-07-17 21:05:21.643 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --list
2014-07-17 21:05:21.644 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpFgYEPZ
2014-07-17 21:05:21.644 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpApDTXU
2014-07-17 21:05:21.644 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpuOAPLx
2014-07-17 21:05:21.645 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpd_Njih
2014-07-17 21:05:21.645 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpWtBvKP
2014-07-17 21:05:21.645 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpklJaKl
2014-07-17 21:05:21.646 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpO3bBYm
2014-07-17 21:05:21.646 | running=${PYTHON:-python} -m subunit.run discover ./trove/tests/unittests --load-list /tmp/tmp.KyJiDRdF4C/tmpCDRf39
2014-07-17 21:05:21.646 | ======================================================================
2014-07-17 21:05:21.647 | FAIL: datastore.test_capability.TestCapabilities.test_capability
2014-07-17 21:05:21.647 | tags: worker-0
2014-07-17 21:05:21.647 | ----------------------------------------------------------------------
2014-07-17 21:05:21.647 | Traceback (most recent call last):
2014-07-17 21:05:21.648 | File "/home/jenkins/workspace/gate-trove-python27/trove/tests/unittests/datastore/test_capability.py", line 26, in tearDown
2014-07-17 21:05:21.648 | super(TestCapabilities, self).tearDown()
2014-07-17 21:05:21.648 | File "trove/tests/unittests/datastore/base.py", line 64, in tearDown
2014-07-17 21:05:21.649 | self.cap2.delete()
2014-07-17 21:05:21.649 | File "trove/datastore/models.py", line 190, in delete
2014-07-17 21:05:21.649 | self.db_info.delete()
2014-07-17 21:05:21.650 | File "trove/db/models.py", line 74, in delete
2014-07-17 21:05:21.650 | return self.db_api.delete(self)
2014-07-17 21:05:21.650 | File "trove/db/sqlalchemy/api.py", line 68, in delete
2014-07-17 21:05:21.650 | db_session.flush()
2014-07-17 21:05:21.651 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1907, in flush
2014-07-17 21:05:21.651 | self._flush(objects)
2014-07-17 21:05:21.651 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 2025, in _flush
2014-07-17 21:05:21.652 | transaction.rollback(_capture_exception=True)
2014-07-17 21:05:21.652 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
2014-07-17 21:05:21.652 | compat.reraise(exc_type, exc_value, exc_tb)
2014-07-17 21:05:21.653 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1989, in _flush
2014-07-17 21:05:21.653 | flush_context.execute()
2014-07-17 21:05:21.653 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 371, in execute
2014-07-17 21:05:21.653 | rec.execute(self)
2014-07-17 21:05:21.654 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 552, in execute
2014-07-17 21:05:21.654 | uow
2014-07-17 21:05:21.654 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 116, in delete_obj
2014-07-17 21:05:21.655 | cached_connections, mapper, table, delete)
2014-07-17 21:05:21.655 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 692, in _emit_delete_statements
2014-07-17 21:05:21.655 | c = connection.execute(statement, del_objects)
2014-07-17 21:05:21.656 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 727, in execute
2014-07-17 21:05:21.656 | return meth(self, multiparams, params)
2014-07-17 21:05:21.656 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
2014-07-17 21:05:21.657 | return connection._execute_clauseelement(self, multiparams, params)
2014-07-17 21:05:21.657 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 824, in _execute_clauseelement
2014-07-17 21:05:21.657 | compiled_sql, distilled_params
2014-07-17 21:05:21.658 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 954, in _execute_context
2014-07-17 21:05:21.658 | context)
2014-07-17 21:05:21.957 | File "/home/jenkins/workspace/gate-trove-python27/No handlers could be found for logger "trove.guestagent.backup.backupagent"
2014-07-17 21:05:22.326 | No handlers could be found for logger "trove.guestagent.backup.backupagent"
2014-07-17 21:05:23.491 | No handlers could be found for logger "trove.guestagent.strategies.storage.swift"
2014-07-17 21:05:26.001 | No handlers could be found for logger "trove.guestagent.backup.backupagent"
2014-07-17 21:05:26.515 | No handlers could be found for logger "trove.guestagent.models"
2014-07-17 21:05:31.611 | .tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
2014-07-17 21:05:31.611 | exc_info
2014-07-17 21:05:31.611 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
2014-07-17 21:05:31.612 | reraise(type(exception), exception, tb=exc_tb)
2014-07-17 21:05:31.612 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
2014-07-17 21:05:31.612 | context)
2014-07-17 21:05:31.612 | File "/home/jenkins/workspace/gate-trove-python27/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 435, in do_execute
2014-07-17 21:05:31.613 | cursor.execute(statement, parameters)
2014-07-17 21:05:31.613 | OperationalError: (OperationalError) database is locked u'DELETE FROM capabilities WHERE capabilities.id = ?' (u'2a185d05-b558-48a9-853f-78d814243b6b',)

Changed in trove:
status: New → Triaged
importance: Undecided → Low
milestone: none → ongoing
Revision history for this message
Amrith Kumar (amrith) wrote :

I'm marking this as incomplete and unassigned as it hasn't happened in the gate in a while.

Changed in trove:
status: Triaged → Incomplete
milestone: ongoing → none
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for OpenStack DBaaS (Trove) because there has been no activity for 60 days.]

Changed in trove:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.