[Buildbot-commits] [SPAM] [Buildbot] #912: Nightly scheduler fails to trigger if too many pending changes

[Buildbot]

#912: Nightly scheduler fails to trigger if too many pending changes
---------------------------+------------------------------------------------
Reporter:  GillesGagniard  |       Owner:           
    Type:  defect          |      Status:  new      
Priority:  major           |   Milestone:  undecided
 Version:  0.8.0           |    Keywords:           
---------------------------+------------------------------------------------
 buildbot issues the following sqlite query to remove pending changes when
 triggering a Nightly scheduler in buildbot/db/connector.py :

 {{{
 def scheduler_retire_changes(self, schedulerid, changeids, t):
   t.execute(self.quoteq("DELETE FROM scheduler_changes"
                         " WHERE schedulerid=? AND changeid IN ")
   + self.parmlist(len(changeids)),
   (schedulerid,) + tuple(changeids))
 }}}

 However, sqlite only allows for 999 variables in a sql query, so this
 fails if there are more than 999 pending changes.

-- 
Ticket URL: <http://buildbot.net/trac/ticket/912>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation