ArchiveView.num_pkgs_building is not ready for copy archives
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Michael Nelson |
Bug Description
IArchiveView.
Specifically, the results are being left-joined on a number of tables that are not relevant for this particular calculation (but are used by other call-sites), including LibraryFileAlias and Builder, resulting in a timeout at:
LEFT JOIN Builder ON Builder.id = Build.builder WHERE Build.id IN (%s, %s, %s, %s, %s, %s, %s, %s, %s,... (x1000s for a copy archive that's just been initialized).
I'd suggest we don't try to re-use getBuildsForArchive and instead create a simple query (without pre-joins) that simply groups by SPR. Then we can count the grouped results (after the doing a difference operation for the needs build - (see in num_pkgs_building).
See: OOPS-1350EA464
Related branches
- Julian Edwards (community): Approve
- Diff: None lines
Changed in soyuz: | |
assignee: | nobody → Julian Edwards (julian-edwards) |
Changed in soyuz: | |
assignee: | Julian Edwards (julian-edwards) → Michael Nelson (michael.nelson) |
Changed in soyuz: | |
status: | Triaged → In Progress |
Changed in soyuz: | |
status: | Fix Committed → Fix Released |
Fixed in devel r9487 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ devel/revision/ 9487>