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
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