Archive:+delete timeout deleting PPA
Bug #733803 reported by
Sam Rog
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
Critical
|
William Grant | ||
Bug Description
OOPS-1897ED601 and OOPS-1897H921
in one oops the timeout is driven by deleting doing a massive update:
21. 1963 9527ms SQL-launchpad-
UPDATE SourcePackagePu
SET status = 4,
datesuperseded = CURRENT_TIMESTAMP AT TIME ZONE 'UTC',
WHERE id IN (867539,
... (400 rows).
the other oops this same update was 235ms, so probably contention made it slow here - but we should test.
The oops times out doing repeated SPPH lookups - 41 repeats with an average 300ms duration.
41 12132 295 11837
Related branches
lp:~wgrant/launchpad/archive-defer-deletion
- Steve Kowalik (community): Approve (code)
-
Diff: 324 lines (+110/-52)7 files modifiedlib/lp/archivepublisher/publishing.py (+29/-0)
lib/lp/archivepublisher/tests/test_publisher.py (+32/-0)
lib/lp/soyuz/doc/archive-deletion.txt (+9/-31)
lib/lp/soyuz/interfaces/publishing.py (+5/-3)
lib/lp/soyuz/model/archive.py (+13/-10)
lib/lp/soyuz/model/publishing.py (+16/-8)
lib/lp/soyuz/tests/test_publishing.py (+6/-0)
Revision history for this message
| Robert Collins (lifeless) wrote | #1 |
| summary: |
- The Launchpad is showing the "Timeout error" when trying to delete a - package or trying to delete the PPA + Archive:+delete timeout deleting PPA |
Revision history for this message
| Robert Collins (lifeless) wrote | #2 |
| description: | updated |
| tags: | added: timeout |
| Changed in launchpad: | |
| status: | New → Triaged |
| importance: | Undecided → Critical |
| tags: | added: ppa |
| Changed in launchpad: | |
| assignee: | nobody → William Grant (wgrant) |
| status: | Triaged → In Progress |
Revision history for this message
| Launchpad QA Bot (lpqabot) wrote | #3 |
| tags: | added: qa-needstesting |
| Changed in launchpad: | |
| status: | In Progress → Fix Committed |
| tags: |
added: qa-ok removed: qa-needstesting |
| Changed in launchpad: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
The package deletion timeout is already recorded as bug 590523, I'm going to repurpose this for just the ppa deletion timeout.
Sam, note that deleting a PPA is *permanent*: you cannot get it back, and you cannot use the name again.