RootObject:+daily-builds times out

[JC Hulce]

OOPS-419a176afcaa39d4a3f707707bd2e023

searching daily builds

1. 5385.0 1 SQL-main-slave
SELECT SourcePackageRecipe.id,
                           SourcePackageName.id,
                                             SourcePackageName.name,
                                                               MAX(BuildFarmJob.date_finished)
FROM SourcePackageRecipe
JOIN SourcePackageRecipeBuild ON SourcePackageRecipeBuild.recipe = SourcePackageRecipe.id
JOIN SourcePackageRelease ON SourcePackageRecipeBuild.id = SourcePackageRelease.sourcepackage_recipe_build
JOIN SourcePackageName ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN BinaryPackageBuild ON BinaryPackageBuild.source_package_release = SourcePackageRelease.id
JOIN PackageBuild ON PackageBuild.id = BinaryPackageBuild.package_build
JOIN BuildFarmJob ON BuildFarmJob.id = PackageBuild.build_farm_job
WHERE BuildFarmJob.status = $INT
  AND SourcePackageRecipe.build_daily
GROUP BY SourcePackageRecipe.id,
                             SourcePackageName.id,
                                               SourcePackageName.name
ORDER BY SourcePackageName.name,
                           MAX(BuildFarmJob.date_finished) DESC LIMIT $INT
OFFSET $INT
2. 3541.0 1 SQL-main-slave
SELECT count(distinct(SourcePackageRecipe.id, SourcePackageName.id, SourcePackageName.name))
FROM SourcePackageRecipe
JOIN SourcePackageRecipeBuild ON SourcePackageRecipeBuild.recipe = SourcePackageRecipe.id
JOIN SourcePackageRelease ON SourcePackageRecipeBuild.id = SourcePackageRelease.sourcepackage_recipe_build
JOIN SourcePackageName ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN BinaryPackageBuild ON BinaryPackageBuild.source_package_release = SourcePackageRelease.id
JOIN PackageBuild ON PackageBuild.id = BinaryPackageBuild.package_build
JOIN BuildFarmJob ON BuildFarmJob.id = PackageBuild.build_farm_job
WHERE BuildFarmJob.status = $INT
  AND SourcePackageRecipe.build_daily

[Launchpad QA Bot (lpqabot)]

Fixed in stable r15943 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15943>.