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) |
Revision history for this message
| Launchpad QA Bot (lpqabot) wrote | #1 |
| tags: | added: qa-needstesting |
| Changed in launchpad: | |
| status: | In Progress → Fix Committed |
| 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://