[Git][qa/jenkins.debian.net][master] 2 commits: r.d.n: experimental script to backup the various rebuilderd db's

[Holger Levsen (@holger)]

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


Commits:
c673acf3 by Holger Levsen at 2025-01-28T21:09:38+01:00
r.d.n: experimental script to backup the various rebuilderd db's

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

- - - - -
5e4605e9 by Holger Levsen at 2025-01-28T21:14:10+01:00
$arch.r.d.n: add links to db backups

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

- - - - -


6 changed files:

- bin/rebuilderd_db_backup.sh
- hosts/osuosl5-amd64/var/www/html/index_amd64.html
- hosts/osuosl5-amd64/var/www/html/index_arm64.html
- hosts/osuosl5-amd64/var/www/html/index_armhf.html
- hosts/osuosl5-amd64/var/www/html/index_i386.html
- hosts/osuosl5-amd64/var/www/html/index_riscv64.html


Changes:

=====================================
bin/rebuilderd_db_backup.sh
=====================================
@@ -1,9 +1,31 @@
+#!/bin/bash
+#
+# Copyright 2024-2025 Holger Levsen (holger at layer-acht.org)
+# released under the GPLv2
+
+set -e
+
+#
 # WIP. currently to be run manually as the db user...
+# should maybe be called by a systemd timer on boot before rebuilderd
+# is started.
+# currently its ment to be run manually.
+# rbuilderd should not be running when this is run to ensure db consistancy.
+#
+if [ -z "$1" ] ; then
+	echo "need an architecture."
+	exit 1
+fi
 
+ARCH=$1
+BASE_PATH=/srv/rebuilderd/$ARCH
 TODAY=$(date '+%Y-%m-%d' -u)
-cd 
+BACKUP_DIR=$BASE_PATH/stats/db-backup
+mkdir -p $BACKUP_DIR
+cd $BACKUP_DIR
+
 mkdir db-back-${TODAY}
-cp -av rebuilderd.db* db-back-${TODAY}/ 
+cp -av $BASE_PATH/rebuilderd.db* db-back-${TODAY}/ 
 echo 
 echo "it's safe to restart rebuilderd again."
 echo
@@ -11,8 +33,5 @@ cd db-back-${TODAY}
 for i in rebuilderd.db* ; do 
 	xz --verbose $i
 done
-cd
-du -sch db-back-${TODAY}/
+du -sch $BACKUP_DIR/* $BASE_PATH/rebuilderd.db*
 
-mkdir /srv/rebuilderd/stats/db-backup
-mv db-back-${TODAY} /srv/rebuilderd/stats/db-backup/


=====================================
hosts/osuosl5-amd64/var/www/html/index_amd64.html
=====================================
@@ -204,6 +204,7 @@
 	    <a href="/stats/">Statistics about BAD packages</a> on amd64.
 	    <br/>
 	    <a href="/api/v0/pkgs/list">/api/v0/pkgs/list</a> (JSON)
+	    / <a href="/stats/db-backup/">rebuilderd database backups</a>
 	    <br/>
 	    <code>
 		# How to judge your own systen:


=====================================
hosts/osuosl5-amd64/var/www/html/index_arm64.html
=====================================
@@ -204,6 +204,7 @@
 	    <a href="/stats/">Statistics about BAD packages</a> on arm64.
 	    <br/>
 	    <a href="/api/v0/pkgs/list">/api/v0/pkgs/list</a> (JSON)
+	    / <a href="/stats/db-backup/">rebuilderd database backups</a>
 	    <br/>
 	    <code>
 		# How to judge your own systen:


=====================================
hosts/osuosl5-amd64/var/www/html/index_armhf.html
=====================================
@@ -204,6 +204,7 @@
 	    <a href="/stats/">Statistics about BAD packages</a> on armhf.
 	    <br/>
 	    <a href="/api/v0/pkgs/list">/api/v0/pkgs/list</a> (JSON)
+	    / <a href="/stats/db-backup/">rebuilderd database backups</a>
 	    <br/>
 	    <code>
 		# How to judge your own systen:


=====================================
hosts/osuosl5-amd64/var/www/html/index_i386.html
=====================================
@@ -204,6 +204,7 @@
 	    <a href="/stats/">Statistics about BAD packages</a> on i386.
 	    <br/>
 	    <a href="/api/v0/pkgs/list">/api/v0/pkgs/list</a> (JSON)
+	    / <a href="/stats/db-backup/">rebuilderd database backups</a>
 	    <br/>
 	    <code>
 		# How to judge your own systen:


=====================================
hosts/osuosl5-amd64/var/www/html/index_riscv64.html
=====================================
@@ -204,6 +204,7 @@
 	    <a href="/stats/">Statistics about BAD packages</a> on riscv64.
 	    <br/>
 	    <a href="/api/v0/pkgs/list">/api/v0/pkgs/list</a> (JSON)
+	    / <a href="/stats/db-backup/">rebuilderd database backups</a>
 	    <br/>
 	    <code>
 		# How to judge your own systen:



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/0b246f80e0dfb09e5e6aa556eba467ba0c9263f2...5e4605e9bf17c2f27bdbfcc88c69aa63e688b47d

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/0b246f80e0dfb09e5e6aa556eba467ba0c9263f2...5e4605e9bf17c2f27bdbfcc88c69aa63e688b47d
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/20250128/5541abaa/attachment-0001.htm>