Branch:+index timeouts

Bug #778393 reported by Martin Pool
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself

Bug Description


116. 828 8931ms SQL-launchpad-main-slave
SELECT BranchRevision.branch,
FROM BranchRevision,
WHERE BranchRevision.branch = 24637
  AND = BranchRevision.revision
  AND BranchRevision.sequence IS NOT NULL
ORDER BY BranchRevision.sequence DESC LIMIT 10

Tags: timeout dba
tags: removed: oops
summary: - branch page timeout
+ Branch:+index timeouts
description: updated
Revision history for this message
Robert Collins (lifeless) wrote :

We're rebuilding a replica at the moment, increasing cache pressure substantially.

Cold on qastaging:
                                                                                         QUERY PLAN
 Limit (cost=0.00..144.25 rows=10 width=216) (actual time=17186.667..17257.529 rows=10 loops=1)
   -> Nested Loop (cost=0.00..55348.62 rows=3837 width=216) (actual time=17186.666..17257.525 rows=10 loops=1)
         -> Index Scan Backward using revisionnumber_branch_sequence_unique on branchrevision (cost=0.00..27458.62 rows=3837 width=12) (actual time=17180.528..17180.550 rows=10 loops=1)
               Index Cond: (branch = 24637)
               Filter: (sequence IS NOT NULL)
         -> Index Scan using changeset_pkey on revision (cost=0.00..7.26 rows=1 width=204) (actual time=7.694..7.695 rows=1 loops=10)
               Index Cond: ( = branchrevision.revision)
 Total runtime: 17257.631 ms

revisionnumber_branch_sequence_unique" UNIQUE, btree (branch, sequence)
 - we probably want that to be partial on sequence is not null: most branches in bzr land are non-trunk to one trunk - so while its reporting that it only found 10 rows, it will have examined potentially hundreds.

tags: added: dba
Colin Watson (cjwatson)
Changed in launchpad:
importance: Critical → High
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.