Cannot remove candid github build from build.snapcraft.io

Bug #1828062 reported by Martin Hilton
12
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

Revision history for this message
Colin Watson (cjwatson) wrote :

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.

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 :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
Revision history for this message
Colin Watson (cjwatson) wrote :

The indexes seem to have done the trick.

Changed in launchpad:
status: Fix Committed → Fix Released
Eduardo (eddy89)
Changed in launchpad:
assignee: Colin Watson (cjwatson) → Eduardo (eddy89)
Colin Watson (cjwatson)
Changed in launchpad:
assignee: Eduardo (eddy89) → Colin Watson (cjwatson)
Eduardo (eddy89)
affects: launchpad → ubuntu
Revision history for this message
Colin Watson (cjwatson) wrote :

Eduardo, please stop making spurious bug changes, or we may need to suspend your account for vandalism.

affects: ubuntu → launchpad
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers