Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.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,
branchtext, 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