Branch:+index timeouts
Bug #778393 reported by
Martin Pool
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Triaged
|
High
|
Unassigned |
Bug Description
https:/
OOPS-1952N252
116. 828 8931ms SQL-launchpad-
SELECT BranchRevision.
Revision.id,
FROM BranchRevision,
Revision
WHERE BranchRevision.
AND Revision.id = BranchRevision.
AND BranchRevision.
ORDER BY BranchRevision.
tags: | removed: oops |
summary: |
- branch page timeout + Branch:+index timeouts |
description: | updated |
Changed in launchpad: | |
importance: | Critical → High |
To post a comment you must log in.
We're rebuilding a replica at the moment, increasing cache pressure substantially.
Cold on qastaging:
QUERY PLAN ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------ 667..17257. 529 rows=10 loops=1) 00..55348. 62 rows=3837 width=216) (actual time=17186. 666..17257. 525 rows=10 loops=1) 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 Cond: (revision.id = branchrevision. revision)
-------
Limit (cost=0.00..144.25 rows=10 width=216) (actual time=17186.
-> Nested Loop (cost=0.
-> Index Scan Backward using revisionnumber_
-> 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)
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.