#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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
