timeout when I click on "Translations" on my personal page
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Steve Kowalik |
Bug Description
When I click on the "Translations" link on my personal page on launchpad I get this error:
OOPS-3234315a32807370758092e5d2918e87
The page template is doing late evaluation over a very expensive query that looks similar to 2 fast queries that were previously run by the view.
SELECT POFile.
FROM POFile
JOIN POTemplate ON POTemplate.id = POFile.potemplate
AND POTemplate.
LEFT JOIN DistroSeries ON DistroSeries.id = POTemplate.
LEFT JOIN Distribution ON Distribution.id = DistroSeries.
AND Distribution.
AND Distribution.
LEFT JOIN ProductSeries ON ProductSeries.id = POTemplate.
LEFT JOIN Product ON Product.id = ProductSeries.
AND Product.
AND Product.active = TRUE
LEFT JOIN Project ON Project.id = Product.project
LEFT JOIN TranslationGroup ON TranslationGroup.id = Product.
OR TranslationGroup.id = Distribution.
OR TranslationGroup.id = Project.
LEFT JOIN Translator ON Translator.
AND Translator.LANGUAGE = POFile.LANGUAGE
LEFT JOIN TeamParticipation AS Reviewership ON Reviewership.team = Translator.
AND Reviewership.person = 909188
LEFT JOIN POFileTranslator ON POFileTranslato
AND POFileTranslato
AND NOT (POFile.LANGUAGE = 119)
AND POFileTranslato
WHERE POFile.
AND POFileTranslator.id IS NULL
AND (COALESCE(
OR COALESCE(
AND Translator.id IS NULL
OR COALESCE(
AND Translator.id IS NOT NULL
AND Reviewership.id IS NULL)
AND POFile.LANGUAGE IN (193,
ORDER BY random() LIMIT 35
OFFSET 0
Related branches
- William Grant: Approve (code)
-
Diff: 338 lines (+39/-145)5 files modifiedlib/lp/translations/browser/person.py (+3/-19)
lib/lp/translations/browser/tests/test_persontranslationview.py (+15/-47)
lib/lp/translations/interfaces/translationsperson.py (+1/-10)
lib/lp/translations/model/translationsperson.py (+18/-67)
lib/lp/translations/tests/test_potmsgset.py (+2/-2)
tags: | added: lp-translations timeout |
description: | updated |
Changed in launchpad: | |
status: | New → Triaged |
importance: | Undecided → Critical |
summary: |
- Error when I click on "Translations" on my personal page + timeout when I click on "Translations" on my personal page |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Fixed in stable r16421 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 16421>.