ProjectGroup:+index timeout due to slow query of subprojects
Bug #1016156 reported by
JC Hulce
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Ian Booth |
Bug Description
https:/
(Error ID: OOPS-c182f7f94210ede212ae5b835ef993c7)
SQL time: 12670 ms
Non-sql time: 231 ms
Total time: 12901 ms
Statement Count: 56
served from chaenomeles
count, total, time, savings:
11 9657 877 8780 SQL-main-slave
SELECT Product.
Close inspection shows the query is often fast (4-6ms), but the fatal one at the end was 8.5 seconds - either a repeated case of GIL interaction, or a particularly special DB server behaviour.
Possible causes: cross DC interruption, GIL, $?
Related branches
lp:~wallyworld/launchpad/projectgroup-timeout-1016156
- Curtis Hovey (community): Approve (code)
-
Diff: 323 lines (+63/-35)13 files modifiedlib/lp/answers/browser/faqcollection.py (+1/-1)
lib/lp/answers/browser/questiontarget.py (+1/-1)
lib/lp/blueprints/doc/sprint.txt (+2/-0)
lib/lp/blueprints/model/sprint.py (+14/-7)
lib/lp/registry/browser/announcement.py (+9/-5)
lib/lp/registry/browser/project.py (+1/-1)
lib/lp/registry/browser/tests/pillar-views.txt (+2/-0)
lib/lp/registry/browser/tests/projectgroup-views.txt (+6/-3)
lib/lp/registry/doc/projectgroup.txt (+4/-2)
lib/lp/registry/interfaces/projectgroup.py (+2/-7)
lib/lp/registry/model/projectgroup.py (+19/-6)
lib/lp/registry/templates/hasannouncements-portlet-latest.pt (+1/-1)
lib/lp/translations/browser/project.py (+1/-1)
Changed in launchpad: | |
status: | New → Triaged |
importance: | Undecided → Critical |
summary: |
- Timeout on project main page + ProjectGroup:+index timeout due to repeated queries of all subprojects. |
description: | updated |
summary: |
- ProjectGroup:+index timeout due to repeated queries of all subprojects. + ProjectGroup:+index timeout due to slow query of subprojects |
description: | updated |
Changed in launchpad: | |
status: | Triaged → In Progress |
assignee: | nobody → Ian Booth (wallyworld) |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Fixed in stable r16144 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 16144>.