Archive:EntryResource:getBuildSummariesForSourceIds times out
Bug #662523 reported by
Fabien Tassin
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Robert Collins |
Bug Description
1751ED2047 https:/
SQL time: 12977 ms
Non-sql time: 470 ms
Total time: 13447 ms
Statement Count: 113
Potato programming:
for source_pub in source_pubs:
The slow query performance certainly isn't helping, but the basic driver is this scaling per requested source build.
Related branches
lp:~lifeless/launchpad/getBuildSummariesForSourceIds
- Tim Penhey (community): Approve
-
Diff: 249 lines (+99/-49)3 files modifiedlib/lp/soyuz/adapters/archivesourcepublication.py (+2/-1)
lib/lp/soyuz/interfaces/publishing.py (+18/-2)
lib/lp/soyuz/model/publishing.py (+79/-46)
summary: |
- [regression] lp API at least 3 times slower and timeouts all the time + Archive:EntryResource:getBuildSummariesForSourceIds times out |
tags: | added: dba timeout |
tags: | removed: dba |
description: | updated |
Changed in soyuz: | |
status: | New → Triaged |
importance: | Undecided → High |
description: | updated |
description: | updated |
Changed in soyuz: | |
assignee: | nobody → Robert Collins (lifeless) |
status: | Triaged → In Progress |
Changed in soyuz: | |
status: | Fix Committed → Fix Released |
tags: | added: qa-ok |
Changed in soyuz: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Yet another PG8.4 regression.