| 2012-12-09 14:31:25 |
Curtis Hovey |
description |
When I click on the "Translations" link on my personal page on launchpad I get this error:
Timeout error
Sorry, something just went wrong in Launchpad.
We’ve recorded what happened, and we’ll fix it as soon as possible. Apologies for the inconvenience.
Trying again in a couple of minutes might work.
(Error ID: OOPS-3234315a32807370758092e5d2918e87) |
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.currentcount,
POFile.date_changed,
POFile.datecreated,
POFile.description,
POFile.from_sourcepackagename,
POFile.fuzzyheader,
POFile.header,
POFile.id,
POFile.LANGUAGE, POFile.lastparsed,
POFile.lasttranslator,
POFile.OWNER, POFile.path,
POFile.potemplate,
POFile.rosettacount,
POFile.topcomment,
POFile.unreviewed_count,
POFile.updatescount
FROM POFile
JOIN POTemplate ON POTemplate.id = POFile.potemplate
AND POTemplate.iscurrent = TRUE
LEFT JOIN DistroSeries ON DistroSeries.id = POTemplate.distroseries
LEFT JOIN Distribution ON Distribution.id = DistroSeries.distribution
AND Distribution.translations_usage = 20
AND Distribution.translation_focus = DistroSeries.id
LEFT JOIN ProductSeries ON ProductSeries.id = POTemplate.productseries
LEFT JOIN Product ON Product.id = ProductSeries.product
AND Product.translations_usage = 20
AND Product.active = TRUE
LEFT JOIN Project ON Project.id = Product.project
LEFT JOIN TranslationGroup ON TranslationGroup.id = Product.translationgroup
OR TranslationGroup.id = Distribution.translationgroup
OR TranslationGroup.id = Project.translationgroup
LEFT JOIN Translator ON Translator.translationgroup = TranslationGroup.id
AND Translator.LANGUAGE = POFile.LANGUAGE
LEFT JOIN TeamParticipation AS Reviewership ON Reviewership.team = Translator.translator
AND Reviewership.person = 909188
LEFT JOIN POFileTranslator ON POFileTranslator.person = 909188
AND POFileTranslator.pofile = POFile.id
AND NOT (POFile.LANGUAGE = 119)
AND POFileTranslator.date_last_touched >= E'2012-09-09 02:00:00+00:00'
WHERE POFile.currentcount+POFile.updatescount+POFile.rosettacount < POTemplate.messagecount
AND POFileTranslator.id IS NULL
AND (COALESCE(Distribution.translationpermission, Product.translationpermission, Project.translationpermission) = 1
OR COALESCE(Distribution.translationpermission, Product.translationpermission, Project.translationpermission) = 20
AND Translator.id IS NULL
OR COALESCE(Distribution.translationpermission, Product.translationpermission, Project.translationpermission) = 100
AND Translator.id IS NOT NULL
AND Reviewership.id IS NULL)
AND POFile.LANGUAGE IN (193,
387,
540,
157)
ORDER BY random() LIMIT 35
OFFSET 0 |
|
