Launchpad itself

Distribution:+filebug-show-similar/DistributionSourcePackage:+filebug-show-similar timeouts

Bug #618380 reported by Robert Collins
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
High
Unassigned

Bug Description

  4 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... BugTask.bug = Bug.id )) ORDER BY -rank(Bug.fti, ftq($STRING)), BugTask.bug LIMIT $INT OFFSET $INT:
   GET: 3 POST: 1 Robots: 0 Local: 4
      1 https://bugs.launchpad.net/ubuntu/+source/aptdaemon/+filebug-show-similar/d0f37836-4ea7-11e0-a1cf-0025b3df357a (DistributionSourcePackage:+filebug-show-similar)
       OOPS-1900B246
      1 https://bugs.launchpad.net/ubuntu/+source/apt-xapian-index/+filebug-show-similar/dc7b0fe8-4e9d-11e0-a12d-0025b3df357a (DistributionSourcePackage:+filebug-show-similar)
       OOPS-1900H75

See original description
Revision history for this message
Robert Collins (lifeless) wrote :

See also bug 607960 which may be documenting the cause (or may not)

affects: blueprint → malone
Robert Collins (lifeless)
tags: added: pg83
Robert Collins (lifeless)
Changed in launchpad:
importance: High → Critical
Robert Collins (lifeless)
summary: - Distribution:+filebug-show-similar slow in 30% of requests
+ Distribution:+filebug-show-similar/DistributionSourcePackage:+filebug-
+ show-similar timeouts
description: updated
tags: removed: pg83
Revision history for this message
William Grant (wgrant) wrote :

OOPS-bba05d724c1e738ae820e0e2f00dffaf is a recent example. The GIN index lookup is quite slow, probably because there are a lot of very common terms in the query.

satkhira (sattkhirahealth)
Changed in launchpad:
status: Triaged → Fix Committed
status: Fix Committed → Confirmed
status: Confirmed → Opinion
Colin Watson (cjwatson)
Changed in launchpad:
status: Opinion → Triaged
Colin Watson (cjwatson)
Changed in launchpad:
importance: Critical → High
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.