my $logst = <<EOSQL;
insert into build_status
- (sysname, snapshot,status, stage, log,conf_sum, branch,
+ (sysname, snapshot, status, stage, log, conf_sum, branch,
changed_this_run, changed_since_success,
- log_archive_filenames , log_archive, build_flags, scm, scmurl,
- git_head_ref,frozen_conf)
+ log_archive_filenames, log_archive, build_flags, scm, scmurl,
+ git_head_ref, frozen_conf)
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
EOSQL
;
$db->do("insert into dashboard_mat select * from dashboard_mat_data");
$db->commit;
-if ($stage ne 'OK')
-{
- $db->begin_work;
- # prevent occasional duplication by forcing serialization of this operation
- $db->do("lock table nrecent_failures in share row exclusive mode");
- $db->do("delete from nrecent_failures");
- $db->do("insert into nrecent_failures select bs.sysname, bs.snapshot, bs.branch from build_status bs where bs.stage <> 'OK' and bs.snapshot > now() - interval '90 days'");
- $db->commit;
-}
+
+#if ($stage ne 'OK') # On Exim build farm nrecent_failures is a view, not table... comment out
+#{
+# $db->begin_work;
+# # prevent occasional duplication by forcing serialization of this operation
+# $db->do("lock table nrecent_failures in share row exclusive mode");
+# $db->do("delete from nrecent_failures");
+# $db->do("insert into nrecent_failures select bs.sysname, bs.snapshot, bs.branch from build_status bs where bs.stage <> 'OK' and bs.snapshot > now() - interval '90 days'");
+# $db->commit;
+#}
$db->disconnect;