2 # Author : Ludovic Strappazon. l.strappazon@gmail.com
3 # Copyright 2004, Free Software Foundation Europe e.V.
4 # Any comment, advice or enhancement are welcome :-)
6 PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
7 MYSQL="/usr/bin/mysql -u bacula --password=mypassword"
9 BACULA=/usr/local/bacula
11 PROGNAME=`basename $0`
12 PROGPATH=`echo $0 | sed -e 's,[\\/][^\\/][^\\/]*$,,'`
18 echo "Usage: $PROGNAME -P <pool> -M <media-type> -w <warning threshold> -c <critical threshold> [-S]"
25 echo "This plugin checks the space available in the pool against the space required for the next scheduled backups"
26 echo "Example : $PROGNAME -P default -M LTO -w 20 -c 10 will check the default pool, return OK if (available space) > 1,20*(required space), WARNING if 1,20*(required space) > (available space) > 1,10*(required space), and CRITICAL else."
28 echo "With the -S option, it will check the pool named Scratch and return WARNING instead of CRITICAL if the Scratch pool can save the situation."
29 echo "Example : $PROGNAME -P default -M LTO -w 20 -c 10 -S will check the default pool, return OK if (available space) > 1,20*(required space), WARNING if 1,20*(required space) > (available space) > 1,10*(required space) or if (available space in default and Scratch) > 1,10*(required space) > (available space in default), and CRITICAL else."
31 echo "The evaluation of the space required is done by adding the biggest backups of the same level than the scheduled jobs"
32 echo "The available space is evaluated by the number of out of retention tapes and the average VolBytes of these Full tapes"
34 echo "The Information Status are : \"Required, Available, Volume Errors\" and \"Will use Scratch pool\" if necessary."
36 echo "I think this plugin should be used in passive mode, and ran by a RunAfterJob"
42 while getopts :P:M:w:c:hS OPTION
47 M) MEDIA_TYPE="$OPTARG"
63 shift $(($OPTIND - 1))
65 if [ "$NB_ARGS" -ne 8 -a "$NB_ARGS" -ne 9 ]; then
66 print_revision $PROGNAME 25/05/2005
71 LAST_CHECK=`ps -ef | grep check_ba[Cc]ula_pools.sh | awk {'print $5'} | uniq | wc -l`
72 if [ "$LAST_CHECK" -gt 1 ]; then
73 echo "The last check was not complete, you should increase the check_period."
77 NB_VOLUMES_OUT_OF_RETENTION=`$MYSQL << EOF
79 SELECT COUNT(MediaId) from Media, Pool where Media.PoolId=Pool.PoolId and Pool.Name="$POOL" AND LastWritten <> "0000-00-00 00:00:00" AND UNIX_TIMESTAMP()-UNIX_TIMESTAMP(LastWritten)>Media.VolRetention AND Inchanger = "1";
82 NB_VOLUMES_OUT_OF_RETENTION=`echo $NB_VOLUMES_OUT_OF_RETENTION | cut -f 2 -d ' '`
84 NB_VOLUMES_ERROR=`$MYSQL << EOF
86 SELECT COUNT(MediaId) from Media, Pool where Media.PoolId=Pool.PoolId and Pool.Name="$POOL" AND VolStatus="Error" AND Inchanger = "1";
89 NB_VOLUMES_ERROR=`echo $NB_VOLUMES_ERROR | cut -f 2 -d ' '`
91 AVERAGE_CAPA_VOLUME=`$MYSQL << EOF
93 SELECT SUM(VolBytes)/COUNT(MediaId) FROM Media where VolStatus="Full" AND MediaType="$MEDIA_TYPE";
96 AVERAGE_CAPA_VOLUME=`echo $AVERAGE_CAPA_VOLUME | cut -f 2 -d ' ' | cut -f 1 -d '.'`
98 CAPA_VOLUMES_APPEND=`$MYSQL << EOF
100 SELECT SUM("$AVERAGE_CAPA_VOLUME"-VolBytes) from Media, Pool where Media.PoolId=Pool.PoolId and Pool.Name="$POOL" AND (VolStatus = "Append" OR VolStatus = "Recycle" OR VolStatus = "Purge") AND Inchanger = "1" AND MediaType="$MEDIA_TYPE";
103 CAPA_VOLUMES_APPEND=`echo $CAPA_VOLUMES_APPEND | cut -f 2 -d ' '`
105 if [ $SCRATCH -eq 1 ]
107 CAPA_VOLUMES_SCRATCH=`$MYSQL << EOF
109 SELECT SUM("$AVERAGE_CAPA_VOLUME"-VolBytes) from Media, Pool where Media.PoolId=Pool.PoolId and Pool.Name="Scratch" AND VolStatus = "Append" AND Inchanger = "1" AND MediaType="$MEDIA_TYPE";
112 CAPA_VOLUMES_SCRATCH=`echo $CAPA_VOLUMES_SCRATCH | cut -f 2 -d ' '`
114 CAPA_VOLUMES_SCRATCH=0
119 q" | $BACULA/etc/bconsole | sed -n /Scheduled/,/Running/p | grep Backup | tr -s [:blank:] | tr '[:blank:]' '@' > ${TMP}/Scheduled.txt
122 for LINE in `cat ${TMP}/Scheduled.txt`
124 SCHEDULED_JOB=`echo $LINE | awk -F@ '{print $6}'`
125 LEVEL=`echo $LINE | awk -F@ '{print $1}' | cut -c 1`
127 MAX_VOLUME_JOB_FOR_LEVEL=`$MYSQL << EOF
129 SELECT MAX(JobBytes) from Job, Pool where Level="$LEVEL" AND Job.Name="$SCHEDULED_JOB" AND Job.PoolId=Pool.PoolId AND Pool.Name="$POOL";
132 MAX_VOLUME_JOB_FOR_LEVEL=`echo $MAX_VOLUME_JOB_FOR_LEVEL | cut -f 2 -d ' ' `
134 CAPA_REQUIRED=$[CAPA_REQUIRED+MAX_VOLUME_JOB_FOR_LEVEL]
137 rm ${TMP}/Scheduled.txt
139 CAPA_WARNING=`echo $[(WARNING+100)*CAPA_REQUIRED]/100 | bc | cut -f 1 -d '.'`
140 CAPA_CRITICAL=`echo $[(CRITICAL+100)*CAPA_REQUIRED]/100 | bc | cut -f 1 -d '.'`
141 CAPA_DISP=$[NB_VOLUMES_OUT_OF_RETENTION*AVERAGE_CAPA_VOLUME+CAPA_VOLUMES_APPEND]
142 CAPA_DISP_INCLUDING_SCRATCH=$[CAPA_DISP+CAPA_VOLUMES_SCRATCH]
144 MESSAGE="Required : $[CAPA_REQUIRED/1000000000] Go, available : $[CAPA_DISP/1000000000] Go, Volumes Error : $NB_VOLUMES_ERROR"
146 if [ "$CAPA_DISP" -gt $CAPA_WARNING ]; then
149 elif [ "$CAPA_DISP" -gt $CAPA_CRITICAL ];then
152 elif [ "$CAPA_DISP_INCLUDING_SCRATCH" -gt $CAPA_CRITICAL ];then
153 MESSAGE="${MESSAGE}. Will use Scratch Pool !"