** Tags added: timeout
** Changed in: malone
Status: Incomplete => Triaged
** Changed in: malone
Importance: Undecided => High
** Summary changed:
- The server at bugs.lauchpad.net is taking too long to respond.
+ timeout on source package bug filing page
** Description changed:
- Launchpad needs to increase it's bandwidth.
+ https://lp-oops.canonical.com/oops.py/?oopsid=1655M676
- The connection has timed out.
- Happening a lot.
+ https://bugs.launchpad.net/ubuntu/+source/k3b/+filebug/11305b3c-8e71
+ -11df-8a2d-0025b3df357a
+
+ SQL time: 20293 ms
+ Non-sql time: 96 ms
+ Total time: 20389 ms
+ Statement Count: 31
+
+
+ 27. 351 20005ms launchpad-main-master SELECT
PublishedPackage.archive, PublishedPackage.binarypackagedescription,
PublishedPackage.binarypackagename, PublishedPackage.binarypackagerelease,
PublishedPackage.binarypackagesummary, PublishedPackage.binarypackageversion,
PublishedPackage.build, PublishedPackage.component, PublishedPackage.datebuilt,
PublishedPackage.distribution, PublishedPackage.distroarchseries,
PublishedPackage.distroseries, PublishedPackage.distroseriesname,
PublishedPackage.id, PublishedPackage.packagepublishingstatus,
PublishedPackage.processorfamily, PublishedPackage.processorfamilyname,
PublishedPackage.section, PublishedPackage.sourcepackagename,
PublishedPackage.sourcepackagerelease,
PublishedPackage.sourcepackagereleaseversion FROM PublishedPackage WHERE
PublishedPackage.sourcepackagename = 'k3b' AND
PublishedPackage.binarypackagename = 'k3b' AND PublishedPackage.distribution =
1 AND PublishedPackage.archive IN (1, 534) ORDER BY PublishedPackage.id DESC
LIMIT 1
+
+
+ Limit (cost=35779.49..35779.50 rows=1 width=577) (actual
time=12651.332..12651.333 rows=1 loops=1)
+ -> Sort (cost=35779.49..35779.50 rows=1 width=577) (actual
time=12651.328..12651.328 rows=1 loops=1)
+ Sort Key: securebinarypackagepublishinghistory.id
+ Sort Method: top-N heapsort Memory: 25kB
+ -> Nested Loop (cost=0.00..35779.48 rows=1 width=577) (actual
time=4202.014..12650.884 rows=122 loops=1)
+ -> Nested Loop (cost=0.00..35779.09 rows=1 width=545)
(actual time=4202.003..12650.097 rows=122 loops=1)
+ -> Nested Loop (cost=0.00..35772.66 rows=1 width=541)
(actual time=4201.982..12648.822 rows=122 loops=1)
+ Join Filter: (distroarchseries.distroseries =
distroseries.id)
+ -> Nested Loop (cost=0.00..35772.34 rows=1
width=537) (actual time=331.019..12630.048 rows=1586 loops=1)
+ -> Nested Loop (cost=0.00..35771.42 rows=1
width=509) (actual time=331.004..12620.385 rows=1586 loops=1)
+ Join Filter:
(sourcepackagerelease.sourcepackagename = sourcepackagename.id)
+ -> Nested Loop (cost=0.00..35760.56
rows=14 width=496) (actual time=330.974..12606.370 rows=1586 loops=1)
+ Join Filter:
(securebinarypackagepublishinghistory.section = section.id)
+ -> Nested Loop
(cost=0.00..13124.74 rows=1925 width=480) (actual time=11.666..8416.509
rows=662805 loops=1)
+ -> Index Scan using
sourcepackagename_name_key on sourcepackagename (cost=0.00..6.27 rows=1
width=17) (actual time=0.045..0.048 rows=1 loops=1)
+ Index Cond: (name =
'k3b'::text)
+ -> Nested Loop
(cost=0.00..13099.22 rows=1925 width=463) (actual time=11.615..7521.058
rows=662805 loops=1)
+ -> Nested Loop
(cost=0.00..722.74 rows=1925 width=463) (actual time=11.591..2640.987
rows=662805 loops=1)
+ -> Nested
Loop (cost=0.00..649.24 rows=35 width=453) (actual time=11.577..1234.444
rows=12051 loops=1)
+ ->
Index Scan using distrorelease_distro_release_unique on distroseries
(cost=0.00..6.27 rows=1 width=40) (actual time=8.125..8.171 rows=13 loops=1)
+
Index Cond: (distribution = 1)
+ ->
Nested Loop (cost=0.00..642.62 rows=35 width=413) (actual time=0.314..92.627
rows=927 loops=13)
+ ->
Nested Loop (cost=0.00..627.27 rows=35 width=405) (actual time=0.042..6.105
rows=927 loops=13)
+
-> Index Scan using binarypackagename_name_key on binarypackagename
(cost=0.00..6.29 rows=1 width=28) (actual time=0.016..0.018 rows=1 loops=13)
+
Index Cond: (name = 'k3b'::text)
+
-> Index Scan using binarypackagerelease_binarypackagename_key on
binarypackagerelease (cost=0.00..618.06 rows=233 width=385) (actual
time=0.022..4.486 rows=927 loops=13)
+
Index Cond: (binarypackagerelease.binarypackagename =
binarypackagename.id)
+ ->
Index Scan using binarypackagebuild_pkey on binarypackagebuild
(cost=0.00..0.43 rows=1 width=12) (actual time=0.090..0.090 rows=1 loops=12051)
+
Index Cond: (binarypackagebuild.id = binarypackagerelease.build)
+ -> Seq Scan
on section (cost=0.00..1.55 rows=55 width=10) (actual time=0.002..0.040
rows=55 loops=12051)
+ -> Index Scan using
packagebuild_pkey on packagebuild (cost=0.00..6.42 rows=1 width=8) (actual
time=0.004..0.005 rows=1 loops=662805)
+ Index Cond:
(packagebuild.id = binarypackagebuild.package_build)
+ -> Index Scan using
securebinarypackagepublishinghistory_binarypackagerelease_idx on
binarypackagepublishinghistory securebinarypackagepublishinghistory
(cost=0.00..11.73 rows=2 width=28) (actual time=0.005..0.005 rows=0
loops=662805)
+ Index Cond:
(securebinarypackagepublishinghistory.binarypackagerelease =
binarypackagerelease.id)
+ Filter:
((securebinarypackagepublishinghistory.dateremoved IS NULL) AND
(securebinarypackagepublishinghistory.archive = ANY ('{1,534}'::integer[])))
+ -> Index Scan using
sourcepackagerelease_pkey on sourcepackagerelease (cost=0.00..0.76 rows=1
width=25) (actual time=0.005..0.005 rows=1 loops=1586)
+ Index Cond:
(sourcepackagerelease.id = binarypackagebuild.source_package_release)
+ -> Index Scan using component_pkey on
component (cost=0.00..0.91 rows=1 width=36) (actual time=0.002..0.003 rows=1
loops=1586)
+ Index Cond: (component.id =
securebinarypackagepublishinghistory.component)
+ -> Index Scan using distroarchrelease_pkey on
distroarchseries (cost=0.00..0.30 rows=1 width=12) (actual time=0.009..0.009
rows=1 loops=1586)
+ Index Cond: (distroarchseries.id =
securebinarypackagepublishinghistory.distroarchseries)
+ -> Index Scan using buildfarmjob_pkey on buildfarmjob
(cost=0.00..6.42 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=122)
+ Index Cond: (buildfarmjob.id =
packagebuild.build_farm_job)
+ -> Index Scan using processorfamily_pkey on processorfamily
(cost=0.00..0.38 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=122)
+ Index Cond: (processorfamily.id =
distroarchseries.processorfamily)
+ Total runtime: 12651.862 ms
--
timeout on source package bug filing page
https://bugs.launchpad.net/bugs/602360
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
