#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
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
