2010-06-05 07:48:26 |
Eleanor Chen |
bug |
|
|
added bug |
2010-06-05 12:50:13 |
Curtis Hovey |
affects |
launchpad |
rosetta |
|
2010-06-07 16:45:02 |
Henning Eggers |
rosetta: status |
New |
Incomplete |
|
2010-06-07 16:45:10 |
Henning Eggers |
tags |
|
oops |
|
2010-06-07 17:21:13 |
Adi Roiban |
rosetta: status |
Incomplete |
New |
|
2010-06-07 17:27:01 |
Adi Roiban |
description |
When accessing either https://translations.edge.launchpad.net/~chenyueg or https://translations.launchpad.net/~chenyueg , I get OOPS-1617EC587. |
An timeout OOPS is generated when accessing the personal translation page on both edge and production
* https://translations.edge.launchpad.net/people/+me
OOPS-1617EC587
OOPS-1619EB1325 - on edge
OOPS-1619B1563 - on stable
|
|
2010-06-15 14:56:29 |
Henning Eggers |
rosetta: status |
New |
Triaged |
|
2010-06-15 14:56:33 |
Henning Eggers |
rosetta: importance |
Undecided |
Medium |
|
2011-01-12 17:48:11 |
Robert Collins |
launchpad: importance |
Medium |
Critical |
|
2011-03-16 05:46:18 |
William Grant |
tags |
lp-translations oops |
lp-translations timeout |
|
2011-03-17 04:19:36 |
Robert Collins |
description |
An timeout OOPS is generated when accessing the personal translation page on both edge and production
* https://translations.edge.launchpad.net/people/+me
OOPS-1617EC587
OOPS-1619EB1325 - on edge
OOPS-1619B1563 - on stable
|
An timeout OOPS is generated when accessing the personal translation page on both edge and production
* https://translations.edge.launchpad.net/people/+me
OOPS-1617EC587
OOPS-1619EB1325 - on edge
OOPS-1619B1563 - on stable
31. 331 10899ms launchpad-main-master
SELECT DISTINCT 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,
POFile.variant
FROM POFile
JOIN POTemplate ON POTemplate.id = POFile.potemplate
AND POTemplate.iscurrent = %s
LEFT JOIN DistroSeries ON DistroSeries.id = POTemplate.distroseries
LEFT JOIN Distribution ON Distribution.id = DistroSeries.distribution
AND Distribution.official_rosetta = %s
AND Distribution.translation_focus = DistroSeries.id
LEFT JOIN ProductSeries ON ProductSeries.id = POTemplate.productseries
LEFT JOIN Product ON Product.id = ProductSeries.product
AND Product.official_rosetta = %s
LEFT JOIN Project ON Project.id = Product.project
JOIN TranslationGroup ON TranslationGroup.id = Product.translationgroup
OR TranslationGroup.id = Distribution.translationgroup
OR TranslationGroup.id = Project.translationgroup
JOIN Translator ON Translator.translationgroup = TranslationGroup.id
AND Translator.LANGUAGE = POFile.LANGUAGE
JOIN TeamParticipation AS Reviewership ON Reviewership.team = Translator.translator
AND Reviewership.person = %s
JOIN POFileTranslator ON POFileTranslator.person = %s
AND POFileTranslator.pofile = POFile.id
AND NOT (POFile.LANGUAGE = %s)
AND POFileTranslator.date_last_touched >= %s
WHERE POFile.unreviewed_count > %s
AND %s
ORDER BY POFile.date_changed LIMIT 45
OFFSET 0 |
|
2011-04-07 10:55:55 |
Robert Collins |
summary |
OOPS-1617EC587 when accessing user's translation page |
Person:+translations timeouts |
|
2011-04-07 10:56:53 |
Robert Collins |
description |
An timeout OOPS is generated when accessing the personal translation page on both edge and production
* https://translations.edge.launchpad.net/people/+me
OOPS-1617EC587
OOPS-1619EB1325 - on edge
OOPS-1619B1563 - on stable
31. 331 10899ms launchpad-main-master
SELECT DISTINCT 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,
POFile.variant
FROM POFile
JOIN POTemplate ON POTemplate.id = POFile.potemplate
AND POTemplate.iscurrent = %s
LEFT JOIN DistroSeries ON DistroSeries.id = POTemplate.distroseries
LEFT JOIN Distribution ON Distribution.id = DistroSeries.distribution
AND Distribution.official_rosetta = %s
AND Distribution.translation_focus = DistroSeries.id
LEFT JOIN ProductSeries ON ProductSeries.id = POTemplate.productseries
LEFT JOIN Product ON Product.id = ProductSeries.product
AND Product.official_rosetta = %s
LEFT JOIN Project ON Project.id = Product.project
JOIN TranslationGroup ON TranslationGroup.id = Product.translationgroup
OR TranslationGroup.id = Distribution.translationgroup
OR TranslationGroup.id = Project.translationgroup
JOIN Translator ON Translator.translationgroup = TranslationGroup.id
AND Translator.LANGUAGE = POFile.LANGUAGE
JOIN TeamParticipation AS Reviewership ON Reviewership.team = Translator.translator
AND Reviewership.person = %s
JOIN POFileTranslator ON POFileTranslator.person = %s
AND POFileTranslator.pofile = POFile.id
AND NOT (POFile.LANGUAGE = %s)
AND POFileTranslator.date_last_touched >= %s
WHERE POFile.unreviewed_count > %s
AND %s
ORDER BY POFile.date_changed LIMIT 45
OFFSET 0 |
1 SELECT DISTINCT POFile.currentcount, POFile.date_changed, POFile.datecreated, POFile.description, ... unreviewed_count > $INT AND POFileTranslator.id IS NULL ORDER BY POFile.id LIMIT $INT OFFSET $INT:
GET: 1 Robots: 0 Local: 1
1 https://translations.launchpad.net/%7Emanywaypark/+translations (Person:+translations)
OOPS-1900J264 |
|
2011-08-03 14:44:26 |
Benji York |
launchpad: assignee |
|
Benji York (benji) |
|
2011-08-05 18:22:01 |
Benji York |
branch linked |
|
lp:~benji/launchpad/bug-590014 |
|
2011-08-06 08:00:43 |
Launchpad QA Bot |
tags |
lp-translations timeout |
lp-translations qa-needstesting timeout |
|
2011-08-06 08:00:44 |
Launchpad QA Bot |
launchpad: status |
Triaged |
Fix Committed |
|
2011-08-08 12:34:19 |
Benji York |
tags |
lp-translations qa-needstesting timeout |
lp-translations qa-ok timeout |
|
2011-08-09 01:03:44 |
Robert Collins |
launchpad: status |
Fix Committed |
Fix Released |
|