manual build request timeouts for recipes with a gazillion builds

Bug #1770121 reported by Mattia Rizzolo on 2018-05-09
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
Colin Watson

Bug Description

As seen in
https://oops.canonical.com/?oopsid=OOPS-9a2342cb36a60c8641d1dbbda5c70352

[10:46:15 AM] <wgrant> SPRB time estimation is entertaining
[10:46:17 AM] <wgrant> Look at query 36
[10:47:15 AM] <wgrant> We do that calculation in the DB for BPBs
[10:47:22 AM] <cjwatson> right, so SPR.getMedianBuildDuration needs to be 500% less stupid
[10:47:31 AM] <wgrant> There are ~6k builds
[10:47:40 AM] <wgrant> Still shouldn't be quite that slow, but who knows
[10:47:50 AM] <wgrant> Could be security proxy time and such
[10:48:14 AM] <cjwatson> mapreri: basically it's pulling every single build back from the DB and iterating over each one in Python to calculate the median build duration

Related branches

Mattia Rizzolo (mapreri) on 2018-05-09
summary: - manual build request timeouts for recipes with a gazillion builds?
+ manual build request timeouts for recipes with a gazillion builds
Colin Watson (cjwatson) on 2018-05-09
tags: added: lp-code oops timeout trivial
Changed in launchpad:
status: New → In Progress
importance: Undecided → Critical
assignee: nobody → Colin Watson (cjwatson)
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
Colin Watson (cjwatson) on 2018-05-09
tags: added: qa-ok
removed: qa-needstesting
Colin Watson (cjwatson) on 2018-05-09
Changed in launchpad:
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