[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Archlinux: add sql debug output

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
63237165 by Holger Levsen at 2018-09-21T20:49:25Z
reproducible Archlinux: add sql debug output

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


2 changed files:

- TODO
- bin/reproducible_archlinux_scheduler.sh


Changes:

=====================================
TODO
=====================================
@@ -337,11 +337,19 @@ See link:https://jenkins.debian.net/userContent/about.html["about jenkins.debian
 *** actually schedule old packages once queue is empty
 *** also delete unknown packages from db
 *** check/make sure that updated packages are only scheduled once
+*** dont schedule blacklisted packages
 ** make build.sh read & write db
+*** delete all pkg.needs_build files on disk
+*** drop all occurrances of pkg.needs_build from the code
+*** really share /var/log/jenkins/reproducible-stale-builds.log
+ with debian?
+*** same for /var/log/jenkins/reproducible-race-conditions.log
+**** i think we want to split those... (into debian and archlinux ones)
 ** make build respect pacman exit code
 ** create new job to recreate all pkg pages
 ** call pkg html function after each build
 ** cleanup now useless code from scheduler
+** create json
 
 * fix build.sh:
 ** build2.log doesnt get deleted if build1 fails


=====================================
bin/reproducible_archlinux_scheduler.sh
=====================================
@@ -75,6 +75,7 @@ update_archlinux_repositories() {
 				#
 				# db based scheduler
 				#
+				echo "Processing $repo $pkgbase $version"
 				PKG=$pkgbase
 				SUITE="archlinux_$repo"
 				ARCH="x86_64"
@@ -82,6 +83,7 @@ update_archlinux_repositories() {
 				DATE="$(date -u +'%Y-%m-%d %H:%M')"
 				if [ -z "$VERSION" ] ; then
 					# new package, add to db and schedule
+					echo "INSERT into sources (name, version, suite, architecture) VALUES ('$PKG', '$VERSION', '$SUITE', '$ARCH');"
 					query_db "INSERT into sources (name, version, suite, architecture) VALUES ('$PKG', '$VERSION', '$SUITE', '$ARCH');"
 					PKGID=$(query_db "SELECT id FROM sources WHERE name='$PKG' AND suite='$SUITE' AND architecture='$ARCH';")
 					#FIXME: enable next line once the db has been initially populated
@@ -92,8 +94,10 @@ update_archlinux_repositories() {
 						# known package but with new version, update db and schedule
 						echo $REPO/$pkgbase >> $UPDATED
 						echo "$(date -u ) - we know $REPO/$pkgbase $VERSION, but repo has $version, so rescheduling... "
+						echo "UPDATE sources SET version = '$version' WHERE name = '$PKG' AND suite = '$SUITE' AND architecture='$ARCH';"
 						query_db "UPDATE sources SET version = '$version' WHERE name = '$PKG' AND suite = '$SUITE' AND architecture='$ARCH';"
 						PKGID=$(query_db "SELECT id FROM sources WHERE name='$PKG' AND suite='$SUITE' AND architecture='$ARCH';")
+						echo "INSERT INTO schedule (package_id, date_scheduled) VALUES ('$PKGID', '$DATE');"
 						query_db "INSERT INTO schedule (package_id, date_scheduled) VALUES ('$PKGID', '$DATE');"
 
 					elif [ "$VERCMP" = "-1" ] ; then



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/632371650b2963c32a66f33b7c4ef5895d3e9b53

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/632371650b2963c32a66f33b7c4ef5895d3e9b53
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/20180921/d3766f37/attachment-0001.html>