Launchpad itself

Launchpad beta timing out three times when I try to access the bug page.

Bug #517798 reported by Isabell Long
20
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Graham Binns
Launchpad itself 10.02

Bug Description

I keep trying to access http://bugs.edge.launchpad.net and three times it has given me the same error, the timeout error, error code OOPS-1497ED764. I suspect this is specific to Launchpad beta, but it's very annoying, I would really like to try my hand at bug triaging! I know I could turn beta redirection off, but I don't really want to just for that! :)

EDIT: 7th Feb 2010: Just an update: This issue is still ongoing.

Thanks,
issyl0

See original description

Related branches

lp:~gmb/launchpad/fix-b.l.n-timeouts-bug-517798
Aaron Bentley (community): Approve
Canonical Launchpad Engineering: Pending (code) requested
Diff: 47 lines (+14/-14)
2 files modified
lib/canonical/launchpad/systemhomes.py (+1/-1)
lib/lp/bugs/stories/bugs/xx-front-page-bug-lists.txt (+13/-13)
Isabell Long (issyl0)
tags: added: beta launchpad timeout
Samuel Tarling (samtarling)
tags: added: launchpad-team
removed: beta launchpad timeout
Isabell Long (issyl0)
tags: added: beta timeout
Curtis Hovey (sinzui)
tags: added: oops
affects: launchpad → malone
Isabell Long (issyl0)
description: updated
Graham Binns (gmb)
tags: removed: beta launchpad-team
Changed in malone:
status: New → Triaged
importance: Undecided → High
Revision history for this message
Graham Binns (gmb) wrote :

This appears to be caused by the query for IMaloneApplication.latest_bugs. Changing the query to sort only on datecreated rather than on datecreated, id appears to stop the query from timing out and spm is cowboying a patch for this onto production and edge.

Changed in malone:
assignee: nobody → Graham Binns (gmb)
status: Triaged → In Progress
Revision history for this message
Isabell Long (issyl0) wrote :

Thank you, it appears to be working now!

Revision history for this message
Diogo Matsubara (matsubara) wrote : Bug fixed by a commit

Fixed in devel r10292 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/devel/revision/10292>

Changed in malone:
status: In Progress → Fix Committed
Graham Binns (gmb)
Changed in malone:
milestone: none → 10.02
Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

Is removing the id from the query's sorting really the right solution? There seem to be multiple queries that suffer from the same problem (though maybe they're all generated by the same single piece of Python code) and you're giving up some determinacy that could possibly break tests sometimes.

I would suggest indexing Bug(datecreated, id) instead, as per bug 518965.

Graham Binns (gmb)
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.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

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