[Buildbot-commits] [Buildbot] #1833: test for left-open database cursors

[Buildbot]

#1833: test for left-open database cursors
---------------------+-----------------------------
Reporter:  dustin    |      Owner:  dustin
    Type:  defect    |     Status:  new
Priority:  critical  |  Milestone:  0.8.4
 Version:  0.8.3p1   |   Keywords:  database, tests
---------------------+-----------------------------
 Or find some way to prevent them.  A leftover cursor can result in
 "database locked" errors, which I saw on the inaugural run of the
 metabuildbot on the scheduler/sqlalchemy commits.

 {{{
 2011-02-23 07:35:37+0100 [-] while rebuilding a build
         Traceback (most recent call last):
           File "/usr/lib/python2.6/threading.py", line 504, in __bootstrap
             self.__bootstrap_inner()
           File "/usr/lib/python2.6/threading.py", line 532, in
 __bootstrap_inner
             self.run()
           File "/usr/lib/python2.6/threading.py", line 484, in run
             self.__target(*self.__args, **self.__kwargs)
         --- <exception caught here> ---
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/twisted/python/threadpool.py", line 207, in _worker
             result = context.call(ctx, function, *args, **kwargs)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/twisted/python/context.py", line 59, in callWithContext
             return self.currentContext().callWithContext(ctx, func, *args,
 **kw)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/twisted/python/context.py", line 37, in callWithContext
             return func(*args,**kw)
           File
 "/home/buildbot/metabuildbot/src/master/buildbot/db/pool.py", line 91, in
 thd
             rv = callable(conn, *args, **kwargs)
           File
 "/home/buildbot/metabuildbot/src/master/buildbot/db/sourcestamps.py", line
 53, in thd
             project=project))
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1191, in execute
             params)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
             return self.__execute_context(context)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1315, in __execute_context
             self._commit_impl()
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1100, in _commit_impl
             self._handle_dbapi_exception(e, None, None, None, None)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1097, in _commit_impl
             self.engine.dialect.do_commit(self.connection)
           File "/home/buildbot/sandbox/lib/python2.6/site-
 packages/sqlalchemy/engine/default.py", line 275, in do_commit
             connection.commit()
         sqlalchemy.exc.OperationalError: (OperationalError) database is
 locked None None
 }}}

-- 
Ticket URL: <http://trac.buildbot.net/ticket/1833>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation