launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

On Mon, Sep 27, 2010 at 1:51 AM, Jeroen Vermeulen <jtv@xxxxxxxxxxxxx> wrote:
> Dear LOSAs,
>
> We had some disquieting oopses for the build farm:
>
>   6 InconsistentBuildFarmJobError: There is no related specific job for the
> build farm job with id 1977174.
>    GET: 6 Robots: 0  Local: 2
>       6 https://edge.launchpad.net/builders/doubah/+history
> (Builder:+history)
>        OOPS-1728EB866, OOPS-1728EB872, OOPS-1728EC905, OOPS-1728EC906,
> OOPS-1728EC907
>
>
> Could you tell us what you see when you ask the production database the
> following?
>
> SELECT * FROM BuildFarmJob WHERE id=1977174;
>
> (The most interesting bit will be the job_type; that's the part that will
> tell us just what kind of specific job it is that's missing).

launchpad_prod_3=# SELECT * FROM BuildFarmJob WHERE id=1977174;
-[ RECORD 1 ]---------+---------------------------
id                    | 1977174
processor             |
virtualized           | t
date_created          | 2010-09-24 14:05:12.650764
date_started          | 2010-09-24 14:05:15.563697
date_finished         | 2010-09-24 14:10:15.813844
date_first_dispatched | 2010-09-24 14:05:15.563697
builder               | 66
status                | 1
log                   | 56392141
job_type              | 3
failure_count         | 0



-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/