summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_scheduler.py
AgeCommit message (Collapse)AuthorFilesLines
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.
2016-08-19reproducible debian: switch python database backend to SQLAlchemyValerie R Young1-48/+68
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-12reproducible Debian: build testing/i386 faster that the other suites on i386Holger Levsen1-3/+3
2016-08-03reproducible Debian: rebuild sid faster than testingHolger Levsen1-3/+3
2016-07-20reproducible Debian: sync (re-)scheduling frequencies for the different archsHolger Levsen1-8/+8
2016-06-13reproducible debian: reschedule packages in state 'depwait' after 2 days ↵Holger Levsen1-2/+2
(before: 3)
2016-06-02reproducible debian: also reschedule depwait packages with bugs filedHolger Levsen1-3/+1
2016-03-26reproducible debian: add scheduler limits for i386Holger Levsen1-3/+28
2016-03-08reproducible debian: schedule depwait packages independently from packages ↵Holger Levsen1-21/+76
which ftbfs without bugs filed
2016-03-07reproducible debian: schedule more ftbfs+depwait packages soonerHolger Levsen1-6/+6
2016-02-19Revert "reproducible: scheduler: shuffle the package list right before ↵Holger Levsen1-1/+0
scheduling them" This reverts commit a367ceb9379fdc9082c76b4d1ff2fdfa8caed401.
2016-02-19reproducible: scheduler: shuffle the package list right before scheduling themMattia Rizzolo1-0/+1
2016-02-19reproducible: scheduler: remove useless importsMattia Rizzolo1-2/+0
2016-02-15reproducible debian: schedule new versions in armhf a bit slower…Holger Levsen1-4/+4
2016-02-14reproducible debian: improve comment to better describe what the code does + whyHolger Levsen1-1/+4
2016-02-14reproducible debian: always schedule new versions and some ftbfs and depwaitHolger Levsen1-8/+8
2016-02-13reproducible debian: reschedule more old armhf packages at onceHolger Levsen1-2/+2
2016-02-13Revert "reproducible armhf: let's slow down rebuilding sid until stretch is ↵Holger Levsen1-2/+2
done" This reverts commit 3ff2a8f94ba438353e8ff347949ab0d7bc0db162.
2016-02-13Revert "reproducible debian armhf: only schedule old packages older than 42 ↵Holger Levsen1-1/+1
days" This reverts commit 71593042610214c62e00c787e1b3af8a2a7c914d.
2016-02-08reproducible armhf: let's slow down rebuilding sid until stretch is doneHolger Levsen1-2/+2
2016-01-29reproducible debian armhf: only schedule old packages older than 42 daysHolger Levsen1-1/+1
2016-01-25reproducible armhf: re-schedule sid a bit slowerHolger Levsen1-2/+2
2016-01-20reproducible: schedule new versions when < MAXIMA*3 packages are scheduledHolger Levsen1-2/+2
2016-01-18reproducible: schedule 255 packages with status 404 (and refactor)Holger Levsen1-7/+10
2016-01-18reproducible: merge the two irc notifications for amd64+armhf into oneHolger Levsen1-9/+13
2016-01-16reproducible armhf: schedule testing more oftenHolger Levsen1-3/+3
2016-01-16Revert "reproducible: completly stop scheduling testing for now (fix colon)"Holger Levsen1-10/+6
This reverts commit 602d3380dd8648c6cbaa081b7cfe06645ae4f3a0.
2016-01-15reproducible armhf: schedule more old packagesHolger Levsen1-3/+3
2016-01-14reproducible armhf: schedule more old packages at onceHolger Levsen1-3/+3
2016-01-14reproducible: completly stop scheduling testing for now (fix colon)Holger Levsen1-6/+10