blob: b7d2899752f867ac8684b317599a96fe31a7d052 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
#!/bin/bash
# Copyright 2014 Holger Levsen <holger@layer-acht.org>
# released under the GPLv=2
DEBUG=false
. /srv/jenkins/bin/common-functions.sh
common_init "$@"
# common code defining db access
. /srv/jenkins/bin/reproducible_common.sh
DIRTY=false
# prepare backup
REP_RESULTS=/srv/reproducible-results
mkdir -p $REP_RESULTS/backup
cd $REP_RESULTS/backup
# keep 30 days and the 1st of the month
DAY=(date -d "30 day ago" '+%d')
DATE=$(date -d "30 day ago" '+%Y-%m-%d')
if [ "$DAY" != "01" ] && [ -f reproducible_$DATE.db.xz ] ; then
rm -f reproducible_$DATE.db.xz
fi
# actually do the backup
DATE=$(date '+%Y-%m-%d')
if [ ! -f reproducible_$DATE.db.xz ] ; then
cp -v $PACKAGES_DB .
DATE=$(date '+%Y-%m-%d')
mv -v reproducible.db reproducible_$DATE.db
xz reproducible_$DATE.db
fi
# provide copy for external backups
cp -v $PACKAGES_DB /var/lib/jenkins/userContent/
# find and warn about old temp directories
OLDSTUFF=$(find $REP_RESULTS -type d -name "tmp.*" -mtime +2 -exec ls -lad {} \;)
if [ ! -z "$OLDSTUFF" ] ; then
echo
echo "Warning: old temp directories found in $REP_RESULTS"
echo "$OLDSTUFF"
echo "Please cleanup manually."
echo
DIRTY=true
fi
# find and warn about pbuild leftovers
OLDSTUFF=$(find /var/cache/pbuilder/result/ -mtime +0 -exec ls -lad {} \;)
if [ ! -z "$OLDSTUFF" ] ; then
echo
echo "Warning: old files or directories found in /var/cache/pbuilder/result/"
echo "$OLDSTUFF"
echo "Please cleanup manually."
echo
DIRTY=true
fi
# find processes which should not be there
HAYSTACK=$(mktemp)
RESULT=$(mktemp)
PBUIDS="1234 1111 2222"
ps axo pid,user,size,pcpu,cmd > $HAYSTACK
for i in $PBUIDS ; do
for ZOMBIE in $(pgrep -u $i -P 1 || true) ; do
# faked-sysv comes and goes...
grep ^$ZOMBIE $HAYSTACK | grep -v faked-sysv >> $RESULT 2> /dev/null || true
done
done
if [ -s $RESULT ] ; then
echo
echo "Warning: processes found which should not be there:"
cat $RESULT
echo
echo "Please cleanup manually."
echo
DIRTY=true
fi
rm $HAYSTACK $RESULT
# find packages which build didnt end correctly
QUERY="
SELECT * FROM sources_scheduled
WHERE date_scheduled != ''
AND date_build_started != ''
AND date_build_started < datetime('now', '-1 day')
ORDER BY date_scheduled
"
PACKAGES=$(mktemp)
sqlite3 -init $INIT ${PACKAGES_DB} "$QUERY" > $PACKAGES 2> /dev/null || echo "Warning: SQL query '$QUERY' failed."
if grep -q '|' $PACKAGES ; then
echo
echo "Warning: packages found where the build was started more than 24h ago:"
echo "name|date_scheduled|date_build_started"
echo
cat $PACKAGES
echo
echo "To fix:"
echo
for PKG in $(cat $PACKAGES | cut -d "|" -f1) ; do
echo "sqlite3 ${PACKAGES_DB} \"DELETE FROM sources_scheduled WHERE name = '$PKG';\""
done
echo
DIRTY=true
fi
rm $PACKAGES
# find packages which have been removed from sid
QUERY="SELECT source_packages.name FROM source_packages
WHERE source_packages.name NOT IN
(SELECT sources.name FROM sources)
LIMIT 25"
PACKAGES=$(sqlite3 -init $INIT ${PACKAGES_DB} "$QUERY")
if [ ! -z "$PACKAGES" ] ; then
echo
echo "Removing these removed packages from database:"
echo $PACKAGES
echo
QUERY="DELETE FROM source_packages
WHERE source_packages.name NOT IN
(SELECT sources.name FROM sources)
LIMIT 25"
sqlite3 -init $INIT ${PACKAGES_DB} "$QUERY"
fi
if ! $DIRTY ; then
echo "Everything seems to be fine."
echo
fi
|