Product:+code-index timeouts
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Jeroen T. Vermeulen |
Bug Description
23 SELECT Person.account, Person.
3 https:/
OOPS-1857C2215, OOPS-1857E2489, OOPS-1857H1932
Branch: launchpad-rev-12274
Revno: 12274
SQL time: 6374 ms
Non-sql time: 9066 ms
Total time: 15440 ms
Statement Count: 132
SQL time is tolerable; non-sql looks pathological, we may need to get a profile from qastaging.
query 71 -
71. 3238 254ms SQL-launchpad-
SELECT BugBranch.branch,
FROM Bug,
BugBranch
WHERE BugBranch.branch IN (243984,
AND BugBranch.bug = Bug.id
AND (Bug.private = FALSE
OR Bug.id IN
(SELECT Bug.id
FROM Bug,
WHERE Bug.id = BugSubscription.bug
AND TeamParticipati
AND BugSubscription
AND (1=1)
has a 5 second gap before the next query. This is a little hard to explain ;)
Might be GIL, might be simple inefficiency.
Related branches
- Curtis Hovey (community): Approve (code)
- j.c.sackett (community): Approve (code*)
-
Diff: 667 lines (+299/-120)12 files modifiedlib/lp/app/browser/configure.zcml (+6/-0)
lib/lp/app/browser/tales.py (+19/-0)
lib/lp/bugs/interfaces/bugbranch.py (+9/-5)
lib/lp/bugs/model/bugbranch.py (+44/-34)
lib/lp/bugs/tests/test_bugbranch.py (+89/-32)
lib/lp/code/browser/branchlisting.py (+19/-11)
lib/lp/code/browser/tests/test_revisionauthor.py (+82/-0)
lib/lp/code/interfaces/revision.py (+3/-0)
lib/lp/code/model/revision.py (+4/-3)
lib/lp/code/model/tests/test_revision.py (+1/-1)
lib/lp/code/templates/branch-listing.pt (+13/-30)
lib/lp/registry/model/person.py (+10/-4)
Changed in launchpad: | |
assignee: | nobody → Jeroen T. Vermeulen (jtv) |
status: | Triaged → In Progress |
milestone: | none → 11.03 |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Times out when I hit the url in question trivially, so I suspect genuine python rather than temporary overload GIL issues.