Ubuntu

timeout on source package bug filing page (+filebug)

Bug #602360 reported by philinux
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
William Grant
Launchpad itself 10.08
Ubuntu
Invalid
Undecided
Unassigned

Bug Description

https://lp-oops.canonical.com/oops.py/?oopsid=1655M676

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

See original description
Revision history for this message
Elfy (elfy) wrote :

I agree - constant

Changed in ubuntu:
status: New → Confirmed
Revision history for this message
papukaija (papukaija) wrote :

Thank you for taking the time to report this bug and helping to make Launchpadu better. This bug did not have a package associated with it, which is important for ensuring that it gets looked at by the proper developers. You can learn more about finding the right package at https://wiki.ubuntu.com/Bugs/FindRightPackage . I have classified this bug as a bug in launchpad-web.

Changed in launchpad-web:
status: New → Confirmed
Revision history for this message
papukaija (papukaija) wrote :

Actually malone seems to be better.

affects: launchpad-web → malone
Changed in ubuntu:
status: Confirmed → Invalid
Revision history for this message
papukaija (papukaija) wrote :

@forestpiskie: Sorry, you can not confirm a bug which you have submitted.

Changed in malone:
status: Confirmed → New
Revision history for this message
philinux (philcb) wrote :

papukaija please check I philinux raised the bug please change back to confirmed.

papukaija (papukaija)
summary: - Launchpad: The server at bugs.lauchpad.net is taking too long to
- respond.
+ The server at bugs.lauchpad.net is taking too long to respond.
Revision history for this message
Graham Binns (gmb) wrote : Re: The server at bugs.lauchpad.net is taking too long to respond.

@papukaija can you give a specific URL and a specific problem? Do you get a timeout error or does the page just take a while to appear?

There are a multitude of bugs about increasing Launchpad's performance, so it's quite possible that this one has been reported elsewhere. Unfortunately, whilst I appreciate that you're trying to report a problem, at the moment your bug report is too general for us to be able to do much about it.

Changed in malone:
status: New → Incomplete
Revision history for this message
philinux (philcb) wrote :

Err this is my bug what the hell is going on?

Revision history for this message
Graham Binns (gmb) wrote :

@philinux Apologies; I was addressing my comment to the most recent commenter.

Still, my question stands. At the moment your bug report reads:

"Launchpad needs to increase it's bandwidth.

The connection has timed out.
Happening a lot."

Which doesn't really tell us much about the problem that you've encountered. Can you point me at the URL(s) at which you experienced these timeouts?

It's entirely possible that this bug has already been reported, so it's important that we know more about it so we can decide how to tackle it.

Revision history for this message
philinux (philcb) wrote :

I have a link to my bug reports.

https://bugs.launchpad.net/~pc-blackburn

It is always the slowest link of all my bookmarks.

Once I'm in checking on bug links can be slow and you get the "

Page cannot be displayed The connection has timed out." Frequently
Maybe launchpad has a peak period of use I don't know.

Raising a new bug with ubuntu-bug can take ages at the refresh screen.

Revision history for this message
Graham Binns (gmb) wrote :

If you're seeing browser timeouts (i.e. your browser shows a plain timeout message, rather than a Launchpad page telling you that Launchpad couldn't render your request in time) then that suggests that the problem is somewhere in your connection to the Launchpad servers, rather than being a bug in Launchpad itself.

A couple of ways that we could narrow this down:

 1. Try running a traceroute from your machine to launchpad.net, see if there are any obvious points where a lot of traffic is getting lost.
 2. Try from another machine on a different connection, see if the problem persists there.

If, on the other hand, you're seeing Launchpad pages with a timeout message on them, please copy the OOPS ID on the page (which will looks something like OOPS-1206D1076) and paste it into this bug so that we can debug further.

For the record, I can't reproduce this problem; your bugs page renders quite quickly. I don't think there's a peak usage period for Launchpad, though if you're seeing the timeouts within the same 2-hour time window (for example) then that could be the case.

Revision history for this message
Elfy (elfy) wrote :

Philinux and I were both getting the timeout within 30 seconds or so of each other - trying to look at the same bug.

As it stands while timeouts are obviously something that happens from time to time - launchpad bugs very often times out.

Revision history for this message
philinux (philcb) wrote :

Not seeing OOPS ID, just browser timeouts, "Page cannot be displayed, The connection has timed out".

I'll run traceroute next time there's a timeout.

Revision history for this message
papukaija (papukaija) wrote :

@Those who can confirm this bug: For reference you can manage the status of your own bugs by clicking on the current status in the yellow line and then choosing a new status in the revealed drop down box. You can learn more about bug statuses at https://wiki.ubuntu.com/Bugs/Status. Thank you again for taking the time to report this bug and helping to make Ubuntu better. Please submit any future bugs you may find.

Revision history for this message
philinux (philcb) wrote :

Today at 12:32 BST (gmt+1)
Timeout error

Sorry, something just went wrong in Launchpad.

We’ve recorded what happened, and we’ll fix it as soon as possible. Apologies for the inconvenience.

Trying again in a couple of minutes might work.

(Error ID: OOPS-1655M676)

Revision history for this message
Alvin (alvind) wrote :

I get these messages a lot when using Konqueror.

Robert Collins (lifeless)
tags: added: timeout
Changed in malone:
status: Incomplete → Triaged
importance: Undecided → High
summary: - The server at bugs.lauchpad.net is taking too long to respond.
+ timeout on source package bug filing page
description: updated
Revision history for this message
Robert Collins (lifeless) wrote :

This should be fixed by wgrant's publishedpackage nuking which is in db-devel r9628

summary: - timeout on source package bug filing page
+ timeout on source package bug filing page (+filebug)
Changed in malone:
status: Triaged → Fix Committed
assignee: nobody → William Grant (wgrant)
milestone: none → 10.08
William Grant (wgrant)
Changed in malone:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.