[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible: maintenance: reschedule stale builds, instead of dropping them

[Mattia Rizzolo]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
99cdf49a by Mattia Rizzolo at 2018-06-19T08:34:11+02:00
reproducible: maintenance: reschedule stale builds, instead of dropping them

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


1 changed file:

- bin/reproducible_maintenance.sh


Changes:

=====================================
bin/reproducible_maintenance.sh
=====================================
--- a/bin/reproducible_maintenance.sh
+++ b/bin/reproducible_maintenance.sh
@@ -346,10 +346,10 @@ if [ "$HOSTNAME" = "$MAINNODE" ] ; then
 		query_to_print "$QUERY" 2> /dev/null || echo "Warning: SQL query '$QUERY' failed."
 		echo
 		for PKG in $(cat $PACKAGES | cut -d "|" -f1) ; do
-			echo "query_db \"DELETE FROM schedule WHERE package_id = '$PKG';\""
-			query_db "DELETE FROM schedule WHERE package_id = '$PKG';"
+			echo "query_db \"UPDATE schedule SET date_build_started = NULL, job = NULL WHERE package_id = '$PKG';\""
+			query_db "UPDATE schedule SET date_build_started = NULL, job = NULL WHERE package_id = '$PKG';"
 		done
-		echo "Packages have been removed from scheduling."
+		echo "Packages have been rescheduled."
 		echo
 		DIRTY=true
 	fi



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/99cdf49a6450d5c274959d9bdaa3851809b1e2b1

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/99cdf49a6450d5c274959d9bdaa3851809b1e2b1
You're receiving this email because of your account on salsa.debian.org.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20180619/28d64806/attachment-0001.html>