Distribution series index OOPS

Bug #434349 reported by Brad Crittenden
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Guilherme Salgado

Bug Description

Attempting to visit a distribution series page on edge (e.g. https://edge.launchpad.net/ubuntu/karmic) is OOPS-ing.

OOPS-1360EA2293

The queries to gather the milestone information appear to be the culprits.

tags: added: timeout
Revision history for this message
Guilherme Salgado (salgado) wrote :

Actually, the OOPS shows 4s of sql time and 15s of non-SQL time, so it's not yet clear to me what's causing the timeout.

On staging, though, the OOPS (OOPS-1361S7438) shows 18s of SQL time.

Changed in launchpad-registry:
status: Triaged → In Progress
Revision history for this message
Guilherme Salgado (salgado) wrote :

After removing the section which lists milestones from that page, it renders in less than a second, with only 65 queries. And that's on staging, which is a lot slower than edge/lpnet.

Revision history for this message
Curtis Hovey (sinzui) wrote :

The bugtask status counts are the issue. (getting the bugtasks for each milestone is too costly) we can reduce the number of queries by restricting the statuscounts to active milestones

In the example case, there will be only three milestones with status counts. If you change the template that renders the row, you will be change product series and +series

Revision history for this message
Guilherme Salgado (salgado) wrote :

I've done the change suggested by Curtis, to only display the bugs/blueprints summary for active milestones and now the page is rendering in 6s on staging, issuing half the queries it used to.

Changed in launchpad-registry:
status: In Progress → Fix Committed
Changed in launchpad-registry:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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