List of broken package builds

build logs
connect_error) { die("Connection failed: " . $mysql->connect_error); } $result = $mysql -> query( "SELECT " . "`build_assignments`.`id`," . "`build_assignments`.`is_blocked`," . "`package_sources`.`pkgbase`," . "`package_sources`.`git_revision`," . "`package_sources`.`mod_git_revision`," . "`upstream_repositories`.`name` " . "FROM `build_assignments` " . "JOIN `package_sources` ON `build_assignments`.`package_source` = `package_sources`.`id` " . "JOIN `upstream_repositories` ON `package_sources`.`upstream_package_repository` = `upstream_repositories`.`id` " . "WHERE `build_assignments`.`is_broken` OR `build_assignments`.`is_blocked` IS NOT NULL" ); if ($result -> num_rows > 0) { print "\n"; print ""; print ""; print ""; print ""; print ""; print ""; // print ""; print ""; print ""; print "\n"; while($row = $result->fetch_assoc()) { $fail_result = $mysql -> query( "SELECT " . "`fail_reasons`.`name`, " . "`failed_builds`.`log_file` " . "FROM `failed_builds` " . "JOIN `build_assignments` ON `failed_builds`.`build_assignment`=`build_assignments`.`id` ". "JOIN `fail_reasons` ON `failed_builds`.`reason`=`fail_reasons`.`id` ". "WHERE `build_assignments`.`id`=".$row["id"]." " . "ORDER BY `failed_builds`.`date`" ); unset($reasons); unset($last_log); $trials = $fail_result -> num_rows; if ($trials > 0) { while($fail_row = $fail_result->fetch_assoc()) { $reasons[$fail_row["name"]]=$fail_row["name"]; $last_log=$fail_row["log_file"]; } } if (isset($reasons)) { $to_print=""; foreach ($reasons as $reason) { $to_print=$to_print.", ".$reason; } $fail_reasons=substr($to_print,2); } else { $fail_reasons=" "; } print ""; print ""; print ""; print ""; print ""; if (isset($last_log)) print ""; else print ""; // print ""; if ($row["is_blocked"]=="") { $row["is_blocked"]=" "; } $row["is_blocked"] = preg_replace( array ( "/FS32#(\\d+)/", "/FS#(\\d+)/" ), array ( "$0", "$0" ), $row["is_blocked"] ); print ""; print "\n"; } print "

package	git revision	modification git revision	package repository	compilations	dependent	build error	blocked
".$row["pkgbase"]."	".$row["git_revision"]."	".$row["mod_git_revision"]."	".$row["name"]."	". $trials ."	". $trials ."	0	".$fail_reasons."	".$row["is_blocked"]."

\n"; } ?>