lp times out trying to enable a non-virtualized PPA for test rebuilds
Bug #1500973 reported by
Matthias Klose
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Colin Watson |
Bug Description
https:/
Error ID: OOPS-1f186c43b4445213d2776be3cf812f4e
already tried several times, always times out
Related branches
lp:~cjwatson/launchpad/speedup-archive-enable
- William Grant (community): Approve (code)
-
Diff: 52 lines (+17/-5)1 file modifiedlib/lp/soyuz/model/archive.py (+17/-5)
Changed in launchpad: | |
assignee: | nobody → Colin Watson (cjwatson) |
status: | Triaged → In Progress |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
I think we incur a large cost here from rewriting many rows unnecessarily:
launchpad_dogfood=# EXPLAIN (ANALYZE ON, BUFFERS ON) UPDATE BinaryPackageBuild SET virtualized=NOT Processor. supports_ nonvirtualized FROM Processor WHERE BinaryPackageBu ild.archive= 63108 AND BinaryPackageBu ild.status= 0 AND BinaryPackageBu ild.processor= Processor. id;
QUERY PLAN ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---- 47..5659. 90 rows=1528 width=108) (actual time=1667. 053..1667. 053 rows=0 loops=1) Buffers: shared hit=846845 read=1607 dirtied=4576atus=0 AND BinaryPackageBuil -> Hash Join (cost=49. 47..5659. 90 rows=1528 width=108) (actual time=27.692..74.754 rows=19640 loops=1) uild.processor = processor.id) 22..5637. 65 rows=1528 width=101) (actual time=27.659..48.549 rows=19640 loops=1)
Recheck Cond: ((archive = 63108) AND (status = 0))
Buffers: shared hit=8646 ild__archive_ _status_ _date_finished_ _id__idx (cost=0.00..47.84 rows=1528 width=0) (actual time=13.563..13.563 rows=58032 loops=1)
Index Cond: ((archive = 63108) AND (status = 0))
Buffers: shared hit=388
Buckets: 1024 Batches: 1 Memory Usage: 1kB
Buffers: shared hit=1
Buffers: shared hit=1 ild_archive_ fkey: time=357.263 calls=19640 ild__distro_ arch_series_ _fk: time=346.675 calls=19640 ild_distro_ series_ fkey: time=347.908 calls=19640 ild_distributio n_fkey: time=376.901 calls=19640 ild_build_ farm_job_ fkey: time=375.608 calls=19640 ild_processor_ fkey: time=298.695 calls=19640 ild_source_ package_ name_fkey: time=360.448 calls=19640 ild__source_ package_ release_ _fk: time=382.187 calls=19640
-------
Update on binarypackagebuild (cost=49.
Hash Cond: (binarypackageb
Buffers: shared hit=8647
-> Bitmap Heap Scan on binarypackagebuild (cost=48.
-> Bitmap Index Scan on binarypackagebu
-> Hash (cost=1.11..1.11 rows=11 width=11) (actual time=0.017..0.017 rows=11 loops=1)
-> Seq Scan on processor (cost=0.00..1.11 rows=11 width=11) (actual time=0.006..0.010 rows=11 loops=1)
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Trigger for constraint binarypackagebu
Total runtime: 4545.115 ms
(25 rows)
launchpad_dogfood=# EXPLAIN (ANALYZE ON, BUFFERS ON) UPDATE BinaryPackageBuild SET virtualized=NOT Processor. supports_ nonvirtualized FROM Processor WHERE BinaryPackageBu ild.archive= 63108 AND BinaryPackageBu ild.status= 0 AND Binar...