Launchpad itself

LanguageSet:CollectionResource:#languages and LanguageSet:CollectionResource:#languages:getAllLanguages timeouts

Bug #728174 reported by Robert Collins
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
William Grant
Launchpad itself 11.03

Bug Description

Showed up in the march 2nd oops report, but no oopses in the summary - need to grep for them on devpad.

Tags: qa-ok timeout

Related branches

lp:~wgrant/launchpad/bug-728174
Robert Collins (community): Approve
Diff: 287 lines (+161/-40)
3 files modified
lib/lp/services/worlddata/interfaces/language.py (+5/-3)
lib/lp/services/worlddata/model/language.py (+96/-34)
lib/lp/services/worlddata/tests/test_language.py (+60/-3)
Revision history for this message
William Grant (wgrant) wrote :

OOPS-1891A15

Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

Spends all its time counting contributors per language based on the karma cache:

SELECT COUNT(*)
FROM KarmaCache,
     KarmaCategory,
     Person,
     PersonLanguage
WHERE PersonLanguage.person = Person.id
  AND PersonLanguage.LANGUAGE = <language_id>
  AND KarmaCache.person = Person.id
  AND KarmaCache.product IS NULL
  AND KarmaCache.project IS NULL
  AND KarmaCache.sourcepackagename IS NULL
  AND KarmaCache.distribution IS NULL
  AND KarmaCache.category = KarmaCategory.id
  AND KarmaCategory.name = 'translations'
  AND (1=1)

A simple "GROUP BY PersonLanguage.person" would probably fix this.

William Grant (wgrant)
Changed in launchpad:
assignee: nobody → William Grant (wgrant)
status: Triaged → In Progress
Robert Collins (lifeless)
summary: - LanguageSet:CollectionResource:#languages timeouts
+ LanguageSet:CollectionResource:#languages and
+ LanguageSet:CollectionResource:#languages:getAllLanguages timeouts
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r12540 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/12540>.

Changed in launchpad:
milestone: none → 11.03
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant)
tags: added: qa-ok
removed: qa-needstesting
Curtis Hovey (sinzui)
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.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

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