# it doesn't start during our test
#
outf="tmp/sed_tmp"
-echo "s% Schedule =%# Schedule =%g" >${outf}
+echo "s% Schedule =%# Schedule =%g" > $outf
+echo "s% DIRport%Statistics Retention = 1 sec; DIRport%g" >> $outf
cp ${cwd}/bin/bacula-dir.conf ${cwd}/tmp/1
sed -f ${outf} ${cwd}/tmp/1 >${cwd}/bin/bacula-dir.conf
wait
messages
update stats days=1
-@$out ${cwd}/tmp/log2.out
sql
-SELECT * FROM JobStat;
+SELECT 'FOUND' AS test FROM JobHistory;
run job=$JobName yes
wait
messages
-@$out ${cwd}/tmp/log3.out
+@sleep 5
+@$out ${cwd}/tmp/log2.out
update stats
sql
-SELECT * FROM JobStat;
+SELECT 'FOUND' AS test FROM JobHistory;
list jobs
+prune stats yes
+@$out ${cwd}/tmp/log3.out
+sql
+SELECT 'FOUND' AS test FROM JobHistory;
+
quit
END_OF_DATA
run_bacula
-export dstat=0
-export rstat=0
-export bstat=0
+
+dstat=0
+rstat=0
+bstat=0
+
check_for_zombie_jobs storage=File
stop_bacula
-# TODO: do grep into log2 log3 to see differences
+
+COUNT=`grep FOUND ${cwd}/tmp/log1.out | wc -l`
+if [ $COUNT -ne 1 ]; then
+ print_debug "Bad count in JobHistory table"
+ bstat=1
+fi
+
+COUNT=`grep FOUND ${cwd}/tmp/log2.out | wc -l`
+if [ $COUNT -ne 3 ]; then
+ print_debug "Bad count in JobHistory table"
+ bstat=2
+fi
+
+COUNT=`grep FOUND ${cwd}/tmp/log3.out | wc -l`
+if [ $COUNT -ne 1 ]; then
+ print_debug "Bad count in JobHistory table"
+ bstat=3
+fi
end_test