[Buildbot] #3472: when restarting: too many SQL variables
Buildbot trac
trac at buildbot.net
Fri Feb 26 17:01:53 UTC 2016
#3472: when restarting: too many SQL variables
-----------------------+-----------------------
Reporter: aelsabbahy | Owner:
Type: defect | Status: new
Priority: major | Milestone: undecided
Version: 0.9.0b7 | Keywords:
-----------------------+-----------------------
When restarting buildbot we're seeing the following error and the db seems
to be getting in a corrupt state (pollers stop working). This seems
similar to #2299.
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/buildbot/db/buildslaves.py", line 53, in thd
conn.execute(q)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams,
params)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/buildbot/.buildbot_venv/local/lib/python2.7/site-
packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) too
many SQL variables [SQL: u'DELETE FROM configured_buildslaves WHERE
configured_buildslaves.buildermasterid IN (?, ?, ?,...)'] [parameters: (1,
1, 1,...)]
--
Ticket URL: <http://trac.buildbot.net/ticket/3472>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation
More information about the bugs
mailing list