+adminteammerge timing out

Bug #399964 reported by Brad Crittenden on 2009-07-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
High
Brad Crittenden

Bug Description

When submitting to https://staging.launchpad.net/people/+adminteammerge we consistently get a timeout and OOPS such as OOPS-1292EC251.

It appears to be ValidTeamVocabulary issuing a terrible query.

Curtis Hovey (sinzui) wrote :

This can be workon in week 4 since this bug can be closed when the fix arrived on edge.

Changed in launchpad-registry:
assignee: nobody → Brad Crittenden (bac)
importance: Undecided → High
milestone: none → 2.2.7
status: New → Triaged
Curtis Hovey (sinzui) on 2009-07-17
Changed in launchpad-registry:
milestone: 2.2.7 → 2.2.9
Brad Crittenden (bac) wrote :

From Stuart:

SELECT COUNT (*)
FROM (
  SELECT Person.*
  FROM Person
  LEFT OUTER JOIN (
      SELECT DISTINCT EmailAddress.person
      FROM EmailAddress
      WHERE lower(EmailAddress.email) LIKE 'john%')
      AS EmailAddress ON Person.id = EmailAddress.person
  WHERE
      Person.teamowner IS NOT NULL
      AND Person.visibility IN (1, 30)
      AND (
          EmailAddress.person IS NOT NULL
          OR Person.fti @@ ftq('john'))
  ORDER BY displayname, name
  LIMIT 100) AS whatever

Brad Crittenden (bac) on 2009-07-22
Changed in launchpad-registry:
status: Triaged → In Progress
Ursula Junque (ursinha) wrote :

fixed r8318 in db-devel

Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui) on 2009-07-28
Changed in launchpad-registry:
milestone: 3.0 → 2.2.8
Brad Crittenden (bac) on 2009-07-29
Changed in launchpad-registry:
status: Fix Committed → Fix Released
milestone: 2.2.8 → 2.2.7
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related questions