Comment 3 for bug 1077351

Three SourcePackageRecipeBuild builds claim to be building, but they are not.
They do not have a builder, and we can see that they finished. The absense
of a SourcePackageRelease indicates all three builds failed. The times
of the failure relate to networking/firewall issues.

The log id can be used to hack the log url:
1 is Failed by deps https://launchpadlibrarian.net/117342577/buildlog.txt.gz
2 is Failed by bzr https://launchpadlibrarian.net/115866517/buildlog.txt.gz
3 is Failed by bzr https://launchpadlibrarian.net/122195218/buildlog.txt.gz

-- source package recipe builds that are currently building, but are
-- not in the build queue...shouldn't this be impossible.
SELECT
    sprb.id AS sprb, sprb.package_build, pb.archive,
    bfj.date_started, bfj.date_finished, bfj.status, bfj.log,
    spr.version, spr.upload_archive
FROM
    SourcePackageRecipeBuild sprb
    JOIN PackageBuild pb ON sprb.package_build = pb.id
    JOIN buildfarmjob bfj ON pb.build_farm_job = bfj.id
    LEFT JOIN SourcePackageRecipeBuildJob sprbj
        ON sprbj.sourcepackage_recipe_build = sprb.id
    LEFT JOIN BuildQueue bq ON sprbj.job = bq.job
    LEFT JOIN SourcePackageRelease spr
        ON spr.sourcepackage_recipe_build = sprb.id
WHERE
    bfj.status = 6
    AND bq.id IS NULL
;

  sprb | package_build | archive | date_started | date_finished | status | log | version | upload_archive
--------+---------------+---------+----------------------------+----------------------------+--------+-----------+---------+----------------
 313796 | 4168429 | 24522 | 2012-09-26 01:18:46.619776 | 2012-09-26 01:22:49.685661 | 6 | 117342577 | |
 306575 | 4092077 | 28986 | 2012-09-14 01:39:14.201798 | 2012-09-14 01:42:31.287629 | 6 | 115866517 | |
 339948 | 4299322 | 25596 | 2012-11-06 19:20:51.690196 | 2012-11-06 19:23:38.150159 | 6 | 122195218 | |
(3 rows)