Launchpad itself

+adminteammerge timing out

Bug #399964 reported by Brad Crittenden
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Brad Crittenden
Launchpad itself 2.2.7

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.

Tags: lp-registry
Revision history for this message
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)
Changed in launchpad-registry:
milestone: 2.2.7 → 2.2.9
Revision history for this message
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)
Changed in launchpad-registry:
status: Triaged → In Progress
Revision history for this message
Ursula Junque (ursinha) wrote :

fixed r8318 in db-devel

Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
Changed in launchpad-registry:
milestone: 3.0 → 2.2.8
Brad Crittenden (bac)
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  
Everyone can see this information.
Subscribing...

Other bug subscribers

Related questions

Remote bug watches

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