Archive:+subscriptions times out with many subscribers
| 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:/
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)
Related branches
- j.c.sackett (community): Approve
- Richard Harding (community): Approve (code*)
-
Diff: 217 lines (+88/-13)6 files modifiedlib/lp/soyuz/browser/archivesubscription.py (+18/-7)
lib/lp/soyuz/doc/archivesubscriber.txt (+5/-2)
lib/lp/soyuz/model/archivesubscriber.py (+9/-3)
lib/lp/soyuz/stories/ppa/xx-private-ppa-subscription-stories.txt (+2/-0)
lib/lp/soyuz/templates/archive-subscribers.pt (+5/-1)
lib/lp/soyuz/tests/test_archivesubscriptionview.py (+49/-0)
| Robert Collins (lifeless) wrote | #1 |
| Changed in launchpad: | |
| status: | New → Triaged |
| importance: | Undecided → Critical |
| tags: | added: timeout |
| Anthony Lenton (elachuni) wrote | #2 |
| Changed in launchpad: | |
| assignee: | nobody → Launchpad Orange Squad (launchpad-orange-squad) |
| Changed in launchpad: | |
| assignee: | Launchpad Orange Squad (launchpad-orange-squad) → Abel Deuring (adeuring) |
| Abel Deuring (adeuring) wrote | #3 |
| Launchpad QA Bot (lpqabot) wrote | #4 |
| tags: | added: qa-needstesting |
| Changed in launchpad: | |
| status: | Triaged → Fix Committed |
| tags: |
added: qa-ok removed: qa-needstesting |
| Changed in launchpad: | |
| status: | Fix Committed → Fix Released |
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