SourcePackage:+index timeout
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
William Grant |
Bug Description
11 SELECT SourcePackagePu
GET: 11 Robots: 4 Local: 5
8 https:/
OOPS-1894B1679, OOPS-1894C1105, OOPS-1894F1560, OOPS-1894G622, OOPS-1894G894
3 https:/
OOPS-1894A1065, OOPS-1894D1026, OOPS-1894J798
Branch: launchpad-rev-12532
Revno: 12532
SQL time: 11923 ms
Non-sql time: 1266 ms
Total time: 13189 ms
Statement Count: 47
Primary culprit is a repeated query.
4 3 8735 2911 5824 SQL-launchpad-
SELECT SourcePackagePu
FROM SourcePackagePu
SourcePack
WHERE SourcePackagePu
AND SourcePackageRe
AND SourcePackagePu
AND SourcePackagePu
AND ($INT=$INT)
ORDER BY SourcePackageRe
Related branches
- Robert Collins (community): Approve
-
Diff: 55 lines (+24/-2)2 files modifieddatabase/schema/security.cfg (+1/-1)
lib/lp/soyuz/model/sourcepackagerelease.py (+23/-1)
description: | updated |
Changed in launchpad: | |
assignee: | nobody → William Grant (wgrant) |
tags: | added: qa-ok |
Changed in launchpad: | |
milestone: | none → 11.04 |
status: | Triaged → Fix Committed |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
This query: blishingHistory .ancestor,
SourcePackagePu blishingHistory .archive,
SourcePackagePu blishingHistory .component,
SourcePackagePu blishingHistory .datecreated,
SourcePackagePu blishingHistory .datemadependin g,
SourcePackagePu blishingHistory .datepublished,
SourcePackagePu blishingHistory .dateremoved,
SourcePackagePu blishingHistory .datesuperseded ,
SourcePackagePu blishingHistory .distroseries,
SourcePackagePu blishingHistory .id,
SourcePackagePu blishingHistory .pocket,
SourcePackagePu blishingHistory .removal_ comment,
SourcePackagePu blishingHistory .removed_ by,
SourcePackagePu blishingHistory .scheduleddelet iondate,
SourcePackagePu blishingHistory .section,
SourcePackagePu blishingHistory .sourcepackager elease,
SourcePackagePu blishingHistory .status,
SourcePackagePu blishingHistory .supersededby,
SourcePackageRe lease.user_ defined_ fields,
SourcePackageRe lease.architect urehintlist,
SourcePackageRe lease.build_ conflicts,
SourcePackageRe lease.build_ conflicts_ indep,
SourcePackageRe lease.builddepe nds,
SourcePackageRe lease.builddepe ndsindep,
SourcePackageRe lease.changelog ,
SourcePackageRe lease.changelog _entry,
SourcePackageRe lease.component ,
SourcePackageRe lease.copyright ,
SourcePackageRe lease.creator,
SourcePackageRe lease.dateuploa ded,
SourcePackageRe lease.dsc,
SourcePackageRe lease.dsc_ binaries,
SourcePackageRe lease.dsc_ format,
SourcePackageRe lease.dsc_ maintainer_ rfc822,
SourcePackageRe lease.dsc_ standards_ version,
SourcePackageRe lease.dscsignin gkey,
SourcePackageRe lease.format,
SourcePackageRe lease.homepage,
SourcePackageRe lease.id,
SourcePackageRe lease.maintaine r,
SourcePackageRe lease.section,
SourcePackageRe lease.sourcepac kage_recipe_ build,
SourcePackageRe lease.sourcepac kagename,
SourcePackageRe lease.upload_ archive,
SourcePackageRe lease.upload_ distroseries,
SourcePackageRe lease.urgency,
SourcePackageRe lease.VERSION blishingHistory , ageRelease blishingHistory .sourcepackager elease = SourcePackageRe lease.id lease.sourcepac kagename = 60982 blishingHistory .distroseries = 103 blishingHistory .archive IN (1,
534) lease.VERSION, SourcePackagePu blishingHistory .datepublished
SELECT SourcePackagePu
FROM SourcePackagePu
SourcePack
WHERE SourcePackagePu
AND SourcePackageRe
AND SourcePackagePu
AND SourcePackagePu
AND (1=1)
ORDER BY SourcePackageRe
has this plan cold:
-------
Sort (cost=37068.
Sort Key: sour...