[Buildbot-commits] [Buildbot] #2299: while pruning changes: too many SQL variables

[Buildbot]

#2299: while pruning changes: too many SQL variables
--------------------------+------------------------
Reporter:  admin@…        |       Owner:
    Type:  defect         |      Status:  new
Priority:  major          |   Milestone:  undecided
 Version:  0.8.5          |  Resolution:
Keywords:                 |
--------------------------+------------------------

Comment (by dustin):

 {{{


 2012-05-15 13:51:59+0200 [-] while pruning changes
    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 "/usr/lib/python2.6/dist-packages/twisted/python/threadpool.py",
 line 207, in _worker
        result = context.call(ctx, function, *args, **kwargs)
      File "/usr/lib/python2.6/dist-packages/twisted/python/context.py",
 line
 59, in callWithContext
        return self.currentContext().callWithContext(ctx, func, *args,
 **kw)
      File "/usr/lib/python2.6/dist-packages/twisted/python/context.py",
 line
 37, in callWithContext
        return func(*args,**kw)
      File "/usr/local/lib/python2.6/dist-packages/buildbot/db/pool.py",
 line
 128, in thd
        rv = callable(conn, *args, **kwargs)
      File "/usr/local/lib/python2.6/dist-packages/buildbot/db/changes.py",
 line 187, in thd
        table.delete(table.c.changeid.in_(ids_to_delete)))
      File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py",
 line
 1399, in execute
        params)
      File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py",
 line
 1532, in _execute_clauseelement
        compiled_sql, distilled_params
      File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py",
 line
 1640, in _execute_context
        context)
      File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py",
 line
 1633, in _execute_context
        context)
      File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py",
 line 325, in do_execute
        cursor.execute(statement, parameters)
    sqlalchemy.exc.OperationalError: (OperationalError) too many SQL
 variables
 u'DELETE FROM scheduler_changes WHERE scheduler_changes.changeid IN (?, ?,
 ?, ......tons of ?? and IDs .... 9363, 9362, 9361)
 2012-05-15 13:51:59+0200 [-] adding 1 new changesources, removing 0
 }}}

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