Re: Buildfarm feature request: some way to track/classify failures

Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>> Well, the db is currently running around 13Gb, so that's not something
>> to be exported lightly ;-)
>>
>
> Yeah. I would assume though that the vast bulk of that is captured log
> files. For the purposes I'm imagining, it'd be sufficient to export
> only the rest of the database --- or ideally, records including all the
> other fields and a URL for each log file. For the small number of log
> files you actually need to examine, you'd chase the URL.
>
>

OK, for anyone that wants to play, I have created an extract that
contains a summary of every non-CVS-related failure we've had. It's a
single table looking like this:

CREATE TABLE mfailures (
sysname text,
snapshot timestamp without time zone,
stage text,
conf_sum text,
branch text,
changed_this_run text,
changed_since_success text,
log_archive_filenames text[],
build_flags text[]
);

The dump is just under 1Mb and can be downloaded from
http://www.pgbuildfarm.org/mfailures.dump

If this is useful we can create it or something like it on a regular
basis (say nightly).

The summary log for a given build can be got from:
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=<sysname>&dt=<snapshot>

To look at the log for a given run stage select
http://www.pgbuildfarm.org/cgi-bin/show_stage_log.pl?nm=<sysname>&dt=<snapshot>&stg=<stagename>
- the stage names available (if any) are the entries in
log_archive_filenames, stripped of the ".log" suffix.

We can make these available over an API that isn't plain http is people
want. Or we can provide a version of the buildlog that is tripped of the
html.

cheers

andrew