[Buildbot] #3472: when restarting: too many SQL variables

[Buildbot trac]

#3472: when restarting: too many SQL variables
-----------------------+------------------------
Reporter:  aelsabbahy  |       Owner:
    Type:  defect      |      Status:  new
Priority:  major       |   Milestone:  undecided
 Version:  0.9.0b7     |  Resolution:
Keywords:              |
-----------------------+------------------------
Description changed by rutsky:

Old description:

> 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,...)]

New description:

 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#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation