Product:EntryResource:get_timeline timeline graph timeout on obsolete-junk project

Bug #671014 reported by Edwin Grubbs on 2010-11-04
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
High
Edwin Grubbs

Bug Description

OOPS-1769S339

SQL time: 6252 ms
Non-sql time: 4630 ms
Total time: 10882 ms
Statement Count: 311

5. 3065 21ms SQL-launchpad-main-master SELECT Milestone.active, Milestone.codename, Milestone.dateexpected, Milestone.distribution, Milestone.distroseries, Milestone.id, Milestone.name, Milestone.product, Milestone.productseries, Milestone.summary FROM Milestone WHERE Milestone.productseries = %s ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC LIMIT 20
6. 3089 18ms SQL-launchpad-main-master SELECT Milestone.active, Milestone.codename, Milestone.dateexpected, Milestone.distribution, Milestone.distroseries, Milestone.id, Milestone.name, Milestone.product, Milestone.productseries, Milestone.summary FROM Milestone WHERE Milestone.productseries = %s ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC LIMIT 20

- its just bad repetitive code.

The https://staging.launchpad.net/obsolete-junk/+series page tries to load a timeline graph with all the obsolete series, which times out. Here is the API call that it is making:
https://staging.launchpad.net/api/devel/obsolete-junk?ws.op=get_timeline&include_inactive=true

The project +index page doesn't have this problem because its timeline graph does not include obsolete series.

Related branches

Curtis Hovey (sinzui) on 2010-11-04
tags: added: timeout
summary: - timeline graph timeout on obsolete-junk project
+ Product:EntryResource:get_timeline timeline graph timeout on obsolete-
+ junk project
description: updated
Curtis Hovey (sinzui) on 2010-11-10
Changed in launchpad-registry:
milestone: 10.11 → 10.12
Changed in launchpad-registry:
status: Triaged → In Progress
tags: added: qa-needstesting
Changed in launchpad-registry:
status: In Progress → Fix Committed
tags: added: qa-ok
removed: qa-needstesting
Curtis Hovey (sinzui) on 2010-12-08
Changed in launchpad-registry:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers