Cannot remove candid github build from build.snapcraft.io
Bug #1828062 reported by
Martin Hilton
This bug affects 2 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
Critical
|
Colin Watson | ||
Bug Description
Attempting to remove the a failing build from builds.snapcraft.io for candid fails with a "504 Gateway Timeout" error response. This apparently maps back to OOPS-bce0b6073e82a642991332eae1aca51d.
Related branches
lp:~cjwatson/launchpad/more-job-indexes
- William Grant (community): Approve (db)
- Stuart Bishop: Pending (db) requested
-
Diff: 13 lines (+9/-0)1 file modifieddatabase/schema/patch-2210-01-1.sql (+9/-0)
Revision history for this message
| Colin Watson (cjwatson) wrote | #1 |
| tags: | added: lp-snappy 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 | #2 |
| tags: | added: qa-needstesting |
| Changed in launchpad: | |
| status: | In Progress → Fix Committed |
Revision history for this message
| Colin Watson (cjwatson) wrote | #3 |
| Changed in launchpad: | |
| status: | Fix Committed → Fix Released |
| Changed in launchpad: | |
| assignee: | Colin Watson (cjwatson) → Eduardo (eddy89) |
| Changed in launchpad: | |
| assignee: | Eduardo (eddy89) → Colin Watson (cjwatson) |
| affects: | launchpad → ubuntu |
To post a comment you must log in.
We think this is probably missing indexes on some of the foreign key references to the Job table, so PostgreSQL is having to do some full table scans to ensure referential integrity when deleting Job rows.