X-Git-Url: https://git.exim.org/buildfarm-server.git/blobdiff_plain/951769e19786631c2773665ac3db90cadd1b453c..16db57b0d5eabfddda72405d5462012e35ee672e:/cgi-bin/pgstatus.pl?ds=inline diff --git a/cgi-bin/pgstatus.pl b/cgi-bin/pgstatus.pl index 5896761..f951aee 100755 --- a/cgi-bin/pgstatus.pl +++ b/cgi-bin/pgstatus.pl @@ -19,6 +19,7 @@ use DBD::Pg; use Data::Dumper; use Mail::Send; use Safe; +use Time::ParseDate; require "$ENV{BFConfDir}/BuildFarmWeb.pl"; @@ -62,6 +63,15 @@ unless ($animal && $ts && $stage && $sig) } +unless ($branch =~ /^(HEAD|REL\d+_\d+_STABLE)$/) +{ + print + "Status: 492 bad branch parameter $branch\nContent-Type: text/plain\n\n", + "bad branch parameter $branch\n"; + exit; + +} + my $db = DBI->connect($dsn,$dbuser,$dbpass); @@ -141,6 +151,19 @@ if ($calc_sig ne $sig && $calc_sig2 ne $sig) map {tr/$@/+=/; $_ = decode_base64($_); } ($log, $conf,$changed_this_run,$changed_since_success,$log_archive); + +if ($log =~/Last file mtime in snapshot: (.*)/) +{ + my $snaptime = parsedate($1); + if ($snaptime < (time - (10 * 86400))) + { + print "Status: 493 snapshot too old: $1\nContent-Type: text/plain\n\n"; + print "snapshot to old: $1\n"; + $db->disconnect; + exit; + } +} + ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = gmtime($ts); $year += 1900; $mon +=1; my $dbdate= @@ -331,10 +354,9 @@ $row=$sth->fetchrow_arrayref; my ($os, $compiler,$arch) = @$row; $sth->finish; - $db->begin_work; $db->do("delete from dashboard_mat"); -$db->do("insert into dashboard_mat select * from dashboard_mat_data2"); +$db->do("insert into dashboard_mat select * from dashboard_mat_data"); $db->commit; $db->disconnect;