timeout when I click on "Translations" on my personal page

Bug #1087896 reported by Nick Andrik
10
This bug affects 2 people
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.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

Related branches

Curtis Hovey (sinzui)
tags: added: lp-translations timeout
Curtis Hovey (sinzui)
description: updated
Changed in launchpad:
status: New → Triaged
importance: Undecided → Critical
Curtis Hovey (sinzui)
summary: - Error when I click on "Translations" on my personal page
+ timeout when I click on "Translations" on my personal page
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
assignee: nobody → Steve Kowalik (stevenk)
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
Steve Kowalik (stevenk)
tags: added: qa-ok
removed: qa-needstesting
Steve Kowalik (stevenk)
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.