manual build request timeouts for recipes with a gazillion builds

Bug #1770121 reported by Mattia Rizzolo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
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)
summary: - manual build request timeouts for recipes with a gazillion builds?
+ manual build request timeouts for recipes with a gazillion builds
Colin Watson (cjwatson)
tags: added: lp-code oops timeout trivial
Changed in launchpad:
status: New → In Progress
importance: Undecided → Critical
assignee: nobody → Colin Watson (cjwatson)
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
Colin Watson (cjwatson)
tags: added: qa-ok
removed: qa-needstesting
Colin Watson (cjwatson)
Changed in launchpad:
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.