summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_scheduler.py
AgeCommit message (Collapse)AuthorFilesLines
2017-05-02reproducible Debian: schedule sooner on all archsHolger Levsen1-12/+12
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-02reproducible Debian: use human-readable time formatHolger Levsen1-3/+3
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-02reproducible Debian: whitespace fixHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-02reproducible Debian: schedule i386+armhf soonerHolger Levsen1-6/+6
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-01reproducible Debian: schedule even more packages for amd64 and arm64Holger Levsen1-4/+4
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-01reproducible Debian: lower maximum amounts of new packages being scheduled ↵Holger Levsen1-12/+12
(hoping this speeds up things a bit) Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-01reproducible Debian: schedule more packages for amd64 and arm64Holger Levsen1-8/+8
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-01reproducible Debian: increase scheduling frequency for amd64, i386 and arm64Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-05-01reproducible Debian: increase scheduling frequency for amd64Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-04-30reproducible Debian: increase amd64 schedulingHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-04-29reproducible Debian: increase i386 schedulingHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-04-26reproducible Debian: schedule i386+amd64 a bit earlierHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-03-16reproducible Debian: adjust scheduling frequencyHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-03-05reproducible Debian: adjust scheduling frequency, mostly to adopt to faster ↵Holger Levsen1-1/+1
armhf nodes Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-02-21reproducible Debian: schedule new, untested and depwait more aggressivelyHolger Levsen1-3/+3
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-02-20reproducible Debian: decrease scheduing frequency for experimentalHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-23reproducible Debian: adjust arm64 scheduler to be more like the one for amd64Holger Levsen1-8/+8
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-17reproducible Debian: schedule amd64 soonerHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-14reproducible Debian: save 8 characters * 4 per mail.Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-14reproducible Debian: whitespace improvement in mailsHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-14reproducible Debian: schedule a bit more aggressivlyHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-11update copyrightHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-09reproducible Debian: adjust scheduling frequency for arm64Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-08reproducible Debian: schedule i386+armhf a bit earlier…Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-04reproducible Debian: reschedule old arm64 packages earlierHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-26reproducible Debian: resume testing scheduling now that #846564 and #844701 ↵Holger Levsen1-3/+3
are fixed in testing too Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-26reproducible Debian: adjust arm64 scheduling frequencyHolger Levsen1-4/+4
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-23fixup d3cfdf5d: reproducible Debian: enable arm64 schedulerHolger Levsen1-3/+3
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-23reproducible Debian: enable arm64 schedulerHolger Levsen1-2/+27
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-20reproducible Debian: basically stop scheduling old packages on ↵Holger Levsen1-2/+2
testing/armhf+i386 due to #846564 still affecting stretch Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-19reproducible debian: scheduler: run random() in a subquery and distinct in a ↵Mattia Rizzolo1-7/+9
parent query for postgres compatibility https://stackoverflow.com/questions/11401229/how-to-use-select-distinct-with-random-function-in-postgresql Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-18reproducible Debian: adjust experimental/amd64 scheduling frequency to old ↵Holger Levsen1-1/+1
results in unstable/amd64 Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-01reproducible Debian: raise mininum age for rescheduling on i386+armhf to 30Holger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-29reproducible Debian: schedule experimental less often on i386+armhfHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-21reproducible Debian: adjust experimental scheduling frequency to old results ↵Holger Levsen1-1/+1
in unstable Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-21reproducible Debian: add linebreaks to make the scheduling mails more readableHolger Levsen1-2/+2
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-21reproducible Debian: schedule testing as often as unstable on all archs, now ↵Holger Levsen1-4/+4
that the freeze gets closer Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-15reproducible Debian: reschedule less older packages on all archsHolger Levsen1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-11reproducible Debian: on amd64 schedule already tested packages from unstable ↵Holger Levsen1-2/+2
and testing equally Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-25reproducible debian: speed up _scheduler.py significantlyValerie R Young1-1/+1
This fix has to important parts: (1) changing a list to set for fast looks ups, and (2) changing a slqalchemy RowProxy object to a tuple for fast comparisons. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-25reproducible debian: handle new packages with multiple versionsValerie R Young1-2/+13
This commit fixes a bug introduced by 07849060 Commit 07849060 changed the UPSERT that added new packages to the sources table into an INSERT. If the new package has two versions for (suite, arch) in debian archive, then the INSERT to sources will fail on unique constraint. The changes in this commit provide the same functionality without the UPSERT: there will be no failure, instead only the second source encountered in archive will be saved. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-25reproducible debian: make more sql sqlite3/postgres agnosticValerie R Young1-13/+22
This commit fixes to things in reproducible_scheduler.py: 1. Do not delete entries in sources table until all foreign references to that source.id are deleted. 2. Cannot "SELECT DISTINCT" and then "ORDER BY" a column that is not in the select. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-17reproducible debian: fix bug in _scheduler queriesValerie R Young1-4/+4
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-17reproducible debian: make python sql more sqlite/postgres agnosticValerie R Young1-25/+34
This commit fixes all the python script sql queries that required minimal editing to be syntactically correct for both sqlite and postgres. Almost all fixes consist of the removal of double quotes from query strings. NOTE: the following scripts expect the schedule table's primary key to autoincrement. Running reproducible_db_maintence.py on a postgres database will not add the necessary autoincrementing functionality at this time. The following script WILL run on the sqlite database but will fail on postgres database constructed from reproducible_db_maintence.py until this is fixed: reproducible_remote_scheduler.py reproducible_schedule.py Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-10reproducible Debian: fixup mail sendingHolger Levsen1-3/+5
2016-10-10reproducible Debian: add another timestamp to debug bottleneckHolger Levsen1-0/+1
2016-10-10reproducible Debian: add some timestamps to debug bottleneckHolger Levsen1-0/+2
2016-10-10reproducible Debian: notify about new (regular) schedulings via mail instead ↵Holger Levsen1-1/+11
of irc
2016-10-02reproducible Debian: Move regular "Scheduled in..." messages to #-changesChris Lamb1-1/+1
2016-08-20Revert "reproducible Debian: build testing/i386 faster that the other suites ↵Holger Levsen1-3/+3
on i386" This reverts commit 6649043714cc55232b23428c82459161e82ddbe4.