*:+bugs timeouts searching for tags

Reported by Robert Collins on 2011-03-16
54
This bug affects 6 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
William Grant

Bug Description

  6 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... ING)) AND Bug.private = FALSE ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
   GET: 6 Robots: 0 Local: 5
      3 https://bugs.launchpad.net/bugs/+bugs (MaloneApplication:+bugs)
       OOPS-1948AV219, OOPS-1948AW270, OOPS-1948CC233

Related branches

description: updated
Robert Collins (lifeless) wrote :

 SELECT COUNT(*)
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active
JOIN Bug ON BugTask.bug = Bug.id
WHERE Bug.id = BugTask.bug
  AND ((BugTask.status = 10)
       OR (BugTask.status = 15)
       OR (BugTask.status = 20)
       OR (BugTask.status = 21)
       OR (BugTask.status = 22)
       OR (BugTask.status = 25))
  AND Bug.duplicateof IS NULL
  AND (Bug.fti @@ ftq('firefox'))
  AND (Bugtask.product IS NULL
       OR Product.active = TRUE)
  AND Bug.private = FALSE;

is 1.7s on staging, so not trivially explicable in prod

description: updated
summary: - MaloneApplication:+bugs timeouts
+ MaloneApplication:+bugs timeouts searching all bugs
description: updated
summary: - MaloneApplication:+bugs timeouts searching all bugs
+ MaloneApplication:+bugs timeouts searching for tags across all bugs
summary: - MaloneApplication:+bugs timeouts searching for tags across all bugs
+ *:+bugs timeouts searching for tags
Robert Collins (lifeless) wrote :

Bah, somewhere along the line I went crazy apparently; this bug wasn't tag related. However, all the dupes are; and this bug is a one-off, so I'm going to subsume it.

William Grant (wgrant) on 2012-04-28
Changed in launchpad:
assignee: nobody → William Grant (wgrant)
William Grant (wgrant) on 2012-04-30
Changed in launchpad:
status: Triaged → In Progress
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant) on 2012-05-03
tags: added: qa-ok
removed: qa-needstesting
William Grant (wgrant) on 2012-05-03
Changed in launchpad:
status: Fix Committed → Fix Released
Curtis Hovey (sinzui) on 2012-07-12
tags: added: disclosure sharing
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers