Opened 3 years ago

Closed 3 years ago

#3472 closed defect (fixed)

when restarting: too many SQL variables

Reported by: aelsabbahy Owned by: tardyp
Priority: major Milestone: undecided
Version: 0.9.0b7 Keywords:
Cc:

Description (last modified by rutsky)

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

Change History (5)

comment:1 Changed 3 years ago by rutsky

  • Description modified (diff)

comment:2 Changed 3 years ago by dustin

  • Owner set to dustin
  • Status changed from new to assigned

comment:4 Changed 3 years ago by dustin

  • Owner changed from dustin to tardyp

comment:5 Changed 3 years ago by tardyp

  • Resolution set to fixed
  • Status changed from assigned to closed
Note: See TracTickets for help on using tickets.