triggered build hangs after failure

[kgalloway1]

I have a periodic build that triggers several other builds all with waitForFinish=True. I am seeing the periodic build hanging after one of the triggered builds fails. Seems to be a database locking issue:

2011-08-24 10:21:27-0400 [-] while marking build requests as completed

Traceback (most recent call last):

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/threading.py", line 499, in bootstrap

self.bootstrap_inner()

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/threading.py", line 527, in bootstrap_inner

self.run()

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/threading.py", line 479, in run

self.target(*self.args, self.kwargs)

--- <exception caught here> ---

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/Twisted-11.0.0-py2.6-linux-x86_64.egg/twisted/python/threadpool.py", line 207, in _worker

result = context.call(ctx, function, *args, kwargs)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/Twisted-11.0.0-py2.6-linux-x86_64.egg/twisted/python/context.py", line 118, in callWithContext

return self.currentContext().callWithContext(ctx, func, *args, kw)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/Twisted-11.0.0-py2.6-linux-x86_64.egg/twisted/python/context.py", line 81, in callWithContext

return func(*args,kw)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/buildbot-0.8.4p2-py2.6.egg/buildbot/db/pool.py", line 114, in thd

rv = callable(conn, *args, kwargs)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/buildbot-0.8.4p2-py2.6.egg/buildbot/db/buildrequests.py", line 342, in thd

complete_at=_reactor.seconds())

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/SQLAlchemy-0.7.3dev-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1399, in execute

params)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/SQLAlchemy-0.7.3dev-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement

compiled_sql, distilled_params

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/SQLAlchemy-0.7.3dev-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1640, in _execute_context

context)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/SQLAlchemy-0.7.3dev-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1633, in _execute_context

context)

File "/bb/bigstorq0/apibuild/virtualpy/lib/python2.6/site-packages/SQLAlchemy-0.7.3dev-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 325, in do_execute

cursor.execute(statement, parameters)

sqlalchemy.exc.OperationalError?: (OperationalError?) database is locked u'UPDATE buildrequests SET complete=?, results=?, complete_at=? WHERE buildrequests.id IN (?) AND buildrequests.claimed_at IS NOT NULL AND buildrequests.claimed_by_name = ? AND buildrequests.claimed_by_incarnation = ? AND buildrequests.complete = ?' (1, 2, 1314195682.9059579, 405, '<BASEDIR - Removed before posting>', 'pid64701-boot1314125278', 0)

[dustin]

This looks like #2005.

You should be able to fix it by applying

 https://github.com/buildbot/buildbot/commit/4050c5e7a2641df56f792b06fc1aea6c16221e8f