+distrotask timeout
Bug #609012 reported by
Micah Gersten
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
William Grant |
Bug Description
(Error ID: OOPS-1665ED640)
Was attempting this:
https:/
Added firefox and got the oops
Try 2:
(Error ID: OOPS-1665EA660)
Try 3 worked :)
SQL time: 14207 ms
Non-sql time: 221 ms
Total time: 14428 ms
Statement Count: 25
description: | updated |
description: | updated |
Changed in malone: | |
status: | New → Triaged |
importance: | Undecided → High |
description: | updated |
tags: | removed: oops |
Changed in malone: | |
status: | Triaged → Fix Committed |
assignee: | nobody → William Grant (wgrant) |
milestone: | none → 10.08 |
Changed in malone: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
261 14003ms launchpad- main-master SELECT PublishedPackag e.archive, PublishedPackag e.binarypackage description, PublishedPackag e.binarypackage name, PublishedPackag e.binarypackage release, PublishedPackag e.binarypackage summary, PublishedPackag e.binarypackage version, PublishedPackag e.build, PublishedPackag e.component, PublishedPackag e.datebuilt, PublishedPackag e.distribution, PublishedPackag e.distroarchser ies, PublishedPackag e.distroseries, PublishedPackag e.distroseriesn ame, PublishedPackag e.id, PublishedPackag e.packagepublis hingstatus, PublishedPackag e.processorfami ly, PublishedPackag e.processorfami lyname, PublishedPackag e.section, PublishedPackag e.sourcepackage name, PublishedPackag e.sourcepackage release, PublishedPackag e.sourcepackage releaseversion FROM PublishedPackage WHERE PublishedPackag e.sourcepackage name = 'firefox' AND PublishedPackag e.binarypackage name = 'firefox' AND PublishedPackag e.distribution = 1 AND PublishedPackag e.archive IN (1, 534) ORDER BY PublishedPackage.id DESC LIMIT 1
this performs inconsistently, and slowly at best.
Time: 362.676 ms is the best I got out of it on staging.
this is a bad one: 90..419. 91 rows=1 width=582) (actual time=36657. 518..36657. 519 rows=1 loops=1) 90..419. 91 rows=1 width=582) (actual time=36657. 514..36657. 514 rows=1 loops=1) kagepublishingh istory. id 453..36657. 057 rows=79 loops=1) 258..36479. 947 rows=1474 loops=1)
Join Filter: (distroarchseri es.processorfam ily = processorfamily.id)
-> Nested Loop (cost=2.80..416.94 rows=2 width=530) (actual time=32932. 241..36456. 794 rows=1474 loops=1)
Join Filter: (component.id = securebinarypac kagepublishingh istory. component)
- > Nested Loop (cost=2.80..414.63 rows=2 width=502) (actual time=32932. 227..36436. 532 rows=1474 loops=1)
Join Filter: (section.id = securebinarypac kagepublishingh istory. section)
-> Nested Loop (cost=2.80..410.15 rows=2 width=500) (actual time=32932. 166..36315. 251 rows=1474 loops=1)
-> Nested Loop (cost=2.80..397.47 rows=2 width=496) (actual time=32932. 149..36300. 168 rows=1474 loops=1)
Join Filter: (distroseries.id = distroarchserie s.distroseries)
-> Seq Scan on distroseries (cost=0.00..2.38 rows=1 width=40) (actual time=0.022..0.092 rows=13 loops=1)
Filter: (distribution = 1)
-> Hash Join (cost=2.80..394.46 rows=51 width=460) (actual time=475. 780..2791. 158 rows=1474 loops=13)
Hash Cond: (securebinarypa ckagepublishing history. distroarchserie s = distroarchserie s.id)
.. .
Limit (cost=419.
-> Sort (cost=419.
Sort Key: securebinarypac
Sort Method: top-N heapsort Memory: 25kB
-> Nested Loop (cost=2.80..419.89 rows=1 width=582) (actual time=32965.
-> Nested Loop (cost=2.80..419.30 rows=2 width=562) (actual time=32932.