timeout on bugtask:+index
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Robert Collins |
Bug Description
46 https:/
OOPS-1871A208, OOPS-1871C1576, OOPS-1871C185, OOPS-1871C1851, OOPS-1871C2041
14 https:/
OOPS-1871C1411, OOPS-1871D1166, OOPS-1871D1924, OOPS-1871D1996, OOPS-1871D287
Branch: launchpad-rev-12351
Revno: 12351
SQL time: 9410 ms
Non-sql time: 7162 ms
Total time: 16572 ms
Statement Count: 234
1 5573.0 1 SQL-launchpad-
SELECT MessageChunk.blob, MessageChunk.
FROM BugMessage,
Message,
MessageChunk
WHERE Message.id = MessageChunk.
AND BugMessage.message = Message.id
AND BugMessage.bug = $INT
AND ($INT=$INT)
ORDER BY Message.
2 2246.0 1 SQL-launchpad-
SELECT BugActivity.bug,
FROM BugActivity
WHERE BugActivity.bug = %s
ORDER BY BugActivity.id
1 44 89 2 87 SQL-launchpad-
SELECT Person.account,
Person.icon,
Person.id,
Person.logo,
Person.name,
FROM Person
WHERE Person.id = %sLIMIT $INT
2 40 60 1 59 SQL-launchpad-
SELECT TeamParticipati
FROM TeamParticipation
WHERE TeamParticipati
AND TeamParticipati
Related branches
- Stuart Bishop (community): Approve
-
Diff: 940 lines (+266/-223)12 files modifiedlib/lp/bugs/browser/bugcomment.py (+39/-38)
lib/lp/bugs/browser/bugtask.py (+84/-77)
lib/lp/bugs/browser/tests/bug-views.txt (+5/-4)
lib/lp/bugs/browser/tests/test_bugcomment.py (+33/-31)
lib/lp/bugs/configure.zcml (+1/-1)
lib/lp/bugs/doc/bug.txt (+22/-4)
lib/lp/bugs/doc/bugcomment.txt (+18/-30)
lib/lp/bugs/interfaces/bug.py (+9/-2)
lib/lp/bugs/interfaces/bugmessage.py (+1/-0)
lib/lp/bugs/model/bug.py (+50/-32)
lib/lp/bugs/templates/bugcomment-macros.pt (+1/-1)
lib/lp/bugs/templates/bugtask-index.pt (+3/-3)
tags: | added: pg83 |
Changed in launchpad: | |
milestone: | 10.09 → none |
Changed in launchpad: | |
importance: | High → Critical |
description: | updated |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
SQL time: 4060 ms
Non-sql time: 11654 ms
Total time: 15714 ms
Statement Count: 367
https:/ /bugs.edge. launchpad. net/ubuntu/ +source/ acpi-support/ +bug/59695/ +index
most queries are pretty fast - this is the slowest: main-slave SELECT MessageChunk.blob, MessageChunk. content, MessageChunk.id, MessageChunk. message, MessageChunk. sequence, Message. datecreated, Message.id, Message.owner, Message.parent, Message.raw, Message. rfc822msgid, Message.subject FROM BugMessage, Message, MessageChunk WHERE Message.id = MessageChunk. message AND BugMessage.message = Message.id AND BugMessage.bug = 59695 AND (1=1) ORDER BY Message. datecreated, Message.id, MessageChunk. sequence
115.0 1 launchpad-
And most of the time is in python - probably a formatter. I suggest getting a kcachegrind profile from staging for that url.