Archive:+subscriptions times out with many subscribers

Bug #834303 reported by Anthony Lenton
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Abel Deuring

Bug Description

When trying to access the current list of subscribers to a ppa LP consistently times out:

https://launchpad.net/~commercial-ppa-uploaders/+archive/vendetta-online/+subscriptions

Here are some more oops ids for it:

OOPS-2064AO2
OOPS-2064AW1
OOPS-2064M3
OOPS-2064EB3
OOPS-2064L1
OOPS-2064ED4
OOPS-2064AO3
OOPS-2064AQ4
OOPS-2064C4
OOPS-2064AX1
OOPS-2064DS1
OOPS-2064CP2
OOPS-2064DV1
OOPS-2064DZ2
OOPS-2064K1
OOPS-2064DS3
OOPS-2064EE2
OOPS-2064M4
OOPS-2064CC1
OOPS-2064C5
OOPS-2064L3

Possibly there aren't that many ppas with multi-k subscribers yet, but this is a serious issue for managing commercial ppas where we sometimes need to go in and revoke somebody's subscription (due to a refund, or if the private debline is found on a public forum for instance).

Looking at ppa subscriptions pages it seems that the results there aren't paginated at all, I would imagine having 15k user details on the page would cause these issues. Would it be something that's easy to add?

I believe that ppa is the one with most direct subscribers, but other ppas with multi-k direct subscribers have the same issue:

OOPS-2064DV2 (7.4k subscribers)
OOPS-2064DZ3 (4.8k subscribers)
OOPS-2064E2 (7.5k subscribers)

Tags: qa-ok timeout

Related branches

Revision history for this message
Robert Collins (lifeless) wrote :

Yes, pagination should be straight forward and handle large counts.

You probably want to file a wishlist bug about being able to search though - cause paginating through 15K subscribers is going to take a whillllllle

Changed in launchpad:
status: New → Triaged
importance: Undecided → Critical
tags: added: timeout
Revision history for this message
Anthony Lenton (elachuni) wrote :

Thanks, filed bug #834873 requesting a search option.

Would sorting alphabetically by the user's fullname (or username) be something that could be included as part of this bug? That would let us skim through the list much faster, until the search box is implemented. Or should I file a separate bug for sorting?

Deryck Hodge (deryck)
Changed in launchpad:
assignee: nobody → Launchpad Orange Squad (launchpad-orange-squad)
Abel Deuring (adeuring)
Changed in launchpad:
assignee: Launchpad Orange Squad (launchpad-orange-squad) → Abel Deuring (adeuring)
Revision history for this message
Abel Deuring (adeuring) wrote :

recent OOPSes:
OOPS-b77a8e410cd0f3ab69f24931f5b5e1d7
OOPS-06643a04bf6f7520f612d0786d6ab7bd
OOPS-c3dbef1c6f69a7094e7de0aff808e142
OOPS-d2e5a1b1747c365ad54f4b604d05fb9d
OOPS-7ed9645995db58d3c935b6f56e541ee3
OOPS-8f56c0c0163521704dbadde271602d4c
 OOPS-0937b3d2c55f124287d5874739ac08ea

Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
Abel Deuring (adeuring)
tags: added: qa-ok
removed: qa-needstesting
Steve Kowalik (stevenk)
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