ProductSet:CollectionResource:#projects timeouts
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Robert Collins |
Bug Description
OOPS-1885O2159
https:/
SQL time: 11496 ms
Non-sql time: 2620 ms
Total time: 14116 ms
Statement Count: 271
Death by late evaluation:
1 58 3186 54 3132 SQL-launchpad-
SELECT ProductSeries.
FROM ProductSeries
WHERE ProductSeries.id = $INTLIMIT $INT
2 58 2680 46 2634 SQL-launchpad-
SELECT CommercialSubsc
FROM CommercialSubsc
WHERE CommercialSubsc
3 58 1468 25 1443 SQL-launchpad-
SELECT ProductLicense.id,
FROM ProductLicense
WHERE ProductLicense.
ORDER BY ProductLicense.
4 57 826 14 812 SQL-launchpad-
SELECT OfficialBugTag.tag
FROM OfficialBugTag
WHERE OfficialBugTag.
ORDER BY OfficialBugTag.tag
Related branches
- Steve Kowalik (community): Approve
-
Diff: 234 lines (+79/-58)4 files modifiedlib/lp/bugs/browser/bugalsoaffects.py (+4/-4)
lib/lp/code/model/branchcollection.py (+2/-4)
lib/lp/registry/interfaces/product.py (+12/-6)
lib/lp/registry/model/product.py (+61/-44)
description: | updated |
summary: |
- ProductSet:CollectionResource:#projects timeout on 28th Jan + ProductSet:CollectionResource:#projects timeouts |
Changed in launchpad: | |
assignee: | nobody → Robert Collins (lifeless) |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
The cause is, again, _link generation for API object representations.