[Buildbot-commits] [Buildbot] #1938: Cannot operate on a closed database

Buildbot nobody at buildbot.net
Fri Apr 29 01:01:58 UTC 2011


#1938: Cannot operate on a closed database
----------------------+--------------------
Reporter:  dabrahams  |       Owner:
    Type:  defect     |      Status:  new
Priority:  major      |   Milestone:  0.8.4
 Version:  master     |  Resolution:
Keywords:  database   |
----------------------+--------------------

Comment (by dabrahams):

 No idea.  In its latest manifestation, this is happening to me when the
 slave connects and there are pending builds:

 {{{
 2011-04-28 17:53:39-0700 [Broker,0,207.172.223.249] Got slaveinfo from
 'xp64a'
 2011-04-28 17:53:39-0700 [Broker,0,207.172.223.249] bot attached
 2011-04-28 17:53:39-0700 [Broker,0,207.172.223.249] Buildslave xp64a
 attached to elvis-win64-clang-llvm-work
 2011-04-28 17:53:40-0700 [-] in maybeStartBuild for <Builder ''elvis-win64
 -clang-llvm-work'' at 150211244>
    Traceback (most recent call last):
       Failure: twisted.internet.defer.FirstError: FirstError[#34, [Failure
 instance: Traceback: <class 'sqlalchemy.exc.ProgrammingError'>:
 (ProgrammingError) Cannot operate on a closed database. None []
     /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:307:errback
         /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:354:_startRunCallbacks
      /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:371:_runCallbacks
   /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:694:gotResult
       --- <exception caught here> ---
  /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:669:_deferGenerator
         /usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/process/buildrequest.py:95:fromBrdict
        /usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py:648:getResult
       /usr/lib/python2.6/vendor-
 packages/twisted/python/threadpool.py:210:_worker
      /usr/lib/python2.6/vendor-
 packages/twisted/python/context.py:59:callWithContext
  /usr/lib/python2.6/vendor-
 packages/twisted/python/context.py:37:callWithContext
  /usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/db/pool.py:92:thd
    /usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/db/buildsets.py:110:thd
      /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py:1191:execute
  /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py:1269:_execute_clauseelement
   /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py:1382:__create_execution_context
       /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py:1377:__create_execution_context
       /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/default.py:392:__init__
       /usr/lib/python2.6/site-
 packages/sqlalchemy/engine/default.py:534:create_cursor
  /usr/lib/python2.6/site-packages/sqlalchemy/pool.py:423:cursor
   ]]

 2011-04-28 17:53:40-0700 [-] Unhandled error in Deferred:
 2011-04-28 17:53:40-0700 [-] Unhandled Error
    Traceback (most recent call last):
         File "/usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py", line 307, in errback
          self._startRunCallbacks(fail)
          File "/usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py", line 354, in _startRunCallbacks
       self._runCallbacks()
           File "/usr/lib/python2.6/vendor-
 packages/twisted/internet/defer.py", line 371, in _runCallbacks
            self.result = callback(self.result, *args, **kw)
       File "/usr/lib/python2.6/vendor-packages/twisted/internet/defer.py",
 line 694, in gotResult
        _deferGenerator(g, deferred)
         --- <exception caught here> ---
    File "/usr/lib/python2.6/vendor-packages/twisted/internet/defer.py",
 line 669, in _deferGenerator
          result = g.next()
      File "/usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/process/buildrequest.py",
 line 95, in fromBrdict
         buildset = wfd.getResult()
     File "/usr/lib/python2.6/vendor-packages/twisted/internet/defer.py",
 line 648, in getResult
        self.result.raiseException()
           File "/usr/lib/python2.6/vendor-
 packages/twisted/python/threadpool.py", line 210, in _worker
       result = context.call(ctx, function, *args, **kwargs)
          File "/usr/lib/python2.6/vendor-
 packages/twisted/python/context.py", line 59, in callWithContext
           return self.currentContext().callWithContext(ctx, func, *args,
 **kw)
           File "/usr/lib/python2.6/vendor-
 packages/twisted/python/context.py", line 37, in callWithContext
           return func(*args,**kw)
        File "/usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/db/pool.py",
 line 92, in thd
             rv = callable(conn, *args, **kwargs)
           File "/usr/lib/python2.6/site-
 packages/buildbot-0.8.4_pre_511_g640ee58-py2.6.egg/buildbot/db/buildsets.py",
 line 110, in thd
       res = conn.execute(q)
          File "/usr/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1191, in execute
           params)
        File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
 line 1269, in _execute_clauseelement
            parameters=params
      File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
 line 1382, in __create_execution_context
        None, None)
    File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line
 1377, in __create_execution_context
        connection=self, **kwargs)
     File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
 line 392, in __init__
        self.cursor = self.create_cursor()
     File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
 line 534, in create_cursor
           return self._connection.connection.cursor()
    File "/usr/lib/python2.6/site-packages/sqlalchemy/pool.py", line 423,
 in cursor
            c = self.connection.cursor(*args, **kwargs)
  sqlalchemy.exc.ProgrammingError: (ProgrammingError) Cannot operate on a
 closed database. None []
 }}}

-- 
Ticket URL: <http://trac.buildbot.net/ticket/1938#comment:3>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation


More information about the Commits mailing list