lp times out for source package pages with some more binary packages

Bug #1769979 reported by Matthias Klose on 2018-05-08
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
Colin Watson

Bug Description

seen for PPA and archive pages,

https://launchpad.net/~ubuntu-toolchain-r/+archive/ubuntu/ppa/+sourcepub/9073622/+listing-archive-extra
Error ID: OOPS-a47df6f8a1e0f2717939c7877e29e008

https://launchpad.net/ubuntu/+source/gcc-8-cross-ports
OOPS-a0d0c0a5d58ee05b05638b48bf408604

but seen as well for gcc-7 (with less binary packages)

Related branches

Colin Watson (cjwatson) on 2018-05-10
tags: added: lp-soyuz oops timeout
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) wrote :

The page could probably still do with some preloading of Person rows, but it's much faster on staging now.

tags: added: qa-ok
removed: qa-needstesting
Colin Watson (cjwatson) wrote :

This seems to be behaving itself rather better now.

Changed in launchpad:
status: Fix Committed → Fix Released
Matthias Klose (doko) wrote :
Matthias Klose (doko) wrote :

$ date -u
Mi 16. Mai 21:23:57 UTC 2018

https://launchpad.net/~ubuntu-toolchain-r/+archive/ubuntu/ppa/+sourcepub/9073624/+listing-archive-extra
(Error ID: OOPS-a8ae80643b250a3b73b42c75440d1933)

Changed in launchpad:
status: Fix Released → New
Colin Watson (cjwatson) wrote :

The slowest bit of that is in SourcePackageRecordView.built_packages, where it's pulling back well over 3000 very wide rows and then spending 3.5 seconds materialising it all into Python for the sake of two columns. (And then due to a bug in sourcepackagepublishinghistory-listing-archive-extra.pt it tries to do it twice.)

We'd have to add a new method to SPPH with a more focused query, but it shouldn't be too hard to make this a lot faster.

Colin Watson (cjwatson) on 2018-05-16
Changed in launchpad:
status: New → Triaged
Colin Watson (cjwatson) on 2018-05-23
Changed in launchpad:
status: Triaged → In Progress
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
removed: qa-ok
Changed in launchpad:
status: In Progress → Fix Committed
Colin Watson (cjwatson) wrote :

Down to 2-3 seconds on staging (hard to get exact timings for AJAX requests since they don't have the usual instrumentation for staff, unfortunately), so should be happier with the next deployment.

tags: added: qa-ok
removed: qa-needstesting
Colin Watson (cjwatson) on 2018-06-08
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