Launchpad itself

hot_bugs view property inefficient, causes timeouts for Ubuntu's bugs homepage

Bug #512749 reported by Eleanor Berger
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Eleanor Berger
Launchpad itself 10.01

Bug Description

bugs.staging.launchpad.net/ubuntu times out trying to read the hot_bugs property. The time is spent in SQL, and we believe it is especially slow because we're lacking an index on bug.heat.

Related branches

lp:~intellectronica/launchpad/backout-hot-bugs-sort
Gary Poster (community): Approve (release-critical)
Deryck Hodge (community): Approve (code)
Diff: 186 lines (+30/-72)
4 files modified
lib/lp/bugs/browser/bugtarget.py (+0/-21)
lib/lp/bugs/browser/bugtask.py (+9/-0)
lib/lp/bugs/stories/bugs/xx-product-bugs-page.txt (+18/-48)
lib/lp/bugs/templates/bugtarget-bugs.pt (+3/-3)
Revision history for this message
Eleanor Berger (intellectronica) wrote :

The cause for this is that we forgot to update the index when renaming the column from hotness to heat.

Revision history for this message
Eleanor Berger (intellectronica) wrote :

Scratch that. The index is actually renamed in the original patch, the cause for this bug must be different.

Changed in malone:
importance: High → Critical
Revision history for this message
Deryck Hodge (deryck) wrote :

We fixed this by reverting the hot_bugtasks to hot_bugs change. Fix is in db-devel now.

Changed in malone:
status: Triaged → Fix Committed
Ursula Junque (ursinha)
tags: added: current-rollout-blocker
removed: oops
Eleanor Berger (intellectronica)
Changed in malone:
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.