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

Bug #1769979 reported by Matthias Klose
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
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)
tags: added: lp-soyuz oops timeout
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
Revision history for this message
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
Revision history for this message
Colin Watson (cjwatson) wrote :

This seems to be behaving itself rather better now.

Changed in launchpad:
status: Fix Committed → Fix Released
Revision history for this message
Matthias Klose (doko) wrote :
Revision history for this message
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
Revision history for this message
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)
Changed in launchpad:
status: New → Triaged
Colin Watson (cjwatson)
Changed in launchpad:
status: Triaged → In Progress
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
removed: qa-ok
Changed in launchpad:
status: In Progress → Fix Committed
Revision history for this message
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)
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.